MYPE inserted sample data in this example, not to disclose any confidential information.

Client : Orange IMT (Innovation Marketing et Technologies), Technocentre

Project duration : 2 months

Location : Orange Gardens, Châtillon

​Project background : data import (Orange applications) from an Excel file to a cloud-based interface

Use Power Query ETL to extract data, transform it and load it on the cloud. DataSource is an Excel file that contains critical data about Orange applications in all countries. The file originally has 2k rows per tab, but since data is unpivoted in Power Query it has around 100k rows per tab.

Tremendous transformation process applied to make data visualization possible from the file.

Client Benefits :

-use of  an Excel file data visualisation (with Power BI) without having to modify its format

-automation of a long data extraction & transformation process that occurs each month (3+ man/days) 

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