Saurabhkt10/africa-pharma-market-dashboard

Power BI dashboard analyzing pharma market sales across 12 African countries — includes a galaxy schema data model, custom DAX time-intelligence measures, and a redesigned dark-theme visual layout. # Africa Pharma Market Dashboard Power BI dashboard analyzing pharmaceutical market sales across 12 African countries, built on IQVIA-style market audit data (~10 lakh rows, 50+ SKUs). ## Overview This project tracks total market value, YoY growth, and contribution analysis by country, company, and therapeutic class (ATC1), with a focus on both data modeling accuracy and visual clarity. ## Data Model Built as a galaxy schema (not a single star) — one Fact table connected to Country, Date, and Product dimensions, with a bridge table handling the many-to-many relationship between Products and Molecules. ## Dashboard ## Key technical work **Fixed a DAX time-intelligence bug** — the YoY% measure was silently conflicting with a standalone Year column filter, causing distorted results at period boundaries. Fixed using `REMOVEFILTERS()` to isolate the filter context: ```dax Previous year = CALCULATE( [Total Market Value], REMOVEFILTERS(Dim_Date[Year]), SAMEPERIODLASTYEAR(Dim_Date[Date]) ) ``` **Redesigned the visual layer** — custom dark theme (navy + teal + gold), conditional formatting on KPI cards, ranked bar charts instead of raw tables, and a filled map for geographic distribution. ## Tools used Power BI, DAX, Power Query ## Note Screenshots only — no underlying data or `.pbix` file included, as the source data is proprietary.