PHARMACY PULSE DASHBOARD REPORT

📊 Executive Summary

The Pharmacy Pulse Dashboard provides a comprehensive performance overview of a European pharmacy chain operating across multiple countries, regions, and cities. The analysis covers revenue, cost, profit, margin, sales volume, product performance, geographic performance, and promotional effectiveness over a one-year period.

Overall performance shows positive growth, with total revenue of €8.63M, total cost of €6.21M, and total profit of €2.42M, reflecting steady year-on-year increases across key financial metrics. Sales volume reached 445,790 units, also demonstrating upward momentum. Performance varies significantly across regions, cities, product categories, and promotional status, highlighting clear opportunities for targeted optimization rather than broad, uniform strategies.

📝 Business Problem

Despite overall strong financial performance, the business faces several key challenges:

• Uneven geographic performance: Some regions and cities generate significantly higher revenue and margin than others.

• Inconsistent product profitability: Certain product categories and brands perform far better than others.

• Lack of targeted decision-making: Leadership needs clearer insights to prioritize investments, marketing, and inventory management efficiently.

Core Business Question: 👉 How can the pharmacy chain maximize profitability while improving underperforming regions, products, and promotional strategies?

🔍 Key Insights

Financial Performance

• Revenue, cost, and profit all increased by approximately 4.6–5% over the year.

• Profit margin remains healthy but could be further optimized by reducing costs in low-margin regions and products.

Geographic Performance

Top-performing regions (Revenue & Margin):

• Lombardy (Italy)

• Hamburg (Germany)

• Utrecht (Netherlands)

• Wallonia (Belgium)

• Bavaria (Germany)

These areas combine high sales volume with strong margins, suggesting efficient operations and strong market demand.

Lowest-performing regions:

• Nouvelle-Aquitaine (France)

• Veneto (Italy)

• Provence-Alpes-Côte d'Azur (France)

• Community of Madrid (Spain)

• Brussels-Capital (Belgium)

These regions may suffer from lower demand, higher costs, or weaker market penetration.

City Performance

Strongest Cities:

• Milan

• Hamburg

• Utrecht

• Liège

• Munich

Weakest Cities:

• Bordeaux

• Venice

• Marseille

• Madrid

• Brussels

This suggests that performance is influenced not only by country but also by city-level dynamics such as population density, competition, and local healthcare policies.

Urban vs. Suburban vs. Rural Performance

• Urban areas show the highest revenue and margin.

• Suburban areas perform moderately well.

• Rural areas lag behind in both sales volume and profitability.

This indicates that marketing and expansion efforts should prioritize urban and high-density suburban locations.

Product Category Performance

Best-performing categories:

• Wellness

• OTC (Over-the-counter medicines)

• Prescription medicines

Lower-performing categories:

• Medical devices

• Personal care

This suggests that demand is stronger for health-focused and essential products rather than supplementary medical items.

Promotions Impact

• Promotions significantly boost sales volume.

• However, margin impact varies—some promotions increase profit while others reduce it.

• This indicates the need for more data-driven promotional planning rather than blanket discounts.

Brand Performance

High-margin brands tend to also have higher sales volume, meaning the company should prioritize:

• Expanding successful brands

• Reducing investment in weak brands

• Potentially discontinuing consistently low-margin products

🎯 Methodology

The analysis was conducted using:

• Power BI Dashboard visualization

• Descriptive analytics to summarize performance trends

• Comparative analysis across regions, cities, and products

• Time-series analysis to track monthly revenue and margin trends

• Performance segmentation by geography, product category, and promotion status

• Cross-analysis of sales volume vs. margin to identify profitable vs. unprofitable segments

Data sources included transactional pharmacy sales records across multiple European regions.

🛠️ Skills Demonstrated

This dashboard and analysis demonstrate proficiency in:

• Power BI (data visualization, dashboard design, interactivity)

• Business Intelligence (BI)

• Data Analytics & Interpretation

• Financial Analysis (Revenue, Cost, Margin, Profit)

• Geospatial Analysis

• Sales Performance Analytics

• Data Storytelling

• Decision Support Analytics

These skills are highly relevant for roles in data analysis, business intelligence, and analytics consulting.

💡 Recommendations

Strategic Recommendations

Prioritize High-Performing Regions

• Invest more in Lombardy, Hamburg, Utrecht, Wallonia, and Bavaria.

• Expand store presence or marketing in these areas.

Improve Low-Performing Regions

• Conduct deeper analysis into why regions like Nouvelle-Aquitaine and Brussels underperform.

• Consider localized pricing, marketing, or partnership strategies.

Optimize Promotions

• Shift from blanket discounts to targeted promotions based on product profitability.

• Avoid promotions that reduce margin significantly.

Focus on High-Margin Product Categories

• Increase stock and marketing for Wellness, OTC, and Prescription products.

• Reduce inventory of low-performing categories like medical devices.

City-Level Expansion Strategy

• Expand in high-performing cities like Milan and Hamburg.

• Reassess strategy in weaker cities like Bordeaux and Brussels.

Data-Driven Decision Making

• Continue using dashboards for real-time performance monitoring.

• Implement predictive analytics to forecast demand and optimize inventory.

🏁 Conclusion

The Pharmacy Pulse Dashboard reveals a strong overall business performance but highlights important regional, product, and promotional disparities. By leveraging these insights, the pharmacy chain can improve profitability, streamline operations, and drive smarter growth.

The key takeaway is that success does not require doing more everywhere. It requires doing more of the right things in the right places.