Course length 1 day

This powerful collection of software, apps, and services will help you analyze your organization’s data and uncover insights and trends. This course will show you how to link and model data in Power BI and create visual reports that reveal data insights. Although the Power BI desktop client will be the primary focus, an introduction to the Power BI web app will also be provided.


Excel Level 1

Excel Level 2

Excel Level 3

Course Outline

Lesson 1: Getting Started

  • Topic A: An Introduction to Power BI
  • Topic B: Working with Power BI Desktop Files
  • Topic C: Connecting to Data Sources with Power BI Desktop
  • Topic D: Creating a Report with Visualizations
  • Topic E: Doing More with Visualizations

Lesson 2: Working with Data

  • Topic A: Transforming and Sanitizing Data
  • Topic B: Using the Query Editor
  • Topic C: Data Modeling
  • Topic D: Managing Relationships

Lesson 3: Working with Reports and Visualizations

  • Topic A: Managing Report Pages
  • Topic B: Changing Report View Options
  • Topic C: Working with Visualizations
  • Topic D: Adding Static Objects to a Report

Lesson 4: A Closer Look at Visualizations

  • Topic A: Matrixes, Tables, and Charts
  • Topic B: Maps
  • Topic C: Cards, Gauges, and KPIs
  • Topic D: Slicers

Lesson 5: Introduction to the Power BI Web App

  • Topic A: Getting Started
  • Topic B: Connecting to Data Sources with the Power BI Web App
  • Topic C: Using Workspaces, Dashboards, and Reports
  • Topic D: Creating Custom Dashboards
  • Topic E: Power BI Web App Features