Elior
Business issue: How to promote strategic decision-making based on usable data?
Solutions deployed : Azure Data Factory, Microsoft Power BI
Results: Modernisation of BI uses and tools
Pain points
- Multiple and heterogeneous data sources for the purchasing departments of European entities.
- Difficulties in reporting at group level (duration, reliability, homogeneity).
Solution
- Development of views (SQL) on all local management systems.
- Copy of local data into an Azure cloud environment (ETL Data Factory, Azure SQL database).
- Development of a single Power BI report for the Purchasing department containing all local data.
Results
- Increase in the frequency of data updates (Monthly update vs. Annual before project).
- Unified data base for the Purchasing department’s BI.
- Limiting human actions on data processing for group reporting.