Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Power BI Desktop: Beginner to Advanced with DAX & ETL

Name: Power BI Desktop: Beginner to Advanced with DAX & ETL
Rating: 4.5 (6728 reviews)

Get Job-Ready Hands-on Power BI Desktop course for beginners: Power Query, data modeling, DAX, reports, dashboards,

Created byDan We

Last updated 6/2026

English

What you'll learn

Build Power BI reports and dashboards from scratch
Clean and transform messy data with Power Query / ETL
Create data models for accurate analysis
Write DAX measures and calculations
Use AI visuals and analytical visuals in Power BI
Prepare for real business reporting scenarios

Course content

5 sections • 93 lectures • 16h 22m total length

Read me :)0:23

About this update0:34
Software download and video screen resolution0:48
Enable the new on object interaction0:57
Power BI important On Object Interaction Update2:36
Download the latest course files here0:02
1 A complete guided tour through the Power BI Interface49:17
2 Lets create our first Power BI report24:46
Learn to build your first Power BI report by importing Excel data via the navigator, selecting visuals, and formatting charts, with best-practice tips for tables and refresh.
3 Finishing our first report26:04
4 Exploring the advanced Dataset5:02
5 Introduction to datapreparation of the advanced model with Power Query Editor23:40
6 The importance of a proper Datestable and how to create it11:26
7 Power Query Editor Deep Dive What can we do with our Data28:38
Explore the Power Query Editor in Power BI, performing data transformations, including importing Excel data and splitting columns, then grouping, adding or modifying columns, and merging or duplicating queries.
Important note for the next lecture0:19
8 Data enrichment with web data extraction20:13
9 Datamodelling the most important thing in Power BI26:46
10 Creating our first calculated columns and measures in Power BI26:13
11 The measures table trick4:12
12 Creating our first DAX measures in Power BI Desktop12:30
13 Flexibility of DAX measures what makes them great4:13
Discover how DAX measures calculate on the fly, are stored nowhere, and remain flexible across any visual and dimension—from products to customers—when model relationships exist.
14 Dates and Drilldown functionality in Power BI12:42
15 How to create your own Date hierarchy in Power BI3:15
16 Lets get started with Timeintelligence DAX calculations in Power BI11:04
17 Timeintelligence in a more flexible way in Power BI5:58
18 Calculating Cumulative or Running Total Sales in Power BI10:34
19 Measure Cleanup and easy formatting Trick8:47
20 Lets create our Power Report like Magic20:25
21 Advance Training Part 2 Setting up the data model15:00
Set up a Power BI data model by importing Excel data, transforming with Power Query, and creating a date table to support a robust fact and dimension schema.
22 Practise Building DAX measures and bulk formatting trick17:31
23 Dax Timeintelligence More DAX formulas and use cases14:40
24 Calculating Sales Rankings in Power BI DAX13:38
25 Dynamic Ranking using Parameters in Power BI16:39
26 Fixing Timeintelligence Problems A very important lesson to understand13:19
Master running totals and time intelligence challenges in Power BI by building a cumulative sales measure with a date table, using date add, and correcting filter context to align dates.
27 Szenarioanalysis in Power BI Desktop13:33
28 Calculating Rolling 30 day Sales Periods in Power BI11:26
29 Introduction to Table functions in Power BI Desktop10:29
30 Indentifying and visualizing our top 10 clients using DAX in Power BI11:28
31 Customer Insights per weekday per category and a few tricks10:58
32 DAX or no DAX that is the question6:34
33 Introduction to Quick Measures and the AI Copilot11:25
Discover quick measures in Power BI and unleash AI copilot to generate DAX expressions, creating year-to-date totals and running sums from your data.
AI Visuals in Power BI Desktop12:58
Explore AI visuals in Power BI Desktop, including the Q&A visual, key influencers, decomposition tree, and narrative visuals, plus Quick Measures and Copilot for DAX generation.
34 Advance Customer Classification with Power BI DAX17:27
Learn to classify customers into top, middle, and bad using a dax-based ranking on total sales, with a helper table and advanced measures for targeted visuals.
35 Introduction to Variables and Weekday sales in Power BI13:28
Explore how DAX variables help compare weekday and weekend sales in Power BI. Build two measures using var and return to sum weekend and weekday sales from a dates table.
36 Tips and Tricks for Power BI Design and Report Creation17:00
Design a Power BI third report using background templates and imported images, then build visuals—timeline, bar and line charts, KPIs, and a donut chart—with white-on-dark styling.
37 Addon Introduction to Buttons Use cases and configurations in Power BI24:14

About this section0:46
Download latest course files for this section0:02
1 Introduction to the CALCULATE function starting from scratch8:02
2 Filter Contexts Row Context and Context Transition in Power BI explained19:17
3 Combine Calculate with ALL and VALUES14:15
4 Excourse dynamic selection with CALCULATE10:36
5 How to apply multiple criteria filter with CALCULATE in Power BI6:29
6 How to use multiple Filtercriteria with CALCULATE in Power BI OR7:00
Master using calculate with multiple criteria in Power BI, applying or logic via boolean expressions or the filter function to filter total sales between 15 and 25 or outside range.
7 CALCULATE with multiple criteria from different columns in Power BI8:55
8 Salesclassification using CALCULATE14:01
9 Cleaning up and quickly set up the new model11:04
Clean and set up a Power BI model using metastable trick to create a measures table, move measures, import data, fix date formats, and link a dates table for relationships.
10 Applying ALL and ALLSELECTED with CALCULATE in Power BI14:02
Explore how all and allselected with calculate control filter context in Power BI to compute total sales and percent of total while preserving external region filters.
11 CALCULATe with the Keepfilters modifier8:22
Learn how the keep filters modifier preserves external filters while applying a given expression in power bi, and compare its behavior to filter, all, and values using a category example.
12 Modify model relationships with CALCULATE9:58
Learn how calculate acts as a modifier to activate an inactive relationship using use relationship, enabling comparison of order date and ship date in the dates table for total sales.
13 Using Context Transition with CALCULATE to evaluate the maximum sales on a da11:32
14 Visual understanding of the expanded table concept11:23
15 CALCULATE modifiers remove all filters except one8:05
16 Using CALCULATE with Timeintelligence Expressions7:11
Explore time intelligence in Power BI by using CALCULATE with same period last year and moving total to compute prior-year sales and rolling 12-month totals.

Download resources for the bonus videos here0:02
Bonus 1 How to improve your Reports even further with custom visuals a few examp18:49
Explore importing custom visuals from app source to enhance Power BI reports, using Esther plot, Sankey chart, and radar chart, and learn to pin visuals and load Excel data.
Bonus 2 How to publish and share your power bi Report3:55
Bonus 3 How to create your own Datestable with DAX explore available Options10:12
Create your own date tables in Power BI using DAX or M code, with calendar or calendar auto, dynamic end dates based on today, and optional extra columns.
Bonus 4 Power BI Interview question SUM vs SUMX Difference12:20
Understand the difference between sum and sumx in Power BI, with sumx iterating row by row (quantity times price) and sum aggregating columns, plus how data modeling choices affect results.
Bonus 5 Best and Worst Customer Identification and dynamic Sales Thresholds with17:42
Power BI Masterclass 2 Expand Excellence Preview What we will learn2:07
Learn time intelligence, advanced visualizations, and navigation best practices in Power BI masterclass 2, including bookmarks, bookmark-triggered visuals, pop-ups, and drill-through in finance reports.
Power BI Bonus Tip Cascading slicers without bidirectional relationships17:37
Learn cascading slicers in Power BI without bidirectional relationships. Create a measure to filter the suppliers slicer using data from the orders table and dates table.
Bonus New way to create dynamic measure selection in Power BI Desktop7:05
Conditional Formating becomes easier3:53
Learn to color Power BI bars using new conditional formatting rules based on string values, such as if value equals a category or contains text, without writing measures.
Power BI Trick Conditional Color for Linechartvisual in Power BI8:32
Data for the next Video0:19
Bonus Mapping Dates to Dateranges in the Power Query Editor6:39
13 Bonus How to use Chat GPT for Power BI11:17
How to add Labels on top or below a horizontal bar chart7:12
IBCS in Power BI with Native Bar charts10:20
Power BI Bonus Dynamic Formating for Measures12:02
Power BI Trick Report page tooltips for images and buttons8:12
Power Query Merge trick without duplicating rows7:05
The various Formatting options for Measures in Power BI9:22
Explore formatting options for measures in Power BI, including thousand separators, currency and unit displays, plus custom or dynamic format strings, and note format converts numbers to text in tables.
Trick to Filter Power BI Tables based on Traffic Light Icons10:27
Power BI Trick Removing unused Measures5:18
Learn how to identify and remove unused measures in Power BI using the Measure Killer tool, with portable and admin options, and back up your report before deleting.
Same Column Size Table Trick2:28
Power Query Tip and Update for Mac Users3:03
Master a Power Query tip to copy selected tables between reports, and learn how Mac users now access Power Query in the service via Get Data.
Create your own DAX functions in Power BI10:19
Disabling Drill down in the Visual Tooltip2:28
Power BI User question Can i export to excel5:06
Power BI devil in the details updates2:53
Congratulations, thanks a lot and one favor to ask0:21

Requirements

Working with Microsoft products e.g. excel is an advantage, but not required
Your willingness to learn and grow
This is a Microsoft Power BI Training for beginners to advanced
Power BI can be downloaded for free from the Microsoft page

Description

Learn Power BI from scratch and build real reports, dashboards, and data models step by step.

This course takes you from beginner to intermediate level, covering data cleaning, data modeling, DAX, and report creation using real-world scenarios.

You will learn how to turn raw data into structured insights and create professional reports used in business environments.

Learn how to use Microsoft Power BI to clean, transform, analyze, and visualize data — starting from the basics and progressing to more advanced techniques.

This course is designed as a structured learning path. You will begin with the fundamentals of Power BI Desktop and gradually move into data modeling, DAX calculations, and report design.

You will work with practical examples and real-world datasets to understand how Power BI is used in business environments to support decision-making.

What makes this course different

This course focuses on a complete workflow rather than isolated features.

You will not just learn individual tools, but how to connect data sources, transform data, build models, and create reports in a structured and practical way.

What you will learn

Import and connect data from different sources
Clean and transform data using Power Query (ETL)
Build data models using relationships and structured tables
Write DAX calculations for analysis and reporting
Create interactive dashboards and reports
Apply best practices for report design and usability
Use AI visuals and advanced features within Power BI
Work with real-world scenarios and datasets

How you will learn

This course follows a hands-on approach. You will start from zero and build your knowledge step by step through practical examples.

Each section builds on the previous one, allowing you to develop a complete understanding of the Power BI workflow.

Additional topics covered

Data transformation with Power Query
Introduction to data modeling concepts
DAX fundamentals and practical calculations
Dashboard design and interactivity
AI features in Power BI

Who this course is for

Beginners who want to learn Power BI from scratch
Excel users who want to move into data visualization and reporting
Aspiring data analysts who want to build practical skills
Professionals who want to improve their reporting and dashboard capabilities
Anyone looking for a structured introduction to Power BI

Who this course is for:

Beginners who want to learn Power BI Desktop from scratch
Excel users who want to move into reporting, dashboards, and business intelligence
Business analysts, controllers, and managers who need better reporting skills
Career switchers preparing for entry-level data analyst or BI roles
You want to succeed in the working world of tomorrow
You want to create stunning visualizations to impress management or your coworkers
Learners who want hands-on Power Query and DAX practice, not theory only

Power BI Desktop: Beginner to Advanced with DAX & ETL

What you'll learn

Explore related topics

Course content

One Note before we start1 lecture • 1min

The Power BI Masterclass New Update44 lectures • 9hr 53min

How to use CALCULATE in Power BI Desktop18 lectures • 2hr 51min

Bonus section29 lectures • 3hr 37min

More PowerLearning1 lecture • 1min

Requirements

Description

Who this course is for: