MS 20778: Analyzing Data with Power BI


Important! This course is replaced by course DA-100

Course MS-20778 is now replaced by a new updated course from October 2020:

DA-100: Analyzing Data with Power BI

Exam 70-778 will retire 31 January 2021









The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.


The primary audience for this course is BI professionals who need to analyze data utilizing Power BI. The secondary audiences for this course are technically proficient business users.


In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming concepts (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.

Course goals:

After completing this course, students will be able to:

  • Describe self-service BI.
  • Describe the Power BI suite of products.
  • Connect to data sources and optimize data models.
  • Shape and combine data from different sources.
  • Model data.
  • Create reports and manage solutions.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.

Course outline

Module 1: Introduction to Self-Service BI Solutions

Introduction to Business Intelligence
Introduction to Data Analysis
Introduction to Data Visualization
Overview of Self-Service BI
Considerations for Self-Service BI
Microsoft Tools for Self-Service BI

Module 2: Introducing Power BI

Power BI
The Power BI Service

Module 3: Power BI Data

Using Excel as a Data Source for Power BI
The Power BI Data Model
Using Databases as a Data Source for Power BI
The Power BI Service

Module 4: Shaping and Combining Data

Power BI Desktop Queries
Shaping Data
Combining Data

Module 5: Modeling Data

DAX Queries
Calculations and Measures

Module 6: Interactive Data Visualizations

Creating Power BI Reports
Managing a Power BI Solution

Module 7: Direct Connectivity

Cloud Data
Connecting to Analysis Services

Module 8: Development with Power BI

The Power BI API
Custom Visuals

Module 9: Power BI Mobile

Power BI Mobile Apps
Using the Power BI Mobile App

Read the official course desciption:
MS 20778: Analyzing Data with Power BI


This course is recommended as preparation for exam 70-778 which is the first of two exams leading to MCSA BI Reporting certification.