MS Power BI from A to Z

December 14 - 21 2021
Training Cost
1.506 EUR (VAT ex.) per person

This training qualifies for the SME e-wallet (KMO-portefeuille).

Practical informationClass from 9 AM to 5.30 PM

Most of our classroom training courses take place in Belgium (Edegem) or The Netherlands (Breda). Please click the button with the desired date to check the exact location of the training.

This training in-company?
Upon your request we can organize this training for you.

2 days

Course overview

Microsoft Power BI is a powerful platform that allows you to analyze and visualize data quickly and easily, and to share reports and analyses. It also allows you to work on both your desktop and in the cloud in an intuitive way. Power BI is one of the only Business intelligence software that is also user-friendly, so that any analyst can learn to work with it quickly. During our two-day training, you learn how to work with all components of the Microsoft Power BI suite (Power BI Desktop, Power BI Query, Power BI DAX functions, Power BI .com), so that you can make interesting reports, analyses and visually attractive dashboards.

Who should attend this training

This training is primarily aimed at (financial) analysts and controllers who don’t know Microsoft Power BI suite yet, and want to learn the possibilities (analysing, visualizing and presenting).

Course Objectives

After this training, you will have a solid knowledge of the different Power BI components:

  • With Power BI Desktop, you can make your own analyses and reports based on different data sources (databases, websites, Excel-files, …)

  • With Power Query, you can process imported data from diverse sources (atabases, Excel, internet, text) which allows you to convert your data to useable data.

  • DAX functions help you to process your data.

  • Power BI .com allows you to adapt your Power BI Desktop reports, but it also allows you to publish and share these reports with your colleagues in a structured way.


Prior knowledge of pivot tables and Excel functions is required, or completion of the training Microsoft BI: Introduction to the Power platform.

Course Content
  • Introduction: overview of the “Power BI” components

    • Installation (+ versions)

    • Power Bi files

    • Power Query (in Power BI Desktop)

    • Power BI DAX

    • Power BI Visuals

    • Power BI .com

  • Powerquery

    • Connect to Data Sources

      • Excel

      • Text

      • SQL Server

      • Internet

    • Functionality differences between data sources

      • Import

      • DirectQuery

    • Data Cleaning

      • Removing empty rows

      • Converting text to numbers

    • Data Transformation

      • Gegevens samenvoegen

      • Unpivot

    • Intro tot M language (M macro-taal)

  • Power BI desktop

    • The interface of Power BI

    • Relations between tables in Power BI

    • DAX column calculations

    • Dax Measures

    • Dax: the concept “context”

    • Power BI Visuals: graphs, tables, etc

    • Power BI custom Visuals

    • Power BI Previews

    • Power BI Introductie to R

    • Power BI Monthly Updates system

  • Power

    • Publishing Power BI

    • Insights, Q&A

    • Power BI .com: dashboards, reports and tiles

    • Power BI sharing, user roles

  • Diverse: links with Excel, templates, …

  • Informative websites: E-learning, …

This training in-company?
Upon your request we can organize this training for you.