Microsoft BI: Introduction to the Power platform

November 25 2021
Training Cost
806 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.

1 day

Course overview

Starting from version 2013, Excel contains sveral BI possibilities and help programs that you can use to collect, visualize and analyze data. This is a real “self service Bi solution”.

On the one hand, there are a number of powerful BI tools within Excel that allow you to convert raw data into a integrated, analytical report. On the other hand, you have the Power BI applications that you can use to create online dashboards ( with KPI’s, graphic variance analyses, …) that you can share with other users. These are one by one user-frienly applications that are used standalone or that are integrated in other Office Packages.

During this one-day training, you will learn how to work with the components of the Microsoft Power platform (Power Query, PowerPivot, DAX, Powerview, PowerMap, Insights, power BI Desktop, Power BI publisher for Excel, Power BI .com).

Who should attend this training

This training is mainly for those who frequently use spreadsheets and don’t know the Microsoft Power BI tools yet, and want to explore the possibilities (analyzing, visualizing and presenting).

Course Objectives

After this training, you will have basic insights in the different Power tools from Microsoft BI. You will also be able to select the best tool to analyze and present your database:

  • 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.

  • With Power Pivot (Excel), you can adapt tables with millions of rows thanks to a range of (DAX) functions. You can also connect tables and build complex pivot tables.

  • Power Map in Excel is an animation and presentation tool to highlight your geographical Excel Pivot tables via geo-3D visualisations.

  • Power view in Excel is a reporting tool that you can use to make interactive dashboards, based on pivot tables (this is similar to Power BI Desktop).

  • Insights (in Excel or Power BI) study your data and show all possible connections and correlations between your data.

  • The Power BI Publisher tab (Excel) allows you to pin Excel graphs and overview tables directly to the Power BI-dashboards.


Prior knowledge of pivot tables and Excel functions is required.

Course Content
  • Overview of the BI ‘Power’ platform

    • Power Pivot

    • Power View

    • Power Query

    • Power Map

    • Power BI Desktop

    • Power

  • Excel tables en Data Model

  • Power Pivot (+DAX functions)

  • PivotTables with Power Pivot

  • Power View

  • Power Map

  • Power Query (with e.g. Unpivot)

  • Power BI Desktop

    • What is Power BI? (Power BI versus Excel, installation, ...)

    • Power BI interface

    • Query in Power BI

    • Power BI Dashboard: graphs, tables, DAX …

    • Publishing Power BI

  • Power BI en Excel: interaction

  • ‘After-Course’: Informatieve websites, E-learning, ...

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