This Power BI report uses the Pharmacy Sales and Profitability dataset. The report features ZoomCharts Drill Down PRO custom visuals for Power BI. It was submitted to the Onyx Data DataDNA ZoomCharts Mini Challenge in January - February 2026.

Author’s Description:

Interactive Power BI dashboard analyzing European pharmacy sales performance across countries, regions, and product categories.

The report follows a three-page structure: Executive Overview (KPIs, trends, geographic and pharmacy type performance), Product & Geographic Intelligence (portfolio analysis, heat maps, and regional insights), and Advanced Analytics (a comprehensive drill-down table with more than 40 metrics).

Key features include 58+ custom DAX measures with time intelligence calculations (YoY, QoQ, MoM, YTD), a seven-level drill-down hierarchy (Country → Region → City → Pharmacy → Category → Brand → Product), volume versus margin quadrant analysis for portfolio optimization, promotion impact analysis, and pharmacy type benchmarking.

The dashboard also incorporates rich conditional formatting, interactive tooltips, and mobile-optimized views, and is designed to support strategic decision-making in pharmaceutical retail operations.