Power BI Advanced
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
This advanced Power BI course is designed for people who have some experience building reports, but want to better understand how Power BI handles data behind the scenes. You’ll learn to build better data models (using the correct relationships and filter flow) to make reports more reliable by ensuring totals, filters, and calculations behave the way you want.
In this training, you will build data models using hierarchies, custom sort orders, and reusable date tables that support both fiscal and calendar year reporting. You will deepen your DAX knowledge by working with parameters, inactive relationships, and context-aware calculations, while learning when logic belongs in the data model versus in a DAX measure. You will also implement Row-Level Security (RLS), including dynamic security based on the logged-in user, to control data access in shared reports.
You will learn how to connect Power BI to databases, understand Import versus DirectQuery tradeoffs, and improve performance as you learn about query folding. By the end of the course, you will be better prepared to troubleshoot common modeling issues, publish secure datasets, and apply best practices that align with Microsoft’s PL-300 Power BI Data Analyst Associate certification.
Prerequisites
Students should have Power BI knowledge equivalent to our Power BI Bootcamp.
Curriculum
What you'll learn
- Build better data models by understanding relationships, cardinality, and cross-filter direction
- Design reliable data models and avoid common modeling mistakes
- Create and use hierarchies to organize and drill into data
- Control visual order with custom sort columns
- Create reusable date tables supporting fiscal and calendar years
- Add parameters to make reports interactive and flexible
- Implement Row-Level Security (RLS) with Static and Dynamic roles
Course syllabus
Hierarchies
- Grouping Data with Hierarchies
- Creating & Using Hierarchies
Custom Sort Order
- Default vs Custom Sorting
- Making & Using a Custom Sort Order
Date Tables and Fiscal Calendars
- Dates & Date Tables
- Fiscal Year vs Calendar Year
- Creating Date Hierarchies
- Sorting Date Columns
Diving Deeper into Data Modeling
- Data Modeling vs DAX
- Common Mistakes
Relationships & Cross-Filter Direction
- One to Many (1:*) Relationships
- Cross-Filter Direction
- Many to Many & Bi-Directional Filtering
- Troubleshooting Data Modeling Problems
Parameters
- Creating & Using Parameters
- Formerly called “What-If parameters”
Inactive Relationships & USERELATIONSHIP()
- Active vs Inactive Relationships
- Using USERELATIONSHIP()
Row-Level Security (RLS)
- Setting Up Row-Level Security (RLS)
- Static and Dynamic Roles
- Configuring RLS in the Power BI Service
Power BI Certification
- About the Microsoft Certified Power BI Data Analyst Associate PL-300 Exam
- PL-300 Exam Information and Resources
Working with Databases
- Connecting to a Database
- Import vs DirectQuery
- Query Folding (Optimizing Query Performance)
What's included
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $399
- Course length
- 6 hours
- Schedule
- On your schedule
This advanced Power BI course is self-paced and designed for people who have some experience building reports, but want to better understand how Power BI handles data behind the scenes. You’ll learn to build better data models (using the correct relationships and filter flow) to make reports more reliable by ensuring totals, filters, and calculations behave the way you want.
In this training, you will build data models using hierarchies, custom sort orders, and reusable date tables that support both fiscal and calendar year reporting. You will deepen your DAX knowledge by working with parameters, inactive relationships, and context-aware calculations, while learning when logic belongs in the data model versus in a DAX measure. You will also implement Row-Level Security (RLS), including dynamic security based on the logged-in user, to control data access in shared reports.
You will learn how to connect Power BI to databases, understand Import versus DirectQuery tradeoffs, and improve performance as you learn about query folding. By the end of the course, you will be better prepared to troubleshoot common modeling issues, publish secure datasets, and apply best practices that align with Microsoft’s PL-300 Power BI Data Analyst Associate certification.
Self-paced curriculum
What you'll learn self-paced
- Build better data models by understanding relationships, cardinality, and cross-filter direction
- Design reliable data models and avoid common modeling mistakes
- Create and use hierarchies to organize and drill into data
- Control visual order with custom sort columns
- Create reusable date tables supporting fiscal and calendar years
- Add parameters to make reports interactive and flexible
- Implement Row-Level Security (RLS) with Static and Dynamic roles
What's included with self-paced
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Power BI Advanced (Self-Paced)
-
Course Overview & Setup
Lesson 1: Hierarchies and Sorting
1:03
Explore advanced Power BI training focused on data modeling, performance optimization, and data security.
This preview is temporarily unavailable. Please try again later.
-
Hierarchies
Lesson 1: Hierarchies and Sorting
10:00
Understand how to build and use hierarchies in Power BI to organize data into logical levels like category, subcategory, and product.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Custom Sort Order
Lesson 1: Hierarchies and Sorting
8:37
Learn how to implement custom sorting in Power BI using dedicated sort columns to control data order beyond default alphabetical or numerical sorting.
View enrollment options at Noble Desktop -
Understanding Dates, Date Tables, and Fiscal Years
Lesson 2: Date Tables and Fiscal Calendars
10:00
Master date handling in Power BI by creating dedicated date tables that support time intelligence and fiscal calendars.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Date Hierachies, Column Sorting, and Using our Calendar vs Fiscal Years
Lesson 2: Date Tables and Fiscal Calendars
8:06
Create custom date hierarchies and apply proper column sorting to ensure accurate time-based reporting.
View enrollment options at Noble Desktop -
Data Modeling Diving Deeper
Lesson 3: Data Modeling
10:00
Dive deeper into Power BI data modeling concepts, including relationships, filter flow, and the role of DAX in calculations.
This preview is temporarily unavailable. Please try again later.
-
Data Modeling Example of a Common Many to Many Mistake
Lesson 3: Data Modeling
10:00
Identify common many-to-many relationship mistakes in Power BI and understand how they lead to incorrect calculations and duplicate results.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Data Modeling Many to Many & Bi Directional Filtering
Lesson 3: Data Modeling
14:12
Analyze advanced data modeling scenarios involving many-to-many relationships and bidirectional filtering.
View enrollment options at Noble Desktop -
Enrollment required
Parameters
Lesson 3: Data Modeling
4:39
Enable dynamic reporting in Power BI by using parameters to let users adjust inputs like date ranges or calculation windows.
View enrollment options at Noble Desktop -
Enrollment required
Inactive Relationships and USERELATIONSHIP
Lesson 3: Data Modeling
10:29
Leverage inactive relationships in Power BI and activate them using USERELATIONSHIP within DAX calculations.
View enrollment options at Noble Desktop -
Enrollment required
Troubleshooting Data Modeling Problems
Lesson 3: Data Modeling
1:38
Diagnose common Power BI data modeling issues such as incorrect totals, broken relationships, and inconsistent DAX results.
View enrollment options at Noble Desktop -
Intro to Row Level Security (RLS)
Lesson 4: Row-Level Security (RLS)
3:23
Understand how to implement row-level security (RLS) in Power BI to control data access at the user level.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Row Level Security (RLS) Static Roles
Lesson 4: Row-Level Security (RLS)
13:38
Configure static row-level security roles in Power BI using predefined filters to restrict data visibility.
View enrollment options at Noble Desktop -
Enrollment required
Row Level Security (RLS) Dynamic Roles
Lesson 4: Row-Level Security (RLS)
15:42
Implement dynamic row-level security in Power BI by leveraging user login credentials to control data access.
View enrollment options at Noble Desktop -
Enrollment required
Power BI Certification PL 300 Exam Info and Prep Materials
Lesson 5: Power BI Certification
2:41
Prepare for the Microsoft PL-300 Power BI certification exam with guidance on exam structure, study resources, and practice strategies.
View enrollment options at Noble Desktop -
Connecting to a Database
Lesson 6: Databases and Query Folding
7:41
Connect Power BI to databases like SQL Server using import and DirectQuery modes.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Query Folding
Lesson 6: Databases and Query Folding
11:19
Optimize Power BI performance by understanding query folding and how transformations are pushed to the data source.
View enrollment options at Noble Desktop -
Enrollment required
Course Outro
Lesson 6: Databases and Query Folding
0:11
Wrap up the Power BI training with key takeaways and encouragement to apply learned techniques in real-world projects.
View enrollment options at Noble Desktop