Pharmaceutical Sales Data Analysis

Overview

The Pharma Drug Sales Dashboard is a comprehensive project developed using Power BI to analyze and visualize pharmaceutical sales data. This dashboard offers critical insights into sales performance across various timeframes and categories, making it an invaluable tool for decision-makers in the pharma industry.

Features

Key Visualizations:

• Weekly Contribution by N02BE Sales
• Monthly Trends in Yearly Sales
• Daily, Weekly, and Monthly Sales Breakdown
• Hourly Sales Performance by Category

Highlights:

• Interactive Visuals: Easily filter and explore data through slicers and tooltips.
• Comprehensive Insights: Covers daily, weekly, monthly, and yearly sales trends.
• Professional Design: Clean layout with carefully chosen color schemes (e.g., Dodger Blue shades) for better clarity and aesthetics.

Tools and Technologies

• Power BI: For creating and visualizing the dashboard.
• Data Analysis: Applied various techniques to extract meaningful insights from the raw data.

Screenshots

1. DrugFlow Analytics

2. Average Sales Monthly Overview

3. Comprehensive Sales Overview - Daily, Weekly, And Monthly

4. Daily Sales Contribution by Category

5. Hourly Count N02BE Sales

6. Hourly Sales Breakdown By Category

7. Model Views

8. Monthly Sales Insights - Total vs Average

9. Monthly Trends in Yearly Sales

10. Quarterly Sales Breakdown By Category 1

11. Quarterly Sales Breakdown By Category 2

12. Sales Daily

13. Sales Hourly

14. Sales Monthly

15. Sales Weekly

16. Total Sales Monthly Overview

17. Weekly Contribution N02BE Sales

18. Weekly Sales Breakdown By Category

19. Yearly Sales Trends by Category 1

20. Yearly Sales Trends by Category 2

Key Insights

• N02BE Weekly Contribution: Identified high-performing weeks based on drug sales.
• Yearly Trends: Visualized how sales evolve across months and years.
• Hourly Analysis: Highlighted peak sales times for various drug categories.

Learning Outcomes

• Enhanced proficiency in Power BI for data visualization.
• Gained experience in creating interactive dashboards.
• Improved storytelling skills through data representation.

How to Use

1. Import the Power BI File:
   • Open the .pbix file in Power BI Desktop.
   • Connect it to your data source (if applicable).
2. Interact with the Dashboard:
   • Use slicers and filters to explore different dimensions of the data.
   • Hover over visuals for detailed insights via tooltips.

Acknowledgements

Special thanks to all who provided guidance and resources to complete this project. Constructive feedback is always welcome to help improve the design and functionality of the dashboard.

Connect with Me

If you're looking for a passionate Power BI Developer, Data Analyst, or Dashboard Designer, feel free to connect with me on LinkedIn or reach out via email.

---

Tags

#PowerBI #PharmaDashboard #DataVisualization #Analytics #DataAnalysis