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.

Audience:

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.

Prerequisites:

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

Relationships
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

Certification:

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