Portfolio Detail

Pharmacy Sales & Profitability Analysis

Power BI Report

Pharmacy Sales & Profitability Analysis

Growth is easy to see. Profitability can be harder to protect. This report explores the performance of a pharmacy network across Europe through two critical lenses: scale and sustainability. Across regions, store formats, and product categories, I examined not just where revenue is generated but also how efficiently it converts into profit. From high performing pharmacies to category level dynamics, the analysis uncovers where volume and margin align and where they begin to diverge. A product may sell well, but does it strengthen profitability? A promotion may drive traffic, but at what cost? At the heart of the report is a key question: Are promotions fueling growth or quietly eroding margin? By measuring Promotional Margin Erosion, we quantify the profitability trade-off between full price and discounted sales and track how this pressure evolves. Combined with unit performance and margin distribution insights, the report highlights which categories and pharmacies lead, which lag, and where pricing strategy demands attention. This is not just a performance review, It is a strategic lens into the balance between growth and profitability, because sustainable performance is not just about selling more, it’s also about selling smarter.

Skills & Tools Used:

Power BI Zoomcharts

Share this Project:

Get In Touch

Contact our team

    name

    email

    number

    Pre-estimated budget

    Message

    locations

    Office Address

    16 Upper Woburn Place, London, Greater London, WC1H 0AF, United Kingdom

    call

    Telephone number

    +44 204 534 7858
    Loader