MS 20778: Analyzing Data with Power BI

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. 

Other relevant courses