Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Power BI: Data Modeling, DAX & Dashboard Mastery
Role Play
Rating: 4.2 out of 5(1,013 ratings)
45,020 students

Advanced Power BI: Data Modeling, DAX & Dashboard Mastery

Master Power Query, DAX, and advanced data visualization to build powerful business intelligence dashboards
Role Play
Created byStarweaver Experts, Paul Siegel, Jeff Robson
Last updated 4/2026
English

What you'll learn

  • Understand how Power BI works and why Microsoft Power BI is widely used for data analytics and data visualization.
  • Import and connect data from multiple sources using Power BI Desktop for business intelligence.
  • Clean, transform, and prepare data using Power Query, including an introduction to M code.
  • Join and combine datasets from different sources to build structured models for data analysis in Power BI.
  • Build efficient data models by creating relationships, merging, and appending datasets.
  • Apply best practices in data modeling to create scalable and optimized Power BI solutions.
  • Use Power BI DAX to create calculations, measures, and advanced analytics beyond Excel capabilities.
  • Understand filter context in DAX formulas and how it impacts calculations and insights.
  • Design and build interactive dashboards using data visualization and data storytelling techniques.
  • Apply best practices for creating insightful dashboards in Power BI, including financial and business analytics use cases.
  • Automate data workflows by combining multiple files and creating reusable queries in Power BI.
  • Create calendar tables and use them to slice, filter, and summarize reports effectively.
  • Identify and resolve data issues by building queries that detect errors and missing values.
  • Learn how Power BI helps in data analysis and why it is preferred over other data visualization tools.
  • Create and share interactive Power BI dashboards that deliver actionable insights for business decision-making.

Course content

7 sections • 43 lectures • 10h 42m total length

  • Welcome!0:52

    Just a brief "hello" and explanation for you.

  • Introduction to Power BI16:10

    In this module, you will learn the basics of Microsoft Power BI, data visualization, and reporting tool. Topics include creating reports, charts, and dashboards from various data sources.

  • Power BI Tools of Power Query and Data Modelling Basics8:35

    This module covers the Power Query and data modeling tools in Power BI. You will learn how to import and transform data, create relationships and measures, and use DAX functions for data analysis.

  • Introduction to How Power BI Works29:01

    This module covers the fundamentals of how Power BI works. You will learn about the Power BI service, how to connect to and import data, and how to create and publish interactive reports and dashboards.

  • Functionality and Features of Power Query36:09

    In this module, you will learn about the functionality and features of Power Query, a data transformation tool in Power BI. Topics include importing and shaping data, creating and using functions, and optimizing performance.

  • Initial Graphics in Power BI9:33

    This module covers the basics of creating graphics in Power BI. You will learn how to create and customize charts, maps, and other visualizations, as well as how to use these to communicate data insights effectively.

  • First Steps in Complex Visualizations12:19

    This module covers the first steps in creating complex visualizations in Power BI. You will learn how to use advanced visualization types, such as treemaps and funnel charts, as well as how to use custom visuals and advanced formatting options.

  • More Complex Visualizations - Part A10:37

    In this module, you will learn how to create more complex visualizations in Power BI. Topics include using custom shapes and images, creating animated and interactive reports, and working with more advanced formatting options.

  • More Complex Visualizations - Part B21:14

    This module covers more advanced techniques for creating complex visualizations in Power BI. You will learn how to use custom visuals, create and customize maps, and work with advanced formatting options to create visually stunning reports and dashboards.

  • More Complex Visualizations - Part C14:55

    In this module, you will continue to learn advanced techniques for creating complex visualizations in Power BI. Topics include using custom shapes and images, creating animated and interactive reports, and working with more advanced formatting options.

  • More Complex Visualizations - Part D45:16

    This module covers additional advanced techniques for creating complex visualizations in Power BI. You will learn how to use custom visuals, create and customize maps, and work with advanced formatting options to create visually stunning reports and dashboards.

  • Bringing It All Together18:04

    This module covers how to bring all of the skills and concepts learned in the course together to create a comprehensive Power BI report or dashboard. You will learn how to integrate data from multiple sources, create advanced visualizations, and use features such as filtering and drill-downs to create interactive and effective data presentations.

  • Data Modelling29:34

    In this module, you will learn about data modeling in Power BI. Topics include creating and managing relationships, creating measures and calculated columns using DAX, and optimizing model performance.

  • Module Quiz
  • Hands-On-Learning: Creating and Analyzing DAX Measures in Power BI1:10

    In this project, "Creating and Analyzing DAX Measures in Power BI," you'll learn how to build and apply advanced DAX measures to analyze cost center data effectively. You'll create calculations for total actuals, variance, and percentage contributions while mastering filter context manipulation. Through visual elements like bar charts, matrix visuals, and slicers, you'll bring your data insights to life.

Requirements

  • This is an introductory Power BI course, and no prior experience with Microsoft Power BI is required.
  • However, participants will gain more value if they have some basic familiarity with Power BI Desktop or have explored it independently. Those who are self-taught in Power BI will benefit from filling knowledge gaps and strengthening their understanding of data modeling, data manipulation and data visualization.
  • A general understanding of databases, Excel formulas, and Excel Pivot Tables is helpful, though not essential.

Description

Microsoft Power BI enables users to extract data from multiple sources, combine and model it, perform calculations, and create powerful data visualizations for better decision-making.

Power BI is a leading cloud-based business intelligence service provided by Microsoft that allows users to transform raw data into rich, interactive dashboards, providing a comprehensive 360-degree view of business performance.

With Microsoft Power BI Desktop, you can connect to a wide range of data sources, clean and transform data using Power Query, build relationships through data modeling, and create compelling, interactive reports. These capabilities make Power BI an essential tool for modern data analytics and data storytelling.

The platform also allows users to publish and share dashboards across teams. Reports can be set to refresh automatically and accessed securely via web browsers or mobile devices making Power BI ideal for real-time business insights.

More about this course and Starweaver

This course is led by a seasoned technology industry practitioner and executive with many years of hands-on, in-the-trenches data analysis and visualization work. It has been designed, produced and delivered by Starweaver. Starweaver is one of the most highly regarded, well-established training providers in the world, providing training courses to many of the leading financial institutions and technology companies, including:

Ahli United Bank; Mashreqbank; American Express; ANZ Bank; ATT; Banco Votorantim; Bank of America; Bank of America Global Markets; Bank of America Private Bank; Barclay Bank; BMO Financial Group; BMO Financial Services; BNP Paribas; Boeing; Cigna; Citibank; Cognizant; Commerzbank; Credit Lyonnais/Calyon; Electrosonic; Farm Credit Administration; Fifth Third Bank; GENPACT; GEP Software; GLG Group; Hartford; HCL; HCL; Helaba; HSBC; HSBC Corporate Bank; HSBC India; HSBC Private Bank; Legal & General; National Australia Bank; Nomura Securities; PNC Financial Services Group; Quintiles; RAK Bank; Regions Bank; Royal Bank of Canada; Royal Bank of Scotland; Santander Corporate Bank; Tata Consultancy Services; Union Bank; ValueMomentum; Wells Fargo; Wells Fargo India Solutions; Westpac Corporate Bank; Wipro; and, many others.

Happy learning.

Who this course is for:

  • Excel users, data analysts, and professionals working with data who want to advance their skills in Power BI, data modeling, data manipulation and data visualization.
  • Professionals responsible for building interactive dashboards, performing advanced data analytics, and delivering business insights.
  • Individuals looking to automate complex reporting workflows and create scalable solutions using Microsoft Power BI and DAX.

Report abuse