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

query.PNG

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

Microsoft-Partner-Network-Logo_transpare

© MYPE.  All rights reserved

  • Facebook - Gris Cercle
  • Twitter - Gris Cercle
  • LinkedIn - Gris Cercle
  • YouTube - Gris Cercle