Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Power BI - The Complete Masterclass

Name: Microsoft Power BI - The Complete Masterclass
Rating: 4.6 (4737 reviews)

Master Power BI Desktop, Cloud & Mobile and advanced analytics with DAX (also Data Science)!

Created byNikolai Schuler

Last updated 8/2026

English

English [Auto],

What you'll learn

Learn the complete workflow in Power BI from A to Z
Advanced analytics with DAX - calculated columns & measures
All-in-One: Power BI Desktop, Power BI Cloud & 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 & R in Power BI
Forecasting & advanced analytics
Time intelligence

Course content

17 sections • 167 lectures • 17h 15m total length

Welcome!0:22
What is Power BI?5:12
Download & Installing Power BI Desktop3:13
Install Power BI desktop on Windows by downloading from the store or advanced options, then open a pbix file to begin building reports and explore the interface.
Quick Interface Tour6:25
Navigate the Power BI interface, create a new blank report, connect to CSV data, transform data with Power Query, load into memory, and visualize in report view.
Creating Visualizations - Quick Intro5:30
Mini Project: Transform Data11:57
Mini Project: Visualize Data6:54
Mini Project: Creating a Data Model9:16
Learn to build a data model by creating relationships between tables, unpivot data for analysis, and establish an active relationship using a foreign key in power BI.
Course Outline: What will you learn in this course?4:25
How to lean best with this course?3:14
All source files & course slides0:45
Here you can download all the source files and the course slides from the resources.
You also find the relevant source files also always in the resources of the according lecture but maybe it is also helpful to have them all in one place! ;)
If the download of the resources should not work at some moment, you can also download it using the following link:
https://drive.google.com/file/d/1GbL4TZP2ihQhtq6GFg_aR0KeNekvq07X/view?usp=sharing
Best regards,
Nikolai

First Data Connection4:32
Exploring the Query Editor7:48
Explore the Power Query Editor in Power BI and learn how queries, steps, and transformations shape data. Use the home ribbon, gear icon, and M language behind the scenes.
Connecting to our data source6:48
Editing rows8:10
Changing data types8:24
Replacing values3:27
Close & Apply3:29
Connecting to a csv file3:21
Connecting to a web page5:04
Extracing characters6:18
Splitting & merging columns9:22
Creating conditional columns5:52
A little note regarding the next lecture0:31
Creating columns from examples8:38
Merging Queries17:23
Pivoting & Unpivoting5:43
Appending Queries8:20
Practice & Solution: Population table14:30
The Fact-Dimension-Model9:19
Practice: Load the dimension table3:48
Organizing our queries in groups2:59
Text to be used in the next lecture0:12
Entering data manually4:43
Learn how to enter data manually in Power BI by creating a dimension table, adding climate ID values, and naming columns, then edit and save changes.
Creating an index column3:04
Workflow & more transformations4:38
Module summary5:05
Exercise 1

Advanced Editor - Best practices8:43
Performance: References vs. Duplicating9:50
Performance: Enable / Disable Load & Report Refresh4:31
Learn to optimize Power BI performance by enabling or disabling data load for queries, managing query dependencies, and using include in refresh to keep static data out of daily refresh.
Group by4:47
Mathematical Operations4:54
Run R Script14:36
Using Parameters to dynamically transform data6:28
M formula language: Basics6:40
M formula language: Values, Lists & Tables13:57
M formula language: Functions13:13
M formula language: More functions & steps5:02
Exercise 2

Why a data model?5:05
Create & edit relationships4:45
One-to-many & one-to-one relationship4:30
Many-to-many (m:n) relationship9:32
Cross filter direction5:23
Activate & deactivate relationships6:10
Identify inactive and active relationships and resolve circular references by managing relationships, disabling auto-detect, and deleting or activating the correct connections to stabilize the data model.
Module summary5:14
Exercise 3

Our first visual8:02
Adding values to visual2:15
The format tab11:52
Master formatting visuals in Power BI using the Format tab, adjusting legends, axes, data colors, labels, titles, units, and shadows to create clear, consistent charts.
Understanding tables9:53
Conditional formatting8:48
The Pie Chart5:32
All about the filter visual12:32
The filter pane for developers8:52
Explore how the filter pane lets developers control report values with basic, advanced, and top end filtering, and apply filters to visuals, pages, or the entire report.
Cross filtering & edit interactions3:56
Exercise 4
Syncing slicers across pages7:06
Learn to sync slicers across Power BI report pages by duplicating pages, selecting which slicers synchronize, and using group names to keep filters and visuals consistent.
Creating drill downs8:29
Creating drill throughs6:50
The tree map visual7:06
The decomposition tree5:23
Understanding the matrix visual5:17
Editing pages7:15
Buttons & Actions9:28
Bookmarks to customize your report9:31
Analytics and Forecasts with line charts10:12
Working with custom visuals7:17
R Script to use0:13
Get data using R Script & R Script visual8:26
Asking questions - Q&A visual3:45
Wrap up - data visualization8:09

Python in Power BI - Plan of attack2:57
Setting up Python for Power BI3:03
Transforming data using Python11:24
Python script I used in the next lecture0:13
Creating visualizations using Python7:55
Python script II used in the next lecture1:18
Violin plots, pair plots & ridge plots using Python7:13
Python script III used in the next lecture0:14
Machine learning (BayesTextAnalyzer) using Python9:53
Performance & Troubleshooting3:27

Intro2:32
The project data4:09
DAX cheat sheet0:12
All files for the DAX part0:15
Measures vs. Calculated Columns14:37
Automatically creating a date table in DAX8:17
CALENDAR5:08
Creating a complete date table with features3:43
Script to be used in your future projects0:26
Creating key measure table3:19
Aggregation functions6:07
The different versions of COUNT14:05
SUMX - Row based calculations8:32
DAX Exercise 11:18
DAX Solution 10:19

Requirements

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 adress is required to sign up (free 60 day trial)

Description

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.

That’s what you’ll learn:

Power BI Desktop, Power BI Cloud & Power BI Mobile!

✓ 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 devolopper!

Enroll now to get life long access!

Who this course is for:

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

Microsoft Power BI - The Complete Masterclass

What you'll learn

Explore related topics

Course content

Introduction11 lectures • 57min

Preparing our Project2 lectures • 9min

Data Transformation - The Query Editor26 lectures • 2hr 41min

Data Transformation - Advanced11 lectures • 1hr 33min

Creating a Data Model7 lectures • 41min

Data Visualization24 lectures • 2hr 56min

Power BI & Python10 lectures • 48min

DAX - The Essentials15 lectures • 1hr 13min

DAX - The CALCULATE function7 lectures • 37min

DAX - Time Intelligence4 lectures • 31min

Requirements

Description

Who this course is for: