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).


  • 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.


  • 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.