MS Power BI from A to Z

Duration

2 days

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.

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.

Prerequisites

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

  • Prior knowledge of pivot tables and Excel functions is required, or completion of the training 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 BI.com

    • 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, …

 

Enroll here


Training cost

1.506 EUR (VAT excluded) per person

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

Practical details

Classroom
From 9 AM to 5.30 PM

Language

Dutch
English upon request

Location

We organize this training course on several locations within Belgium. Select your preferred date to see the location.

This training in-company?

Upon your request we can organize this training for you.


In collaboration with

Wolters-Kluwer-logo.png