Please ensure Javascript is enabled for purposes of website accessibility
Microsoft Power BI – The Complete Masterclass
5.0( 1 REVIEWS )
14h 15m

Learn the basics of Power BI, all the important tools and when and how to use them properly, and how to visualize your data effectively.

Read more.
Course Skill Level
Time Estimate
14h 15m


Hi! My name is Nikolai Schuler and I am super excited about equipping you with the skillset to master Data Science and Data Analytics! In my work as a data scientist and BI consultant I see that there a lot of new tools that bring a lot of benefits. Yet I also see that it is not always easy to learn working with these tool beside the daily other tasks we have to do. Also I found it hard to find courses that are high quality as well as easy to understand and well structured. For that rea

About This Course

Who this course is for:

  • Anyone who is looking for a complete and comprehensive intro to Power BI
  • Everyone who wants to also learn more advanced Power BI skills such as DAX for calculated columns and measures
  • Anyone who wants to pursue a career as a data analyst, data scientist or BI consultant
  • Anyone who has never used Power BI before and is looking for a hands-on approach to learn it

What you’ll learn: 

  • Learn the complete workflow in Power BI from A to Z
  • Advanced analytics with DAX – calculated columns and measures
  • All-in-One: Power BI Desktop, Power BI Cloud and Power BI Mobile!
  • Learn how to design and implement professional reports
  • Learn storytelling with data to visualize your data effectively
  • Advanced features such as working with parameters, using R scripts, optimizing performance and
  • Row-Level Security
  • Performance optimizing
  • Storytelling with data
  • Python and R in Power BI
  • Forecasting and advanced analytics
  • Time intelligence


  • A computer with Windows operating system
  • Power BI Desktop (free download)
  • For some modules with Power BI Service (Cloud) account, a school or work email address is required to sign up (free 60 day trial)

Do you want to learn the skills to professionally analyze data?

Do you want to learn all the steps to create impressive reports?

Then Microsoft Power BI is the right tool for you!

In this course you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator.

Understand everything from scratch – step by step, very structured and practice-oriented

  • Learn all the important tools – know when and how to use them properly
  • Connect different data sources – from basics to advanced
  • Create your data model – and understand it
  • Master DAX – to do more advanced analysis on your data
  • Get to know all the different visualizations – and how to use them
  • Storytelling with data – learn how to visualize your data effectively
  • Create interactive visualizations – with drill throughs and drill downs
  • Advanced analysis – learn how to use R Script in Power BI (Data Science)
  • Forecasting – Advanced analytics which can be helpful in Data Science
  • Row-Level Security – Implement the security concept to control access to the data

This course is right for you if you have never worked with Power BI and want to learn everything hands-on in one course. OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.

This is the course that covers everything in Power BI to become an advanced report developer! 

Enroll now to get life long access!

Our Promise to You

By the end of this course, you will have learned storytelling with data to visualize your data effectively.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about Power BI.

Course Curriculum

Section 1 - Introduction
Downloadable Resources – All Source Files 00:00:00
Welcome! 00:00:00
What Is Power BI? 00:00:00
Download And Installing Power BI Desktop 00:00:00
Getting To Know The Interface 00:00:00
Mini Project: Transform Data 00:00:00
Mini Project: Visualize Data 00:00:00
Mini Project: Creating A Data Model 00:00:00
Course Outline: What Will You Learn In This Course? 00:00:00
Section 2 - Preparing Our Project
Creating Our Initial Project File 00:00:00
Working With The Attached Project Files 00:00:00
Section 3 - Data Transformation - The Query Editor
Exploring The Query Editor 00:00:00
Connecting To Our Data Source 00:00:00
Editing Rows 00:00:00
Changing Data Types 00:00:00
Replacing Values 00:00:00
Close And Apply 00:00:00
Connecting To A CSV File 00:00:00
Connecting To A Web Page 00:00:00
Extracting Characters 00:00:00
Splitting And Merging Columns 00:00:00
Creating Conditional Columns 00:00:00
A Little Note Regarding The Next Lecture 00:00:00
Creating Columns From Examples 00:00:00
Merging Queries 00:00:00
Pivoting And Unpivoting 00:00:00
Appending Queries 00:00:00
Practice And Solution: Population Table 00:00:00
The Fact-Dimension-Model 00:00:00
Practice: Load The Dimension Table 00:00:00
Organizing Our Queries In Groups 00:00:00
Text To Be Used In The Next Lecture 00:00:00
Entering Data Manually 00:00:00
Creating An Index Column 00:00:00
Workflow And More Transformations 00:00:00
Module Summary 00:00:00
Exercise 1 00:00:00
1 Question 00:00:00
Section 4 - Data Transformation - Advanced
Advanced Editor – Best Practices 00:00:00
Performance: References Vs. Duplicating 00:00:00
Performance: Enable/Disable Load And Report Refresh 00:00:00
Group By 00:00:00
Mathematical Operations 00:00:00
Run R Script 00:00:00
Using Parameters To Dynamically Transform Data 00:00:00
M Formula Language: Basics 00:00:00
M Formula Language: Values, Lists And Tables 00:00:00
M Formula Language: Functions 00:00:00
M Formula Language: More Functions And Steps 00:00:00
Exercise 2 – Instructions 00:00:00
Exercise 2 – Solution 00:00:00
Section 5 - Creating A Data Model
Why A Data Model? 00:00:00
Create And Edit Relationships 00:00:00
One-To-Many And One-To-One Relationship 00:00:00
Many-To-Many (M:N) Relationship 00:00:00
Cross Filter Direction 00:00:00
Activate And Deactivate Relationships 00:00:00
Module Summary 00:00:00
Exercise 3 – Instructions 00:00:00
Exercise 3 – Solution 00:00:00
Section 6 - Data Visualization
Our First Visual 00:00:00
The Format Tab 00:00:00
Understanding Tables 00:00:00
Conditional Formatting 00:00:00
The Pie Chart 00:00:00
All About The Filter Visual 00:00:00
The Filter Pane For Developers 00:00:00
Cross Filtering And Edit Interactions 00:00:00
Exercise 4 – Instructions 00:00:00
Exercise 4 – Solution 00:00:00
Syncing Slicers Across Pages 00:00:00
Creating Drill Downs 00:00:00
Creating Drill Throughs 00:00:00
The Tree Map Visual 00:00:00
The Decomposition Tree 00:00:00
Understanding The Matrix Visual 00:00:00
Editing Pages 00:00:00
Buttons And Actions 00:00:00
Bookmarks To Customize Your Report 00:00:00
Analytics And Forecasts With Line Charts 00:00:00
Working With Custom Visuals 00:00:00
Get Data Using R Script And R Script Visual 00:00:00
R Script To Use 00:00:00
Asking Questions – Q&A Visual 00:00:00
Wrap Up – Data Visualization 00:00:00
Section 7 - Power BI And Python
Python In Power BI – Plan Of Attack 00:00:00
Setting Up Python For Power BI 00:00:00
Transforming Data Using Python 00:00:00
Python Script I Used In The Next Lecture 00:00:00
Creating Visualizations Using Python 00:00:00
Python Script II Used In The Next Lecture 00:00:00
Violin Plots, Pair Plots And Ridge Plots Using Python 00:00:00
Python Script III Used In The Next Lecture 00:00:00
Machine Learning (BayesTextAnalyzer) Using Python 00:00:00
Performance And Troubleshooting 00:00:00
Section 8 - DAX - The Essentials
Introduction 00:00:00
The Project Data 00:00:00
DAX Cheat Sheet 00:00:00
All Files For The DAX Part 00:00:00
Measures Vs. Calculated Columns 00:00:00
Automatically Creating A Date Table In DAX 00:00:00
CALENDAR 00:00:00
Creating A Complete Date Table With Features 00:00:00
Script To Be Used In Your Future Projects 00:00:00
Creating Key Measure Table 00:00:00
Aggregation Functions 00:00:00
The Different Versions Of Count 00:00:00
SUMX – Row Based Calculations 00:00:00
DAX Exercise 1 00:00:00
DAX Solution 1 00:00:00
Section 9 - DAX - The Calculate Function
CALCULATE – The Basics 00:00:00
Changing The Context With FILTER 00:00:00
ALL 00:00:00
ALLEXCEPT 00:00:00
DAX Exercise 2 00:00:00
DAX Solution 2 00:00:00
Section 10 - Tell A Story With Your Data - Learn To Visualize Effectively
Intro – Best Practices 00:00:00
Show Empathy And Identify The Requirements 00:00:00
Find The Most Suitable KPIs 00:00:00
Choose An Effective Visual 00:00:00
Make Use Of Natural Reading Pattern 00:00:00
Tell A Story Using Visual Cues 00:00:00
Avoid Chaos And Group Information 00:00:00
Wrap Up – Storytelling With Data 00:00:00
Section 11 - Power BI Service - Power BI Cloud
How To Go On Now? 00:00:00
Power BI Pro Vs Premium And Signing Up 00:00:00
An Alternative If You Don’t Have A Business Email 00:00:00
Exploring The Interface 00:00:00
Discovering Your Workspace 00:00:00
Little Note On The Next Lecture – Uploading Your Report 00:00:00
Connecting Power BI Desktop And Cloud 00:00:00
Understanding Datasets And Reports 00:00:00
Working On Reports 00:00:00
Updating Reports From Power BI Desktop 00:00:00
Creating And Working With Workspaces 00:00:00
Installing And Using A Data Gateway 00:00:00
Get Quick Insights 00:00:00
Creating Dashboards 00:00:00
Sharing Our Results Through Apps 00:00:00
Power BI Mobile App 00:00:00
Creating The Layout For The Mobile App 00:00:00
Wrap Up – Power BI Cloud 00:00:00
Section 12 - Row-Level Security
Introduction 00:00:00
Creating A Row-Level Security 00:00:00
Row-Level Security In The Cloud 00:00:00
Row-Level Security And Data Model 00:00:00
Dynamic Row-Level Security 00:00:00
Dynamic Many-To-Many RLS 00:00:00
Hierarchical Row-Level Security 00:00:00
Section 13 - More Data Sources
JSON And REST API 00:00:00
Setting Up A Local MYSQL Database 00:00:00
Connecting To A MYSQL Database In Power Bi 00:00:00
Connecting To A SQL Database (PostgreSQL) 00:00:00
Section 14 - Next Steps To Improve And Stay Up To Date
Congratulations And Next Steps 00:00:00
The End 00:00:00
More Data To Practice 00:00:00

Course Review


1 Ratings
  1. Anonymous

    Awesome Masterclass!


    Wow! That was a masterclass for a beginner like me. It was full of content, very well structured, and easy to follow, and work along by myself. I really enjoyed it and am very excited to take what I have learned into practice.

    I feel like I have learned loads – much more than I bargained for – and I can’t wait to keep practicing and learning going forward.

    Thank you so much Nikolai!


Join our newsletter and get your first course free!


Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?