Question: Following is data structure with data description of sales data of a pharma company OrderID: Unique identifier for each order. ProductID: Unique identifier for each

Following is data structure with data description of sales data of a pharma company

OrderID: Unique identifier for each order.

ProductID: Unique identifier for each product.

ProductName: Name of the pharmaceutical product.

Category: Product category (e.g., Prescription Drugs, Over-the-Counter).

UnitPrice: Price per unit of the product.

Quantity: Number of units sold.

Discount: Discount applied to the order.

OrderDate: Date when the order was placed.

CustomerID: Unique identifier for each customer.

CustomerName: Name of the customer.

Region: Sales region (e.g., East, West, South, North).

Subcategory: Further categorization of the product.

Manufacturer: Manufacturer of the product.

TotalPrice: Total price of the order (UnitPrice * Quantity - Discount).

CustomerType: Type of customer (e.g., Hospital, Pharmacy, Retail).

RepID: Unique identifier for the sales representative.

RepName: Name of the sales representative.

You are expected to create BLUE Print ( and blue print only) that analyzes sales data for a this pharma company. Include visualizations such as total sales, top-selling products, sales by region, and trend analysis. Utilize slicers to allow users to filter data by date, product category, and region

Your dashboard blueprint should answer some of the following questions

  • What are the Total Sales for the Current Quarter compared to the Previous Quarter?

  • Which Products are the Top Sellers for the Last Month?

  • What is the Sales Distribution by Region for the Current Year?

  • How has the Monthly Sales Trend been for the Last 12 Months?

  • What is the Average Deal Size for each Sales Rep this Quarter?

  • Which Customer Segments are contributing the most to Total Revenue?

  • What is the Conversion Rate for Leads to Deals?

  • Which Sales Channel is Performing the Best in terms of Revenue?

  • What is the Sales Performance for each Product Category this Quarter?

  • How do Sales for this Quarter compare to the Sales Target ?

Following is sample of actual data for your reference.

OrderIDProductIDProduct NameCategorySubcategoryManufacturerUnit PriceQuantityDiscountTotalPriceOrderDateCustomerIDCustomerNameCustomerTypeRegionRepIDRepName 101P001Medicine APrescription DrugsOral MedicationPharmaCorp501000.145001/15/2023C001PharmaPlusHospitalEastR001John Smith 102P002Medicine BPrescription DrugsInjectablesHealthMeds Inc.35500.051662.52/2/2023C002HealthyMedsPharmacyWestR002Sarah Johnson 103P003Medicine COver-the-CounterVitamins & SupplementsMediCare Labs202000.232002/18/2023C003MediCareMartRetailEastR003Michael Brown 104P001Medicine APrescription DrugsOral MedicationPharmaCorp50150075003/10/2023C004QuickPharmaPharmacySouthR004Emily Davis 105P004Medicine DPrescription DrugsInjectablesMediHealth Solutions60750.142754/5/2023C005PharmaCareHospitalEastR001John Smith 106P002Medicine BPrescription DrugsInjectablesHealthMeds Inc.3580028005/12/2023C006WellnessDrugsRetailWestR002Sarah Johnson 107P005Medicine EOver-the-CounterAnalgesicsMediHealth Labs152500.1526256/8/2023C007MediHealthHospitalSouthR005David Miller 108P003Medicine COver-the-CounterVitamins & SupplementsMediCare Labs20100020006/25/2023C008MediLifePharmacyWestR006Anna Wilson 109P004Medicine DPrescription DrugsInjectablesMediHealth Solutions601200.0568407/14/2023C009PharmaPlusHospitalEastR001John Smith 110P005Medicine EOver-the-CounterAnalgesicsMediHealth Labs153000.140508/3/2023C010HealthyMedsRetailWestR002Sarah Johnsson

OrderIDProductIDProduct NameCategorySubcategoryManufacturerUnit PriceQuantityDiscountTotalPriceOrderDateCustomerIDCustomerNameCustomerTypeRegionRepIDRepName 101P001Medicine APrescription DrugsOral MedicationPharmaCorp501000.145001/15/2023C001PharmaPlusHospitalEastR001John Smith 102P002Medicine BPrescription DrugsInjectablesHealthMeds Inc.35500.051662.52/2/2023C002HealthyMedsPharmacyWestR002Sarah Johnson 103P003Medicine COver-the-CounterVitamins & SupplementsMediCare Labs202000.232002/18/2023C003MediCareMartRetailEastR003Michael Brown 104P001Medicine APrescription DrugsOral MedicationPharmaCorp50150075003/10/2023C004QuickPharmaPharmacySouthR004Emily Davis 105P004Medicine DPrescription DrugsInjectablesMediHealth Solutions60750.142754/5/2023C005PharmaCareHospitalEastR001John Smith 106P002Medicine BPrescription DrugsInjectablesHealthMeds Inc.3580028005/12/2023C006WellnessDrugsRetailWestR002Sarah Johnson 107P005Medicine EOver-the-CounterAnalgesicsMediHealth Labs152500.1526256/8/2023C007MediHealthHospitalSouthR005David Miller 108P003Medicine COver-the-CounterVitamins & SupplementsMediCare Labs20100020006/25/2023C008MediLifePharmacyWestR006Anna Wilson 109P004Medicine DPrescription DrugsInjectablesMediHealth Solutions601200.0568407/14/2023C009PharmaPlusHospitalEastR001John Smith 110P005Medicine EOver-the-CounterAnalgesicsMediHealth Labs153000.140508/3/2023C010HealthyMedsRetailWestR002Sarah Johnson

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Following is data structure with data description of sales data of a pharma company OrderID: Unique identifier for each order. ProductID: Unique identifier for each product. ProductName: Name of the...

Q:

ACCT20081 Practical Assessment REQUIREMENTS You are a member of an audit team of ABC Distribution Company. A computer-based sales system is used by the company. You are provided with three SAS data...

Q:

Software requirements engineering 1. Introduction Bella is a simple e-commerce website based on the marketplace model that sells goods and earns revenue from commission . It is facilitating to bring...

Q:

The country chosen for part A is England. the product is J Ray and Nephew. The product is white Overproof Rum. Any assistance will be dreatky appreciated. INSTRUCTION: 1. In groups of no more than...

Q:

could you please help me it is accounting information system problem in power BI I can not download the excel file in order to solve the problem could you please help me in this assignment? In order...

Q:

Northern Medical Supplies Inc. ( Northern ) is a small, family - run business in northern Ontario that has been in business for almost 2 0 years. Northern sells medical supplies to small and medium -...

Q:

ACCT 240 GST Big Data Project Information Fall 2021 Tanakas Medical Supplies It is September 2021 and you have just started your new position with Tanakas Medical Supplies (TMS) as the assistant...

Q:

An Entity Relationship Diagram for the scenario. Please do not worry about squeezing information in each of the boxes. You only need name the entity. In a separate table below, you should provide the...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Overview: In this assignment, you are given a database and a set of information requests. Use SQL commands to extract the required data, export it , and then apply data visualization techniques to...

Q:

Suppose users share a 2 Mbps link. Also suppose each user transmits continuously at I Mbps when transmitting, but each user transmits only 20 percent of the time. (See the discussion of statistical...

Q:

The rate of flow in this pipe system is 0.05 m/s. The pressure at point 2 is measured to be 238 Pa. The pipe is laid on a downslope with pt 1 at a height of 115 m above pt 2. All the pipes are...

Q:

What type of budget framework is most commonly in use today?

Q:

please answer only if you know programming language is c++ For this lab, your objective is to define the functions below. Define the void function SwapNodes () that takes three generic type Node...