Skip to content

Power BI Pharma Sales Dashboard! Analyzed 11.8B sales (2017–2020) with YoY growth, top products, distributors, cities, and team performance. Insights include lonclotide as top product, Gerlach LLC as leading distributor, and Zwickau as best city.

Notifications You must be signed in to change notification settings

Zohaib-Azeem/Pharma-Sale-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Power BI Pharma Sales Dashboard - Sales, Strategy & Insights

Excited to share my latest interactive dashboard built in Power BI, analyzing pharmaceutical sales performance over four years (2017-2020). This project dives deep into:

Total Sales vs Year-over-Year (YoY) growth

Top-performing Products & Distributors

Sales by Product Class and City-wise Insights

Sales Breakdown by Hospital vs Pharmacy

Sales Team Performance and Manager-wise contribution

Geographical Analysis across Germany & Poland

Key Highlights:

🔹11.8B in total sales analyzed

🔹Top Product: lonclotide with 169M in sales

🔹2018: Highest Sales Year - Rs3.5 Billion

🔹Gerlach LLC: Top Distributor - Leading Market Share

🔹Jimmy Grey: Star Performer - Rs986 Million Sales

🔹Zwickau: Best Performing City - Rs24 Million Revenue

Visual storytelling using custom DAX measures, KPIs, maps, and filters

Tools Used:

Power BI Desktop, DAX, Data Modeling, Interactive Visuals

This project helped me sharpen my data visualization, analytical storytelling, and insight-driven reporting skills.

Feel free to share your feedback or suggestions. Let's connect and grow together in data!

hashtag#LinkedInProjects hashtag#AnalyticsCommunity hashtag#BIProfessionals hashtag#DataScience hashtag#DataSkills hashtag#Practice hashtag#PortfolioProject hashtag#PharmaAnalytics hashtag#HealthcareAnalytics hashtag#PharmaceuticalSales hashtag#SalesDashboard hashtag#PowerBI hashtag#DataAnalytics hashtag#Pharmalnsights hashtag#DataVisualization hashtag#BusinessIntelligence hashtag#DAX hashtag#Dashboard hashtag#DataStorytelling hashtag#DashboardDesign hashtag#DataDriven hashtag#Dashboard hashtag#PowerBi hashtag#Design hashtag#DataFam hashtag#PowerBI hashtag#Data Analytics hashtag#DataVisualization hashtag#OnyxData hashtag#DashboardDesign hashtag#Storytelling WithData hashtag#AnalyticsInAction hashtag#DataDNA hashtag#DataChallenge hashtag#ZoomCharts hashtag#BusinessIntelligence hashtag#DataStorytelling hashtag#PowerQuery hashtag#DAX hashtag#InteractiveVisuals hashtag#Sales

About

Power BI Pharma Sales Dashboard! Analyzed 11.8B sales (2017–2020) with YoY growth, top products, distributors, cities, and team performance. Insights include lonclotide as top product, Gerlach LLC as leading distributor, and Zwickau as best city.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published