Power BI Masterclass
- 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 course is a comprehensive program that takes you from a data novice to a confident BI professional. As students work through the curriculum, they learn how to connect to real-world data sources, clean and transform messy datasets, and build interactive dashboards that turn numbers into actionable insights.
Going beyond the basics, this masterclass dives deep into data modeling, DAX formulas, and enterprise-level features that separate intermediate users from true Power BI experts. You'll also learn to design reliable relational data models, implement Row-Level Security to control access across your organization, and create flexible reports using parameters and custom hierarchies.
Curriculum
What you'll learn
- Import and clean data from Excel, CSV, and other sources using Power Query, then design polished reports with charts, maps, cards, and slicers
- Create measures, calculated columns, and custom aggregations to unlock deeper analytical capabilities in your reports
- Master table relationships, cardinality, cross-filter direction, and filter flow to build dynamic, filterable reports that are free of common modeling mistakes
- Create reusable fiscal and calendar date tables to power time-based analysis and comparisons across your reports
- Control who sees what data using both static and dynamic security roles, ensuring your reports are enterprise-ready
- Set up dashboards in the Power BI Service, schedule data refreshes, manage reusable datasets, and collaborate with stakeholders across your organization
Course outline
-
Power BI Bootcamp 12 hours
Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.
- Import data from Excel worksheets, CSV, and many more
- Transform/clean your data using Power Query
- Create interactive visualizations, such as charts, maps, cards, and slicers, to explore trends and patterns
- Use DAX (Data Analysis Expressions) to build measures, calculated columns, and custom aggregations
- Design visually engaging reports by adding titles, logos, and formatting options for a professional finish
- Understand and manage relationships between tables to create dynamic, filterable reports
- Share and collaborate on reports via the Power BI Service
- Set up dashboards and explore the differences between dashboards and reports for business presentations
- Schedule data refreshes and manage reusable datasets to keep reports up-to-date and scalable
-
Power BI Advanced 6 hours
This advanced Power BI course focuses on building more reliable data models using proper relationships, filter flow, fiscal and calendar date tables, Row-Level Security, and more.
- 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
- 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
Mon, Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Wed, Thu, Fri
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Wed, Thu, Fri
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EST)
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This program is available for 60 days. You can choose when to start your access period. Once you activate, you will have 60 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
- $899
- Course length
- 18 hours
- Schedule
- On your schedule
This self-paced Power BI course takes you from the fundamentals of data analysis to advanced reporting and data modeling skills. As you progress through the curriculum, you’ll learn how to connect to real-world data sources, clean and transform raw data, and create interactive dashboards that help turn information into clear business insights.
You’ll also go beyond the basics by working with DAX formulas, relational data models, and advanced reporting features used in professional environments. Throughout the course, you’ll build skills in creating measures and calculated columns, managing filter flow and relationships, implementing Row-Level Security, and publishing dashboards in the Power BI Service.
Self-paced curriculum
What you'll learn self-paced
- Import and clean data from Excel, CSV, and other sources using Power Query, then design polished reports with charts, maps, cards, and slicers
- Create measures, calculated columns, and custom aggregations to unlock deeper analytical capabilities in your reports
- Master table relationships, cardinality, cross-filter direction, and filter flow to build dynamic, filterable reports that are free of common modeling mistakes
- Create reusable fiscal and calendar date tables to power time-based analysis and comparisons across your reports
- Control who sees what data using both static and dynamic security roles, ensuring your reports are enterprise-ready
- Set up dashboards in the Power BI Service, schedule data refreshes, manage reusable datasets, and collaborate with stakeholders across your organization
Self-paced course outline
-
Power BI Bootcamp (Self-Paced) 12 hours
Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.
- Import and clean data from multiple sources, including Excel, CSV, and online databases, using Power Query
- Create interactive visualizations, such as charts, maps, cards, and slicers, to explore trends and patterns
- Use DAX (Data Analysis Expressions) to build measures, calculated columns, and custom aggregations
- Design visually engaging reports by adding titles, logos, and formatting options for a professional finish
- Understand and manage relationships between tables to create dynamic, filterable reports
- Share and collaborate on reports via the Power BI Service, including exporting, commenting, and app integration
- Set up dashboards and explore the differences between dashboards and reports for business presentations
- Schedule data refreshes and manage reusable datasets to keep reports up-to-date and scalable
-
Power BI Advanced (Self-Paced) 6 hours
This advanced Power BI course focuses on building more reliable data models using proper relationships, filter flow, fiscal and calendar date tables, Row-Level Security, and more.
- 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 Bootcamp (Self-Paced)
-
Course Overview & Setup
Lesson 1: Getting Started with Power BI
0:55
Introduces the structure of the Power BI course and explains how to use class files, PDFs, and step-by-step guides to build skills progressively.
This preview is temporarily unavailable. Please try again later.
-
Overview of Power BI
Lesson 1: Getting Started with Power BI
10:00
Explains what Power BI is, how it’s used for business intelligence, and how it compares to Excel, including an overview of Desktop, Service, and mobile access.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Installing the Power BI Desktop app
Lesson 1: Getting Started with Power BI
1:14
Walks through installing Power BI Desktop via the Microsoft Store, explaining update cycles and how to launch the application.
View enrollment options at Noble Desktop -
Enrollment required
Create our First Visualization
Lesson 1: Getting Started with Power BI
16:02
Demonstrates importing data and creating basic visuals like tables and column charts while explaining data types and automatic visual suggestions.
View enrollment options at Noble Desktop -
Enrollment required
Publishing and Sharing Reports
Lesson 1: Getting Started with Power BI
10:35
Covers publishing reports to the Power BI Service, including workspaces, sharing options, licensing, and browser-based access.
View enrollment options at Noble Desktop -
Enrollment required
Managing Links to Data Source Files & Refreshing Data
Lesson 1: Getting Started with Power BI
2:15
Explains how Power BI connects to external data sources rather than embedding files and how to manage paths and refresh data.
View enrollment options at Noble Desktop -
Transforming Data
Lesson 2: Transforming Data Using Power Query
10:00
Introduces Power Query for data transformation, including cleaning data, handling missing values, and improving performance through upstream changes.
This preview is temporarily unavailable. Please try again later.
-
Merge Queries
Lesson 2: Transforming Data Using Power Query
10:00
Explains merging tables in Power Query to combine related data and introduces normalized data concepts and lookup tables.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Append Queries
Lesson 2: Transforming Data Using Power Query
8:13
Demonstrates appending queries to combine multiple tables with the same structure into a single dataset.
View enrollment options at Noble Desktop -
Enrollment required
Fill and Transpose
Lesson 2: Transforming Data Using Power Query
5:16
Covers advanced transformations such as fill down and transpose to correct poorly structured data.
View enrollment options at Noble Desktop -
Enrollment required
Unpivot & Merge Columns
Lesson 2: Transforming Data Using Power Query
10:26
Demonstrates unpivoting data, combining date fields, assigning correct data types, and preparing datasets for time-based analysis.
View enrollment options at Noble Desktop -
Enrollment required
Query Dependencies
Lesson 2: Transforming Data Using Power Query
1:43
Explores Query Dependencies to visualize how data sources and transformations connect and to troubleshoot complex models.
View enrollment options at Noble Desktop -
Enrollment required
Getting Data from Multiple Files in a Folder (Appending from Folder)
Lesson 2: Transforming Data Using Power Query
4:59
Demonstrates importing and automatically appending files from a folder to support scalable data updates.
View enrollment options at Noble Desktop -
Relationships
Lesson 3: Building the Adventure Works Report
10:00
Explains creating relationships between fact and dimension tables and introduces star schema modeling.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Importing Data and Building Relationships
Lesson 3: Building the Adventure Works Report
10:00
Walks through building a relational model using AdventureWorks data and validating automatically detected relationships.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Designing and Building the Report
Lesson 3: Building the Adventure Works Report
7:20
Focuses on report design using text boxes, images, alignment tools, and layout best practices for professional presentations.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works Intro to DAX Adding the Current Date
Lesson 3: Building the Adventure Works Report
7:22
Introduces DAX by creating a simple date measure and explains the difference between measures and calculated columns.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works DAX Calculated Columns Profit or Loss
Lesson 3: Building the Adventure Works Report
14:04
Demonstrates creating calculated columns with DAX and using relationships and the RELATED function across tables.
View enrollment options at Noble Desktop -
Adventure Works Removing the Default White Background from VIsuals by editing the Theme
Lesson 4: Visuals, Slicers, and More
2:00
Shows how to customize Power BI themes to remove default styling and apply consistent global design changes.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Adding more visuals
Lesson 4: Visuals, Slicers, and More
3:17
Builds additional visuals to analyze sales by customer attributes while demonstrating interactive filtering.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Slicers
Lesson 4: Visuals, Slicers, and More
20:24
Introduces slicers as interactive filters and demonstrates layout improvements and user-friendly labeling.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works SUM vs SUMX
Lesson 4: Visuals, Slicers, and More
12:01
Explains the difference between SUM and SUMX in DAX and why iterator functions are needed for row-level calculations.
View enrollment options at Noble Desktop -
Enrollment required
Adjusting a Desktop Report for Mobile Devices
Lesson 4: Visuals, Slicers, and More
2:58
Demonstrates optimizing reports for mobile using the mobile layout view and adjusting visuals for smaller screens.
View enrollment options at Noble Desktop -
Global Superstore Import Data, Define Relationships, and Create Visuals
Lesson 5: Building the Global Superstore Report
10:00
Walks through importing and modeling Global Superstore data to reinforce ETL and star schema concepts.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore Intro to Filters
Lesson 5: Building the Global Superstore Report
10:00
Introduces visual-, page-, and report-level filters and explains when filters are preferable to slicers.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Top N Filter and Filter Across All Pages
Lesson 5: Building the Global Superstore Report
7:00
Demonstrates Top N filters to highlight best- and worst-performing items and explains how ties affect results.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Sales by Country Page
Lesson 5: Building the Global Superstore Report
9:27
Builds a multi-page report analyzing sales by country using slicers and geographic comparisons.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Edit Interactions
Lesson 5: Building the Global Superstore Report
4:16
Explains how to control visual interactions to compare filtered values against unfiltered totals.
View enrollment options at Noble Desktop -
Global Superstore Controlling Filtering with SUM and SUMX
Lesson 6: Diving Deeper into DAX
8:46
Demonstrates using SUM and SUMX to control whether calculations respect or ignore filters.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore CONCATENATEX, COUNT, and COUNTX
Lesson 6: Diving Deeper into DAX
7:42
Introduces CONCATENATEX, COUNT, and COUNTX for advanced aggregations and dynamic titles.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore CALCULATE
Lesson 6: Diving Deeper into DAX
5:03
Explains how CALCULATE applies filters within DAX expressions to create reusable measures.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Matrix Visual with Conditional Formatting Icons and Data Bars
Lesson 6: Diving Deeper into DAX
4:10
Builds a matrix visual with conditional formatting to highlight performance trends at a glance.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Quick Measures
Lesson 6: Diving Deeper into DAX
7:21
Uses Quick Measures to generate common DAX calculations like YTD and YoY while keeping measures organized.
View enrollment options at Noble Desktop -
Global Superstore Maps
Lesson 7: Maps, Drill Down, and Drill Through
6:14
Creates map visuals with Azure Maps and explains data categorization and geographic field requirements.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Drill Down
Lesson 7: Maps, Drill Down, and Drill Through
10:41
Demonstrates drill-down using hierarchies to move between summary and detailed views.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Drill Through
Lesson 7: Maps, Drill Down, and Drill Through
6:21
Builds drill-through navigation between report pages while preserving filter context.
View enrollment options at Noble Desktop -
Global Superstore Scheduling Data Refreshes and Getting Data
Lesson 8: Refreshing Data, Dashboards & Databases
Explains local refresh versus scheduled refresh in the Power BI Service using OneDrive and shared models.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dashboards
Lesson 8: Refreshing Data, Dashboards & Databases
4:02
Explains how Power BI dashboards aggregate pinned visuals while linking back to underlying reports.
View enrollment options at Noble Desktop -
Enrollment required
Connecting to a Database
Lesson 8: Refreshing Data, Dashboards & Databases
4:00
Demonstrates connecting Power BI to databases like SQL Server and compares Import and DirectQuery modes.
View enrollment options at Noble Desktop -
Enrollment required
Course Outro
Lesson 8: Refreshing Data, Dashboards & Databases
0:13
Encourages continued practice to improve efficiency, confidence, and the ability to build original Power BI reports.
View enrollment options 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