Advanced Power BI

> >

Advanced Power BI
On-Demand Training

Get up to speed on the latest in Power BI.

All website training purchases 50% off through February 28th.

3:13

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel

message

Course Details

Understanding the basics of Power BI can only get you so far. There are many lesser known advanced features within the tool that can take your Power BI knowledge to the next level. This course explores those features. Starting with how the languages of R and M can be used to extend the standard data extraction and transformation capabilities of Power BI. You will then understand complex data modeling scenarios and how Power BI can overcome them. Lastly, you will learn about several advanced data visualization techniques that can take your reports and dashboards beyond the basics.

Prerequisites

Introductory level Power BI skills that can be obtained by watching our Introduction to Power BI course.

System Requirements

Windows 10, Windows 7, Windows 8, 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 (http://tinyurl.com/powerbidesktop)

Module 0 - Class Introduction

Module 0

Getting Started

7:55

Module 1 - R Integration

Module 1A

R Integration (Installation and Configuration)

8:26
Module 1B

R Integration (R Scripting Basics)

33:07
Module 1C

R Integration (R for Data Cleansing)

Preview

20:46
Module 1D

R Integration (Check if File Exists)

16:59

Module 2 - M Query

Module 2A

M Query (The M Syntax)

14:18
Module 2B

M Query (#shared)

12:29
Module 2C

M Query (M Query Basics)

16:27
Module 2D

M Query (Variables and Parameters)

24:56
Module 2E

M Query (Expanding Lists)

10:23
Module 2F

M Query (M Query Functions)

13:58

Module 3 - Advanced Data Modeling

Module 3A

Advanced Data Modeling (Filtering)

21:35
Module 3B

Advanced Data Modeling (Cross-Filtering and Time Intelligence)

19:09
Module 3C

Advanced Data Modeling (Many to Many with DAX)

11:02
Module 3D

Advanced Data Modeling (Creating a Bridge Table))

13:43
Module 3E

Advanced Data Modeling (Role Playing Tables with DAX)

22:00
Module 3F

Advanced Data Modeling (Role Playing Tables without DAX)

19:28
Module 3G

Advanced Data Modeling (Mismatched Granularies)

31:22
Module 3H

Advanced Data Modeling (Weighted Allocation)

20:17

Module 4 - Query Folding

Module 4A

Query Folding (Basics)

20:48
Module 4B

Query Folding (Beyond the Basics)

10:02

Module 5 - xVelocity

Module 5A

xVelocity (Overview)

38:20
Module 5B

xVelocity (Vertipaq Analyzer)

18:34
Module 5C

xVelocity (Column Cardinality)

14:20
Module 5D

xVelocity (Calculated Columns)

12:57

Module 6 - Advanced Visualizations

Module 6A

Advanced Visualizations (Digital Storytelling)

13:19
Module 6B

Advanced Visualizations (Bookmarks)

26:11
Module 6C

Advanced Visualizations (Selection Pane)

20:51
Module 6D

Advanced Visualizations (Drillthrough)

8:54
Module 6E

Advanced Visualizations (Visuals with DAX)

11:03
Module 6F

Advanced Visualizations (Custom Visuals)

22:04
Module 6G

Advanced Visualizations (Custom Themes)

12:21

Module 7 - Power BI Administration

Module 7A

Power BI Administration (Data Refresh Overview)

23:01
Module 7B

Power BI Administration (Scheduling Data Refresh)

29:19
Module 7C

Power BI Administration (Implementing Row Level Security)

16:47
Module 7D

Power BI Administration (Implementing Dynamic Security)

14:03

Module 8 - Power BI Embedded

Module 8

Power BI Embedded

18:50

Mitchell Pearson

BI Consultant and Trainer

As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

Related Courses

Course Info

8 Comprehensive Modules
37 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Enrollment Price:	$97.50/Year ~~$195/Year~~
Duration:	11 Hr
Download Syllabus

Free Trial

Share this course with your friends

Shopping Cart 0