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. This is a refresh to the preceding versions to take account of changes in the Power BI service.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »

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.

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


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: 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