Pharmacy Sales and Profitability Analysis

Summary

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:

Pharmacy Sales & Profitability Analysis Dashboard: This Power BI project analyzes pharmacy sales performance across products, regions, and promotion strategies, reporting €8.63M in total revenue, €2.42M in total profit, and a 28.04% profit margin. The dashboard explores sales and profit trends over time, product-level profitability, promotion impact on margin, generic versus non-generic performance, and regional contribution. The analysis reveals that a small group of products drives a significant share of total profit, promotional sales generate lower margins, and Germany leads in total contribution while Austria records the highest profit margin. The primary objective was to identify profit drivers, margin risks, underperforming segments, and optimization opportunities to support data-driven decision-making.