Advanced business intelligence
Intermediate to Advanced Power BI
Build scalable Power BI models and richer reports using advanced Power Query, relationships, DAX measures, drill-through, hierarchies, bookmarks, and AI visuals.
Move from basic reports to robust analytical models.
For Power BI users who already create visuals and need stronger modeling, calculation, interaction, and reporting capability.
Resolve relationship and model-design problems.
Create richer interactive report experiences.
Build calculated columns and explicit DAX measures.
Use advanced DAX to drive meaningful visuals.
Course overview
A practical, instructor-led program with guided exercises and workplace examples. Open a topic to see the coverage.
Part 1. Review of Basic PowerBI
- Setting up PowerBI
- Connecting Data using PowerQuery
Part 2. Advanced Data Modeling using Table Relationships
- Merging and Appending Queries
- Types of Joins (Merging)
Part 3. Level Up Data Visualization Features
- Creating Conditional Formatting
- Creating Drill Through Filters
Part 4. Using DAX Formulas
- Understanding Implicit and Explicit Measures
- Creating Calculated Columns and Calculated Measures
Full course outline
Review the complete legacy course outline, including all detailed subtopics.
View full outline
- Part 1. Review of Basic PowerBI
- Setting up PowerBI
- Connecting Data using PowerQuery
- Creating Basic Visuals
- Publishing Reports
- Hiding Elements from Published View
- Publishing in Mobile View
- Part 2. Advanced Data Modeling using Table Relationships
- Merging and Appending Queries
- Types of Joins (Merging)
- Editing Table Relationships
- Fixing Data Relationship Problems
- Fixing Invalid Relationships using Bridges
- Creating Sort Tables
- Unpivoting
- Part 3. Level Up Data Visualization Features
- Creating Conditional Formatting
- Creating Drill Through Filters
- Using and Creating Hierarchies
- Adding Analytics in Visuals
- Using Bookmarks, Buttons, and Actions
- AI Charts
- Q&A Charts
- Creating Synonyms for AI Charts
- Part 4. Using DAX Formulas
- Understanding Implicit and Explicit Measures
- Creating Calculated Columns and Calculated Measures
- Using Calculated Measures in Visuals
- Using the DAX Query View Overview
- Using DAX Formulas in Creating Visuals
- Common DAX Functions
- Iterator X Functions
- RELATED Function
- CALCULATE Function
- ALL Function