Course Overview

This Intermediate Power BI training course builds on the Introduction class, teaching the advanced dashboard skills participants need for building more sophisticated data visualizations. During class, students connect to various data sources, shape, and combine data, work with reports, and create and share more sophisticated dashboards.  Attendees’ own data is eagerly incorporated into the class if available.

Key Learning Areas

  • Navigate the Power BI environment
  • Plan Power BI projects with organization goals in mind
  • Use the Power BI Query Editor for a wide range of operations, including joining multiple data sources
  • Connect to diverse data sources and transform data
  • Develop DAX measures and implement security roles
  • Generate visualizations with Python and R
  • Build more sophisticated Power BI dashboards
  • Work with paginated reports
  • Use Power Automate with visualizations
  • Work with Power BI Apps
  • Integrate Power BI with Office 365

Course Outline

Introduction

Data Modeling Advanced Topics

  • Aggregation & historical reporting
  • Working with RLS
  • Optimizing models

In-Depth Power Query Usage

  • Working with M
  • Importing data from an external site
  • Using functions and parameters

Building Visualizations

  •  Using quick measures
  • Adding parameters for "What If" reporting
  • Advanced slicer techniques
  • Adding interactive functionality
  • Using bookmarks and page navigation

Using More DAX

  • Conditional formatting with DAX
  • Modifying report context with DAX
  • Handling time functions
  • Working with semi-additive measures
  • Using DAX for dynamic reports

Scripting with R & Python in Power BI

  • Introduction to scripting
  • Building a visualization with Python
  • Building a visualization with R
  • Using scripts in Power Query

Paginated Reporting

  • Understanding paginated reports
  • Opening a dataset
  • Creating a data source
  • Building a report
  • Publishing a report

Using Power Automate on Visualizations

  • Review Power Automate
  • Add a widget to a visualization

Working More with the Power BI Service

  • Discuss security options
  • Using Power BI Apps
  • Office 365 integration
  • Custom application integration

Prerequisites

Participants should have attended the Introduction to Power BI class or have equivalent experience.