Analysis of the European Pharmacy Sales Dataset
In this project for Onyx Data, I conducted a comprehensive analysis of the pharmacy chain dataset spanning January 2024 to December 2025. The dataset covers 8 European countries, 38 regions, 120 pharmacy stores, 5 product categories (Prescription, OTC, Wellness, Personal Care, Medical Devices), and 32 brands (sub-categories).
Using Tableau, I connected the four core tables (Sales, Date, Pharmacy, Product), established relationships and built an interactive Pharmacy Sales and Profitability Dashboard. The dashboard includes dynamic filters (date range, country, region, city, pharmacy, category, brand, store size, promo flag), drill-down hierarchies, and visualizations to directly address burning business questions.
Key Insights Delivered
? Overall Performance & Growth Total: 446K Units Sold, 8.63M? Revenue, 2.42M? Profit. 2025 vs 2024: +4.68% units, +4.43% revenue, +4.93% profit (strong summer peaks in May?July).
? Geographic Breakdown Top revenue leaders: Germany (1.57M?, 18.16%), France (1.41M?), Italy (1.33M?).
? Urban pharmacies drive 48% of total revenue, Suburban 38%, Rural 18%. Store-size split:
? Store Size Performance: Medium stores (M) = 44%, Large (L) = 37%, almost doubled Small (S) = 19%.
? Product & Brand Performance: Prescription category leads with 2.80M? (32.40%) of revenue. Top 4 brands by revenue: AntiBioX, GlucoSafe, NeuroMed and DermRx - all belonging to the Prescription category.
? ZenHealth (Wellness product) leads the highest profit margin with 35.3% followed by FreshLine (PersonalCare product) Identified ?Stars? (high-revenue + high-margin) and ?Volume Leaders? (high-volume + low-margin) via scatter plots.
? Promo Efficiency: Promoted sales represent ~12% of volume but only ~8% of profit which shows that either purchases were organic or the wrong products were promoted.
? Store-Level Outperformers & Underperformers Regional leaders and underperformers are clearly shown with the Teal colour (e.g., Munich HealthPoint #095: 162K?, Utrecht HealthPoint #058 :159K? Milan HealthPoint #085:135K?) while Underperformers flagged in orange for immediate action.
? Seasonality & Trends Dual-year monthly trend lines show 2025 consistently above average, with clear summer seasonality.
? Geographic Patterns Interactive Europe map (drillable to region ? city ? pharmacy) reveals concentrated revenue in Italy (Lombardy), Germany (Hamburg), and France.
The dashboard is fully interactive (the interactive instructions as sub-titles) and included a
?Reset All Filters? button for easy exploration. All visuals were designed to answer some strategic business questions, enabling stakeholders to identify growth opportunities, optimize promotions, prioritize high-performing locations, and focus on star brands.