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.

Click here to print this page »


Before attending this course, students must have:
  • Excellent knowledge of relational databases and reporting.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (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.

Detailed Class Syllabus

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

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: Modelling 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: Developer API

The developer API
Custom visuals

Module 9: Power BI mobile app

The Power BI mobile app
Using the Power BI mobile app
Power BI embedded