NEED HELP? TALK TO AN EXPERT (904) 638-5743

Advanced Power BI

WHAT YOU'LL LEARN

  • To build your own dashboards
  • To understand the Power BI ecosystem
  • To extract and model data
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

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

Outline

 

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

Instructor

MITCHELL PEARSON

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.

REVIEWS

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

Anonymous

Loved Mitchell's use of demos! Thanks!

Anonymous

There were a lot of cool things in this class.

Anonymous

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required