Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

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 »

Prerequisites

  • 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


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