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:
-
Tour and use of Power BI Desktop
-
Get data from various data sources
-
Power Query: Data shaping â–ª Introduction to data modelling: fact & dimension table
​
Day 1:
-
Power BI proficiency check
-
What is Power BI and how does it compare to other tools?
-
Tour and use of Power BI Service
​
Day 2:
-
Recap of the previous day, answering remaining questions, knowledge check â–ª
-
Building our first visuals by using table columns directly
-
Building visuals properly: DAX introduction calculations
-
DAX continuation:
-
Time series Switch/IF statements â–ª Creating new
​
Day 3:
-
Designing our report: how to start
-
Data visualization pitfalls – general
-
Data visualization pitfalls – Power BI
-
Visualization tips & tricks
-
Publishing our report to the Power BI service
-
Creating a new workspace & application in the Power BI service
-
Scheduling an automatic refresh
-
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
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:
-
Loading data: the user-friendly way and the advanced way
-
Structured and standardized WOW: Why and how
-
Power Query: Why you need to learn to code, examples
​
Day 1:
-
Power BI proficiency check
-
Short & powerful summary on Power BI tooling
​
Day 2:
-
Dataflows: pro’s and cons, how-to set up
-
Reusing a Power BI dataset across reports: show case, pro’s & cons
-
Using Power automate to refresh Power BI dataflows & datasets
-
Bookmarks: Creating user friendly filter panes
​
Day 3:
-
Setting up a (personal) Gateway to access local data
-
Advanced DAX formulas: time series and switching between measures
-
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