Safran Aircraft Engines — Industrial Division & Investment Steering · 2025
Steering 300+ industrial investments from a single dashboard
Power BI dashboards and automated data flows to monitor a portfolio of more than 300 CAPEX files.
investment files monitored
manual data-entry errors
business teams aligned
The challenge
Investment tracking relied on manually consolidated spreadsheets. Re-keying multiplied errors, and each team had its own version of the numbers, slowing down decisions.
The approach
- 1Gathered steering needs from the three business teams and defined shared KPIs.
- 2Automated data collection and formatting with Python (pandas, openpyxl).
- 3Built a Power BI data model (Power Query, DAX) and dashboards for each decision level.
- 4Deployed on Power BI Service and supported users through adoption.
Solution architecture
Sources
Investment tracking files and business extracts
Automation
Python scripts for collection, checks and normalisation
Modelling
Star schema in Power Query, DAX measures
Delivery
Shared Power BI Service dashboards
The results
- Roughly 90% of manual data-entry errors eliminated.
- One reliable view of the portfolio for three business teams.
- Continuous monitoring of 300+ investment files.
What this project shows
“A dashboard is only as valuable as the data feeding it: upstream automation drives downstream adoption.”
These projects were led by Datasium's founder during assignments and internships before the firm was founded. Figures are those observed at the end of each assignment.