Course Overview

This Comprehensive Power BI training class teaches how to build and share Power BI reports. Attendees learn how to shape, combine, and organize data from multiple sources to support their reporting needs. Participants learn how to create interactive visualizations, reports, and dashboards for maximum impact. This course then teaches attendees advanced dashboard skills to build more sophisticated data visualizations. Students can take their new skills and immediately apply them to their current projects.  Your team's own data can be incorporated into the class if available.

Key Learning Areas

  • Navigate the Power BI environment
  • Prepare data for building reports
  • Understand data modeling
  • Work with Power Query to shape data
  • Use common DAX functions
  • Build interactive visualizations and reports
  • Design Power BI reports for maximum clarity and impact
  • Generate actionable insights from your data
  • Share reports using the Power BI Service
  • 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

Overview of Power BI

  • Reviewing the Power BI environment and flow
  • Working with data sources
  • Review storage mode options
  • Modifying data source settings
  • Examine the data, model, and report panes
  • Building a visualization
  • Publishing a visualization

Introduction to Data Modeling

  • Review data terminology
  • Understand relationships
  • Unions of data

Using Power Query

  • Introduce Power Query and tour the interface
  • Remove rows and columns
  • Fill data
  • Unpivot data
  • Combining queries
  • Add custom columns

Introduction to DAX

  • Introduction to DAX
  • Understanding context
  • Common functions

Building Basic Visualizations

  • Building a visualization
  • Sorting
  • Filtering
  • Using slicers
  • Creating new columns and measures
  • Using tooltips
  • Grouping data
  • Conditional formatting
  • Creating bookmarks

Using the Power BI Service

  • Publishing reports
  • Understanding Workspaces
  • Building dashboards
  • Sharing dashboards and reports
  • Data alerts and subscriptions
  • Analyze in Excel

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

Who Benefits

Participants can take their new skills and immediately apply them to their current projects.

Prerequisites

No prior experience is presumed.