Power BI
Intermediate
The workshop content is presented in the form of 3 practical cases (simulations + demonstrations of solutions in Power Query and Power Pivot). For each case, the learner will have to use Power Query to connect to the data, transform it if necessary and then load it into Power Pivot. Then he will have to create a data model, measures and finally a pivot table in Excel to display the results. Following each case, the trainer will explain the best method to solve the scenario by punctuating everything with tips and tricks to optimize performance, a review of the concepts learned during previous training courses and how to approach them according to the situations.
To follow this training, it is strongly recommended to have followed the following 2 training courses: Introduction to Power Query and the M language and Introduction to Power Pivot and data models.
French
6 heures
Accès pendant 3 mois
Computer, Tablet, Mobile
Évaluation sommative requise
Training offered online in self-study mode. You can follow the lessons and exercises at any time, 24/7, for the duration of your access. A tutor is available by email.
The target audience is professionals who use Excel as part of their duties and who work with different data sources, structured and unstructured, in an analysis, reporting or dashboard context and who wish to benefit from Excel's BI functionalities in order to further automate their solutions.
This training is a complement to the following training courses: Introduction to Power Query and the M language and Introduction to Power Pivot and data models And to the following 10-course learning path: Excel - Dashboards.
Training certificate issued upon request from FormateurPlus, and following validation of the student’s success.
Abonnez-vous à notre infolettre pour recevoir nos actualités, conseils et exclusivités directement dans votre boîte courriel !
