Power BI for End Users – Part 2

Power BI for End Users – Part 2

Duration: 1 Day

About: This 1-day course will build on the knowledge from Power BI for End Users – Part 1. Students will learn that to enhance results by integrating disparate data sources and add simple calculations using DAX functions and queries. Participants will create visualizations and incorporate them into dashboards that can provide up to the minute reporting.

Prerequisites:  Power BI for End Users – Part 1

Using the Query Editor

  • Opening the Query Editor
  • The Query Editor Interface
  • Using the Query Settings Pane
  • Using Merge Queries
  • Using Append Queries

Working with Data - Transforming and Sanitizing Data

  • Using Data View
  • Cleaning Irregularly Formatted Data
  • Managing Columns
  • Sorting Table Data

Data Modeling

  • What is DAX?
  • Creating a New Table
  • Creating a New Calculated Column
  • Creating a New Measure

Managing Relationships

  • Using the Relationships View
  • Creating Relationships
  • Editing Relationships
  • Deleting Relationships
  • Using the Manage Relationships Dialog

Matrixes, Tables, and Charts

  • Creating a Table
  • Creating a Matrix
  • Overview of Chart Types
  • Creating Charts

Slicers

  • Creating a Slicer
  • Using Slicers
  • Customizing Slicer Display
  • Changing Slicer Mode
  • Changing Slicer Orientation

Introduction to the Power BI Web App - Getting Started

  • Opening the Power BI Web App
  • The Web App Interface
  • Web App Building Blocks
  • Key Differences

Using App Workspaces, Dashboards, and Reports

  • Viewing and Managing Power BI Content
  • Viewing a Workspace
  • Viewing Dashboards and Reports
  • Managing Reports

Creating Custom Dashboards

  • Creating a Dashboard
  • Pinning Visualizations to a Dashboard
  • Adding Custom Tiles
  • Managing Dashboards

Power BI Web App Features

  • Using Insights
X