MYPE inserted sample data in this example, not to disclose any confidential information.
Client : Saft Batteries (a Total company), Strategy and Transformation Department
Project duration : 6 months
Location : Levallois-Perret
Project background : Development of a complex request in order to extract simultaneously data from 13 Excel files hosted on SharePoint Online
This Power Query - M code gets data from SharePoint to Power Query / Power BI. Thanks to Query Parameters, 13 files (of the same structure) are extracted as if they were one single file. After that, data from Tab1 and Tab2 of these files are merged to build complex visualizations that Saft needed.
Client Benefits :
-agregation / consolidation of data from 13 files (each file having data in 2 tabs), into 1 tool (Power Query)
-while having different format, different name, and different position, data are successfully merged