PharmaLens is a comprehensive, data-driven dashboard designed to analyze and visualize pharmaceutical sales performance. It provides critical insights across key business dimensions, enabling stakeholders to track product performance, evaluate sales team efficiency, and understand geographical contributions to overall sales.
The project is built upon the Pharma_Sales_Dataset and focuses on transforming raw sales data into actionable business intelligence.
The analysis is based on the pharma-data dataset , which aims to analyze pharmaceutical sales performance across products, teams, and geographies.
| Main Dimensions | Main Measures |
|---|---|
| Channel | Sales |
| Country | Quantity |
| City | Price |
| Distributor | Distributors |
| Product Name | Customers |
| Product Class | |
| Manager, Month, Year |
The dashboard is divided into two primary, high-value sections: Sales Overview and Product Performance.
Goal: To provide a high-level view of overall sales performance and identify top performers.
-
Key Performance Indicators (KPIs):
- Total Sales: 7bn
- Total Quantity: 17M
- Total Distributors: 27
- Total Customers: 751
-
Main Visuals: KPI cards, Sales Trend, Sales by Channel over time, .
-
Key Insights: The dashboard highlights the top-performing cities (e.g., Wedel, Trier, Freising) and distributors (e.g., Gerlach LLC, Koss) , confirming effective and balanced distribution channels.
Goal: To provide a deep-dive analysis into product and product class performance.
-
Key Performance Indicators (KPIs):
- Total Products: 241
- Average Price: 414
- ]Average Sales per Product: 29M
- Top Product Sales: 74M
-
Key Visuals:
- Total Quantity by Sales Team: Delta is the top team (31.62% or 5M).
- Total Sales by Product Class: Analgesics and Antiseptics show the highest total sales.
- Total Sales and Cumulative % by Product Name: A Pareto-style analysis of top products (e.g., Propra..., Cepho...).
-
Detailed Product Table: Provides a breakdown of sales, quantity, and average price for individual products across Hospital and Pharmacy channels, summing up to a total of over 1.24 Billion in sales.
