Course Overview

This Introduction to 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. They learn how to create interactive visualizations, reports, and dashboards for maximum impact. Participants can take their new skills and immediately apply them to their current projects.

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

Course Outline

Overview of Power BI

  • Reviewing the Power BI environment & 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


No prior experience is required.