Top right decoration pattern Bottom left decoration pattern

Dashboard

Go further with Power Query and the M language

Intermediate

This training course mainly takes place in the Power Query query editor in Power BI Desktop, but the concepts learned can easily be transferred to the Power Query query editor in Excel. It teaches advanced techniques for acquiring, transforming, and consolidating data using automated queries and is aimed at users who need to handle large amounts of unstructured data. It also teaches how to reconstruct databases from information available on different websites using web scraping techniques.

To take this training course, it is strongly recommended that you have either:

• Completed the Power BI training course (level 3) or achieved a score of over 70% in the online pre-test

  • Import, transform, and consolidate complex unstructured data
  • Reconstruct databases from information available on different websites using web scraping techniques
  • Analyze complex business issues using a few practical data transformation recipes in M language

Détails

French

6 heures

Accès pendant 3 mois

Évaluation sommative requise

400,00 $CA
zod_errors.undefined

Cursus

Formule d’apprentissage et accompagnement

Online self-paced training. You can follow the lessons and exercises at any time, 24/7, for the duration of your access. A tutor is available by email.

Clientèle visée

The target audience is professionals who need to work with different sources of unstructured data. The training will mainly be taught using the Power Query query editor in Power BI Desktop, but everything taught in this training can be transferred to the Power Query query editor in Excel. It is also aimed at anyone who wants to complete the learning path in Reports and Dashboards in Power BI.

Certificat ou attestation

Training certificate issued upon request to FormateurPlus, following validation of the student's successful completion of the course.

Soyez à l’affût des nouveautés.

Abonnez-vous à notre infolettre pour recevoir nos actualités, conseils et exclusivités directement dans votre boîte courriel !