Yearly Subscription

Power BI Master Class (PBIMC)

Published: June 2020

Power BI Master Class is an intensive, hands-on training class designed for people who already have hands-on experience with Power BI Desktop and the Power BI Service and are ready to move their Power BI builder skills to the next level. Students will learn best practices for extracting data using advanced queries and dataflows, building data models with DAX and creating visualizations using reports ad dashboards. This course has also been designed to prepare student to pass Microsoft Certification Exam DA-100: Analyzing Data with Microsoft Power BI.

All the essential Power BI concepts and techniques discussed in lectures are reinforced through hands-on lab exercises in which students will move through the actual steps required to build dataflows as well as data models that are deployed as shared datasets. Students will also learn how to design interactive reports using slicers, bookmarks and drillthrough pages. The course discusses essential differences between reports and dashboards and also examines the strengths and weaknesses between imported datasets and DirectQuery datasets.

This course discusses distributing Power BI content and administrating the Power BI environment at the tenant-level. Students will learn when and how to install an on-premises data gateway to provide connectivity to on-premises data sources such as SQL Server. The course demonstrates how to configure tenant-level settings for Power BI and how to monitor report and dashboard usage within an organization using Power BI audit logs. Along the way, students will learn how to configure row-level security (RLS) and how to leverage the R data analytics platform to extend a Power BI Desktop project using R script visuals.
  • Module 01: Designing Advanced Queries with Power BI Desktop
  • Course Introduction
  • Importing Data using Power Query
  • Writing Query Logic in M
  • Understanding Query Folding
  • Writing Reusable Query Functions
  • Advanced Query Pop Quiz
  • Module 02: Extracting and Preparing Data using Dataflows
  • Understanding Dataflow Architecture
  • Creating and Consuming Dataflows
  • Creating a Star Schema
  • Importing and Exporting Dataflows
  • Using Premium Dataflow Features
  • Module 03: Designing a Data Model with Power BI Desktop
  • Creating Table Relationship
  • Creating Calculated Columns and Measures
  • Creating Tables using DAX Expressions
  • Configuring Fields for Geographic Mapping
  • Module 04: Writing Advanced DAX Expressions
  • Creating Dimensional Hierarchies
  • Understanding Evaluation Context and Calculate
  • Creating a Calendar Table
  • Calling DAX Time Intelligence Functions
  • Writing Contextually-aware DAX Expressions
  • Calculating the Top 5 Products
  • Module 05: Publishing and Managing Datasets
  • Comparing Imported Datasets to DirectQuery
  • Managing Dataset Refresh
  • Installing and Configuring an On-premises Gateway
  • Designing Datasets using DirectQuery Mode
  • Module 06: Designing Interactive Reports with Power BI Desktop
  • Working with the Report Designer
  • Designing Interactive Reports using Slicers
  • Using Conditional Formatting
  • Designing Reports using Bookmarks
  • Importing Custom Visuals
  • Using Custom Report Themes
  • Publishing Power BI Reports
  • Creating Reports from Shared Datasets
  • Module 07: Designing Dashboards in the Power BI Service
  • Designing Dashboards for Power BI
  • Executing Queries with Natural Language Q&A
  • Sharing Dashboards
  • Building Real-time Dashboards
  • Module 08: Distributing Content using App Workspaces
  • Content Distribution in Power BI
  • App Workspaces
  • Publishing Apps
  • Power BI Premium
  • Module 09: Administrating and Configuring Security in Power BI
  • User Authentication and Identity
  • Power BI Tenant Administration
  • Data Security
  • Row Level Security
  • Dynamic Row Level Security
  • Module 10: Introduction to R with Power BI
  • Understanding R as a Data Analytics Platform
  • Install Microsoft R Open and RStudio
  • Writing R Code in RStudio
  • Integrating R with Power BI Desktop
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: Forever