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 - Beginners to Advanced level
Rating: 4.6 out of 5(8 ratings)
21 students

Power BI Desktop - Beginners to Advanced level

Power BI Desktop & Data Modeling
Last updated 11/2025
English

What you'll learn

  • You will learn more in depth DAX and data modeling
  • Craft out measures and debug them using DAX query view
  • Compile multiple excel files and update them
  • Learn how to build a Dashboard after crafting measures

Course content

1 section37 lectures5h 51m total length
  • Introduction to my courses2:30
  • Data Normalization15:19
  • Normalization
  • Lets build a Calendar table13:57
  • Validate your numbers10:07
  • Subfolders for Measures
  • RELATED and CALCULATED COLUMNS4:13
  • Limit use of Calculated Columns4:54
  • Calculated Columns
  • SUMX & RELATED8:27
  • Context Transition6:38
  • What is meant by Context Transition
  • Calculated Column10:58
  • Income Band12:53
  • Iterator Functions14:25
  • Debugging your work4:07
  • RANKX11:46
  • SUMMARIZE15:43
  • ADDCOLUMNS14:25
  • Ranking Hierarchy15:00
  • Visual Calculations10:16
  • Visual Calculations - Versus15:44
  • Visual Calculations - Running Sum12:38
  • Current Year Sales7:51
  • Customer Age Band9:10
  • Scatter Plot13:50
  • INTERSECT12:17
  • EXCEPT5:53
  • CROSSFILTER11:45
  • Calculate Repeat Purchases15:33
  • PARALLELPERIOD15:07
  • DATEADD3:24
  • MTD, QTD, YTD4:56
  • Previous MTD8:00
  • Current week calculation7:33
  • Working Days5:16
  • Previous Week2:03
  • New Time Intelligence Calendar8:21
  • Fiscal Year Calculation6:39
  • Fiscal Month5:26
  • Creating Folders and Subfolders to house Measures4:14

Requirements

  • Basic knowledge for Power BI Desktop

Description

Unlock the full potential of Power BI with this advanced, hands-on course designed to transform how you think about data analysis and modeling.

In this course, you’ll go beyond basic dashboards and learn the core principles that power professional-level analytics — from efficient data model design to writing powerful, optimized DAX formulas.

You’ll discover how to:

  • Design and optimize data models for accuracy and performance

  • Master advanced DAX concepts, including CALCULATE, FILTER, ITERATORS, and Time Intelligence

  • Create dynamic measures and KPIs for real-world reporting scenarios

  • Debug, test, and improve your DAX calculations

  • Apply best practices used by data analysts and BI professionals in top organizations

If you’ve ever worked with multiple Excel files, sales reports, or regional sheets and struggled to combine them into one consistent dashboard — this course will show you the right way to do it.

You’ll learn how to:

  • Connect and transform multiple Excel files or CSVs into a unified Power BI model

  • Build relationships between tables (fact and dimension design) to eliminate manual lookups

  • Use star schema modeling to make your reports faster, cleaner, and easier to maintain

  • Master Advanced DAX

By the end of this course, you’ll be able to confidently build Power BI reports, backed by clean models and efficient DAX — the same skills used by top data professionals worldwide.

Who this course is for:

  • Beginners and Intermediate Power BI users