Advanced Power BI


  • To build your own dashboards
  • To understand the Power BI ecosystem
  • To extract and model data
This course includes:

Course Description

This class is designed to get you up to speed on the latest with Power BI. First you will learn how to query and pull in data. Then organize the results into a data model with relationships and calculations. Finally, you will learn the best way to visualize your data through a variety of charts, graphs, maps and gauges that are provided. This class exclusively uses the Power BI Desktop application to create solutions that are deployed to the Power BI Service and are then visible from any devices.


Click here for a downloadable PDF



Module 00 | Class Introduction
07m 55s total


Module 00A | Class Introduction
07m 55s


Module 01 | R Integration
78m 80s total


Module 01A | Installation and Configuration
08m 27s


Module 01B | R Scripting Basics
33m 07s


Module 01C | R for Data Cleansing
20m 46s


Module 01D | Check if File Exists
17m 00s


Module 02 | M Query
91m 11s total


Module 02A | The M Syntax
14m 18s


Module 02B | #shared
12m 29s


Module 02C | M Query Basics
16m 27s


Module 02D | Variables and Parameters
24m 56s


Module 02E | Expanding Lists
10m 23s


Module 02F | M Query Functions
13m 58s


Module 03 | Advanced Data Modeling
157m 60s total


Module 03A | Filtering
21m 36s


Module 03B | Cross-Filtering and Time Intelligence
19m 09s


Module 03C | Many to Many with DAX
11m 03s


Module 03D | Creating a Bridge Table
13m 43s


Module 03E | Role Playing Tables with DAX
22m 01s


Module 03F | Role Playing Tables without DAX
19m 28s


Module 03G | Mismatched Granularies
31m 22s


Module 03H | Weighted Allocation
20m 18s


Module 04 | Query Folding
30m 51s total


Module 04A | Basics
20m 48s


Module 04B | Beyond Basics
10m 03s


Module 05 | Velocity
73m 16s total


Module 05A | Overview
28m 20s


Module 05B | Vertipaq Analyzer
18m 18s


Module 05C | Column Cardinality
14m 21s


Module 05D | Calculated Columns
12m 57s


Module 06 | Advanced Visualizations
113m 67s total


Module 06A | Digital Storytelling
13m 20s


Module 06B | Bookmarks
26m 11s


Module 06C | Selection Pane
20m 52s
Module 06D | Drillthrough
08m 55s
Module 06E | Visuals with DAX
11m 03s
Module 06F | Custom Visuals
22m 05s


Module 06G | Custom Themes
12m 21s


Module 07 | Power BI Administration
82m 72s total


Module 07A | Data Refresh
23m 01s


Module 07B | Scheduling Data Refresh
29m 20s


Module 07C | Implementing Row Level Security
16m 47s


Module 07D | Implementing Row Level Security
16m 47s


Module 08 | Power BI Embedded
18m 51s total


Module 08A | Power BI Embedded
18m 51s



Training Content Manager

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.


System Requirements

  • Windows 10, Windows 7, Windows 8 or Windows 8.1, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2
  • Microsoft Power BI Desktop requires Internet Explorer 10 or greater
  • Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
  • Power BI Desktop

What to Know Before Class

Because this class is focused on self-service end user solutions, previous SQL Server knowledge is not required. While it’s not mandatory, ideally students should have a basic understanding of database terminology, such as tables, views, columns, rows, relationships, etc.

Excellent course material and presentation. Great examples that can be adapted and applied at work.


Loved Mitchell's use of demos! Thanks!


There were a lot of cool things in this class.


Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!