Microsoft-Power-BI-Symbol.png

Microsoft Power BI Training

Course description

Content Highlight

Audience

Registration

Resources

Course description

Power BI - Beginner course

Touching on all the Power BI basics while collaboratively building our first Power BI report

A thorough course covering all of the Power BI basics, from loading & transforming data to publishing your report to the Power BI Service & automating the dataset refresh. Aiming at providing attendants the theory, practice & confidence to start building and sharing their own Power BI reports.

Course duration: 3 days of 4 hours

 
 

Content Highlights

Main topics:

  1. Tour and use of Power BI Desktop

  2. Get data from various data sources

  3. Power Query: Data shaping ▪ Introduction to data modelling: fact & dimension table

Day 1:

  1. Power BI proficiency check

  2. What is Power BI and how does it compare to other tools?

  3. Tour and use of Power BI Service

Day 2:

  1. Recap of the previous day, answering remaining questions, knowledge check ▪

  2. Building our first visuals by using table columns directly 

  3. Building visuals properly: DAX introduction calculations

  4. DAX continuation:

  5. Time series  Switch/IF statements ▪ Creating new

Day 3:

  1. Designing our report: how to start

  2. Data visualization pitfalls – general

  3. Data visualization pitfalls – Power BI

  4. Visualization tips & tricks

  5. Publishing our report to the Power BI service

  6. Creating a new workspace & application in the Power BI service

  7. Scheduling an automatic refresh

  8. Creating a dashboard from our report

 

Who is this for?

Persons who have recently learned about power BI but haven’t gotten further yet than loading a simple .xlsx file and creating some visuals

 

Registration

If you would like to sharpen your skills, register now and save your seat. For registration or more course information click the below button. 

Course description

Power BI - Intermediate course

Advanced lessons on selected subjects- bringing your power BI skills to the next level

Deep dive into the more complicate features of Power BI and stop limiting yourself by only using the user-friendly ribbon options – start coding! Aiming at providing attendants the skillset to build high quality reports & confidence to also use the more complicate Power BI features.

Course duration: 3 days of 4 hours

Content Highlights

Main topics:

  1. Loading data: the user-friendly way and the advanced way

  2. Structured and standardized WOW: Why and how

  3. Power Query: Why you need to learn to code, examples

Day 1:

  1. Power BI proficiency check

  2. Short & powerful summary on Power BI tooling

Day 2:

  1. Dataflows: pro’s and cons, how-to set up

  2. Reusing a Power BI dataset across reports: show case, pro’s & cons

  3.  Using Power automate to refresh Power BI dataflows & datasets

  4.  Bookmarks: Creating user friendly filter panes

Day 3:

  1. Setting up a (personal) Gateway to access local data

  2.  Advanced DAX formulas: time series and switching between measures

  3. External tools: ▪ The tabular editor ▪ Power BI helper

Who is this for?

Persons who have already built and published several reports but feel they lack the proper fundamentals and want to bring their Power BI skills to the next level

Prerequisite

Persons who have already built and published several reports

Registration

If you would like to sharpen your skills, register now and save your seat. For registration or more course information click the below button. 

Course description
Key outcomes
Course resources