Real time Power BI & Excel Project, Apollo Pharmacy Sales Dashboard #powerbi #powerbidashboard

In this video, we will build an analyst-level Apollo-style Pharmacy Sales Dashboard in Power BI from scratch. This is Part 1 of the complete dashboard series, where we will cover everything from raw data preparation to the final design of Page 1. You will learn: ✅ Importing and cleaning the pharmacy sales dataset in Power Query ✅ Correcting data types and checking data quality ✅ Creating a staging query and disabling its load ✅ Creating Fact and Dimension tables ✅ Building a proper Star Schema ✅ Creating a Date Table and relationships ✅ Writing business-focused DAX measures ✅ Creating Month-on-Month KPIs with dynamic arrows ✅ Designing an executive-style dashboard page ✅ Building trend analysis, heat map, Pareto chart and decomposition tree ✅ Adding drill-through and interactive analysis This dashboard is designed to answer real business questions related to revenue, gross margin, discount impact, store performance, product contribution, returns and customer purchasing trends. 📂 Download Project Files https://drive.google.com/drive/folder... 📌 Part 2    • Apollo Pharmacy Power BI Dashboard Part 2 ...   Subscribe to Awesome Analytics for practical Power BI, SQL and data analytics projects. #Dataanalytics #Powerbi #excel