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 Practical Guide

Name: Microsoft Power BI - The Practical Guide
Rating: 4.6 (76195 reviews)

Dive in and learn the Power BI tools! Learn Data Analysis & Visualization and more in Power BI Desktop & Power BI Pro!

Created byManuel Lorenz, Academind by Maximilian Schwarzmüller, Maximilian Schwarzmüller

Last updated 1/2026

English

What you'll learn

At the end of this course students will be able to analyse data from different data sources and create their own datasets
Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
Students will have the required knowledge to dive deeper into Power BI and find out more about its advanced features

Course content

14 sections • 204 lectures • 17h 38m total length

Welcome to This Course0:55
What is Power BI?5:46
Installing Power BI Desktop3:33
Connecting Power BI Desktop to Source Files10:06
Creating our First Visuals7:34
Join our Online Learning Community0:23
Comparing Excel & Power BI3:20
Course Outline5:30
The Two Ways (Paths) Of Taking This Course2:22
How to Get the Most Out of This Course3:14
Important: How to Access Course Resources, Project Files & Slides9:48

Module Introduction1:12
Understanding Data Preparation / Cleaning / Cleansing4:50
Connecting Power BI Desktop to Source Files10:35
How Power BI Queries Data5:01
Understanding Basic Row Operations9:07
Filtering Data6:00
Analyzing Columns & Removing Blank Fields10:59
Understanding & Using the Append Feature8:27
Choosing & Removing Columns7:05
Append Behind the Scenes2:50
Understanding the Transpose Feature2:58
Replacing Values7:35
Working with Dates - The Basics6:50
Understanding Data Formats5:50
Handling Data Format Errors8:18
Understanding Pivoting & Unpivoting4:30
Applying Pivoting & Unpivoting3:55
Fixing a Sorting Problem2:11
Extracting Data, Splitting Columns & Sorting Multiple Columns9:24
Introducing the "Group By" Feature4:20
Improving the Project Structure3:16
Wrap Up3:06

Module Introduction0:56
Data Warehouse, Data Model & Data Schema5:45
The Star Schema - Theory6:14
Applying the Star Schema to our Project2:26
Understanding References4:07
Comparing References & Duplicates6:39
Importing Country & Region Codes7:53
Using "Enter Data" to Create a Table3:01
Understanding the Merge Feature3:29
How to Join Tables3:19
Understanding Outer, Inner & Anti Joins5:37
Join Kind in Practice5:02
Handling Merge Errors11:31
Understanding the DIM-age Table3:26
Bringing Back the "age-group" Column4:41
Getting the Maximum Values From Each Age Group3:30
Creating Conditional Columns7:23
Creating an Index Column2:26
Creating a DIM-gender Table3:16
Understanding the FACT Table3:02
Finishing the FACT Table8:50
Applying Basic Mathematical Operations2:30
Using the Enable Load Feature6:58
Wrap Up2:46
Time to Practice - Query Editor

Module Introduction1:26
Query Editor vs Data Model4:39
Understanding Relationships2:34
Creating our First Relationship9:59
Understanding Cardinality & Difference Relationship Types2:23
One to Many & Many to One2:23
One to One1:38
Many to Many3:28
Fixing the Column Order Bug3:33
Understanding the Cross Filter Direction11:15
Understanding Active Properties1:41
Adding Relationships to the Project6:56
M-Language vs DAX (Data Analysis Expressions)4:17
Creating a Custom Column with the M-Language6:29
Creating a Calculated Column with DAX7:01
M vs DAX - What Should I Choose?2:24
The DAX Basics2:59
The Core DAX Syntax4:01
DAX Data Types2:59
DAX Operators4:54
DAX Core Functions4:19
Creating a Table with the CALENDAR Function11:48
Extracting Data with the DOT Notation4:05
Adding & Dividing Columns8:00
Working with IF Functions6:42
Understanding Relationship Functions4:40
Calculated Column vs Measure1:51
Understanding & Creating Measures5:14
Working with FILTER & CALCULATE Functions - Theory5:44
Combining CALCULATED & FILTER Functions9:11
Adding the Filter Condition to CALCULATE3:32
Using Measures in Measures4:24
Changing the Measure's Home Table4:20
Understanding the Data Category3:00
Wrap Up2:39
Time to Practice - Data Model & Relationships

Module Introduction1:03
The Power BI Workflow & Understanding Basics Visual Elements4:49
Creating & Duplicating Pages2:08
Organizing Visuals6:02
Creating a New Visual3:00
Creating Line & Column Charts7:02
How FILTER Affects the Visual6:39
Understanding Interactions5:22
Hierarchies & Drill Down7:30
Formatting Chart Colors7:50
The Canvas3:00
Formatting the Page Background / Wallpaper2:37
Formatting the Filter Pane & Filter Cards7:17
Formatting Visuals: General Settings4:42
Diving Deeper Into Formatting Visuals8:04
Working with Report Themes7:13
Finishing the Report Theme2:23
Understanding the Slicer9:35
Default Summarization & Sorting Order4:20
Creating Treemaps & Working with Multiple Slicers6:36
Creating Tables6:36
Syncing Slicers3:11
Filter on Visual, Page & Report Level9:47
Creating Single & Multi Row Cards7:48
Adding a Secondary Y-Axis4:34
Combining Column & Line Charts2:51
The Waterfall Chart3:11
Importing Visuals2:18
Finishing Touches5:09
Wrap Up4:24
Time to Practice - Visualizations

Module Introduction1:52
The Next Steps4:57
Power BI Pro Pricing4:14
Power BI Pro Interface Tour6:38
Publishing & My Workspace - Theory3:19
Publishing / Importing Power BI Desktop Projects to Pro4:10
Datesets Walkthrough4:25
List View vs Lineage View4:02
Exploring Reports In Pro4:46
Understanding Dashboards7:20
Creating Reports & Dashboards7:32
Diving Deeper Into "My Workspace", Understanding Refresh and a Refresh Error4:34
Gateways - Theory1:40
Gateways: Configuring Manual & Scheduled Refreshs11:53
Sharing Data From "My Workspace" via Direct Access13:44
Sharing Links5:42
Understanding Collaboration Workspaces - Theory1:37
Creating Colaboration Workspaces8:09
Sharing Data via Apps1:38
Publishing & Unpublishing Apps9:20
Deleting Collaboration Workspaces1:15
Workspaces vs Apps2:19
Working with Power BI Mobile5:48
Wrap Up2:48

Module Introduction1:21
Let me introduce you to this module.
Importing JSON Data6:28
JSON is a popular data format which allows you to work with nested/ structured data. Learn how to import JSON files in this lecture.
Updated Star Wars API URL0:08
Importing Data from REST APIs5:00
What if you want to import data directly from a RESTful API? That's of course possible with Power BI and this lecture shows how it works.
Preparation: Setting up a MySQL Server8:09
I also want to show you how to import data from a MySQL server - so let's create one!
Importing Data from a MySQL Server (and other SQL Servers)6:38
This lecture teaches you how to import data from a MySQL Server and also explains how to get the data from any other SQL Server.
Wrap Up0:56
Let me wrap this module up.

Requirements

For the majority of the course you must have a computer with Windows as operating system
Basic understanding of data analysis is a plus but not required
For multiple modules of this course a work or school email address is required to sign up

Description

This course turned more than 300.000 students into Power BI professionals and was specifically created for business users who need to learn fast, comprehensive and efficient to get the job done!

In the course you can take two paths:

- The Complete Path (full >15h course also teaching more advanced concepts & features)

- The Summary Path (2h crash course to master Power BI as quick as possible)

Both approaches will teach you Power BI in great detail and turn you into a Power BI professional. You decide what learning type you are - it’s your choice!

You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?

Then the Power BI tools are the tools to choose for you!

In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes.

This is what you will learn:

Get to know the different tools of the Power BI universe and learn how to use them
Understand Power BI Desktop and its components
Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
Learn how to filter and format data, how pivoting and unpivoting works
How to work in the different views of the Data Model
How to create calculated columns and measures
How to build relationships between different tables
How to create a report with different interactive visualization types
Learn how to use Power BI Pro to create dashboards and to share and publish your results
How to access your results from multiple devices using Power BI Mobile
And more!

Don't miss this opportunity to become a Power BI expert today! Enrol now, unlock your potential & transform your career today!

Who this course is for:

People who never worked with Power BI and who want to understand how to use these tools
Anyone who is interested in learning how to connect the different Power BI tools with each other
People who want to understand how to create customized visuals with the Power BI Developer tools

Microsoft Power BI - The Practical Guide

What you'll learn

Explore related topics

Course content

Getting Started11 lectures • 53min

Understanding the Power BI Desktop Basics & Preparing the Course Project4 lectures • 22min

Data Preparation in the Power Query Editor22 lectures • 2hr 8min

Data Transformation in the Power Query Editor24 lectures • 1hr 55min

The Data Model: Working with Relationships & DAX (Data Analysis Espressions)35 lectures • 2hr 46min

Creating Visuals in the Report View30 lectures • 2hr 37min

Power BI Pro & Mobile: Sharing & Collaborating with Workspaces & Apps24 lectures • 2hr 4min

Other Data Sources7 lectures • 29min

How to Stay Up-to-Date in the Power BI World?3 lectures • 7min

Course Round Up1 lecture • 7min

Requirements

Description

Who this course is for: