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

MS-10989B - Analyzing Data with Power BI

This two-day instructor-led course provides students with the knowledge and skills analyze data with Power BI.

*This course utilizes higher hosting resources for online labs and therefore, post-class access is limited to 30 days.

Click here to print this page »

Prerequisites


This course requires that you meet the following prerequisites:
  • 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.

These prerequisites can be achieved by attending courses
  • 20761A – Querying Data with Transact-SQL
  • 20767A - Implementing a SQL Server Data Warehouse

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 of self-service BI
Microsoft tools for self-service BI

Module 2: Introducing Power BI


Power BI
The Power BI service
Power BI mobile apps

Module 3: Power BI Data


Using Excel as a Power BI data source
Using databases as a Power BI data source
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