Advanced Power BI

$95.00

What Will You Learn?

  • To build your own dashboards
  • To understand the Power BI ecosystem
  • To extract and model data

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.

Instructor

MANUEL QUINTANA

Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.

What to Know Before the 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.


Duration: 11:00:03
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 that 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.
Advanced Power BI - What you need to get started
Module 00 - Class Introduction
07:55
Module 01A - R Integration (Installation and Configuration)
08:27
Module 01B - R Integration (R Scripting Basics)
33:07
Module 01C - R Integration (R for Data Cleansing)
20:46
Module 01D - R Integration (Check if File Exists)
17:00
Module 02A - M Query (The M Syntax)
14:18
Module 02B - M Query (#shared)
12:29
Module 02C - M Query (M Query Basics)
16:27
Module 02D - M Query (Variables and Parameters)
24:56
Module 02E - M Query (Expanding Lists)
10:23
Module 02F - M Query (M Query Functions)
13:58
Module 03A - Advanced Data Modeling (Filtering)
21:36
Module 03B - Advanced Data Modeling (Cross-Filtering and Time Intelligence)
19:09
Module 03C - Advanced Data Modeling (Many to Many with DAX)
11:03
Module 03D - Advanced Data Modeling (Creating a Bridge Table)
13:43
Module 03E - Advanced Data Modeling (Role Playing Tables with DAX)
22:01
Module 03F - Advanced Data Modeling (Role Playing Tables without DAX)
19:28
Module 03G - Advanced Data Modeling (Mismatched Granularies)
31:22
Module 03H - Advanced Data Modeling (Weighted Allocation)
20:18
Module 04A - Query Folding (Basics)
20:48
Module 04B - Query Folding (Beyond the Basics)
10:03
Module 05A - xVelocity (Overview)
28:20
Module 05B - xVelocity (Vertipaq Analyzer)
18:18
Module 05C - xVelocity (Column Cardinality)
14:21
Module 05D - xVelocity (Calculated Columns)
12:57
Module 06A - Advanced Visualizations (Digital Storytelling)
13:20
Module 06B - Advanced Visualizations (Bookmarks)
26:11
Module 06C - Advanced Visualizations (Selection Pane)
20:52
Module 06D - Advanced Visualizations (Drillthrough)
08:55
Module 06E - Advanced Visualizations (Visuals with DAX)
11:03
Module 06F - Advanced Visualizations (Custom Visuals)
22:05
Module 06G - Advanced Visualizations (Custom Themes)
12:21
Module 07A - Power BI Administration (Data Refresh Overview)
23:01
Module 07B - Power BI Administration (Scheduling Data Refresh)
29:20
Module 07C - Power BI Administration (Implementing Row Level Security)
16:47
Module 07D - Power BI Administration (Implementing Dynamic Security)
14:04
Module 08 - Power BI Embedded
18:51
Class Survey

 

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