Pharmaceutical Sales & Distribution Dashboard

**Power BI Pharmaceutical Sales Analytics Dashboard**

I recently completed an end-to-end **Power BI project** focused on developing a comprehensive sales analytics and business intelligence solution for a pharmaceutical company.

**Project Highlights:**

* Imported, transformed, and prepared raw datasets using **Power Query**

* Cleaned and optimized the data by handling missing values, trimming text, removing duplicates, creating conditional columns, and applying appropriate data types

* Built a structured **data model** to support multi-level sales analysis

* Developed key DAX measures and KPIs including:

* Total Sales

* Total Sold Orders & Return Orders

* Average Order Value (AOV)

* Total Transactions

* Designed a **multi-level dashboard architecture** to provide different analytical perspectives for various stakeholders

* Built an **Executive Sales Overview** focusing on overall sales performance, top-performing cities, sales trends over time, and geographic distribution across Europe

* Built a **Sales Manager Overview** analyzing distributor performance, top customers, return orders, and sales channels including Retail, Hospital, Pharmacy, Government, and Institution

* Built a **Head of Sales Overview** highlighting sales team contributions, manager performance, and individual sales representative achievements

* Added interactive **Slicers and Dynamic Filtering** for Year, Month, and Manager

* Designed interactive visualizations including **Stacked Bar Charts, Donut Charts, Heat Maps, and Dynamic Top-5 Rankings**

* Created dashboards that allow stakeholders to explore sales performance from **enterprise, distributor, manager, and sales representative levels**

**Goal:**

To transform complex pharmaceutical sales and distribution data into an interactive business intelligence solution that supports performance monitoring, deeper sales analysis, and data-driven decision-making across different management levels.

**Tools & Technologies:**

**Power BI | Power Query | DAX | Data Modeling | Data Visualization | Business Intelligence | Pharmaceutical Sales Analytics**

This project helped me strengthen my practical skills in **Data Analysis, Business Intelligence, DAX, Power Query, and developing executive-ready Power BI dashboards** while translating complex business requirements into clear and actionable data visualizations.

#PowerBI #DataAnalysis #BusinessIntelligence #DAX #PowerQuery #DataVisualization #Pharmaceuticals #SalesAnalytics #Dashboard #DataAnalytics #MicrosoftPowerBI