Data · 2021 – 2023
Sanofi DIVE programme
Consultant and senior developer on a programme covering sales growth, competitor performance, market trends, net sales and budget forecasting.
5
decision areas, one model
- 5
- decision areas
- 1
- governed model
- US + EU
- stakeholders
Problem
Five different questions, five different audiences, one expectation: the numbers agree with each other. Sales growth, competitor performance, market trends, net sales and budget forecasting had historically lived in separate reports with separate definitions.
Approach
One governed semantic model with shared measures, then five report surfaces on top of it. Requirements were gathered directly with US and EU stakeholders and delivered in agile increments so definitions could be argued about early, not after launch.
The craft
The dual role mattered: sitting in the requirement conversations meant the model was shaped by how people would actually ask the questions, not by how the source tables were laid out.
Result
Delivered end to end and recognised with formal client appreciation from Sanofi stakeholders.
Stack
- Power BI
- DAX
- SQL
- Agile delivery