Course Overview
Duration : 5 Days
This two-day instructor-led course provides students with the knowledge and skills analyze data with Power BI.
Who Should Attend
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.
Course Certifications
This course is part of the following Certifications:
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
Course Objectives
After completing this course, students will be able to:
Describe key features of a self-service BI solution
Describe Power BI and its data sources
Model, shape, and combine data
Describe Power BI data visualizations
Course Content
Module 1 : Introduction to Self-Service BI Solutions
In this module students will be introduced to the key cocepts in business intelligence, data anlaysis, and data virtualization. In additon they will learn the rationale for self-service BI, considerations for using self-service BI , considerations for using self-service BI , and how Microsoft products can be used to implement a self-service BI solution.
Lessons
Introduction to busines intelligence
Introduction to data analysis
Introduction to data virtualization
Overiview of aelf-service BI
Considerations of self-service BI
Microsoft tools for self-service BI
Lab : Exploring an enterprise BI solution
After completing this module , you will be able to :
Describe key concepts in business intelligence
Describe key concepts in data analysis
Describe key concepts in data virtualization
Describe the rationale for self-service BI
Describe considerations for self-service BI
Describe how Microsoft products can be used to implement a self-service BI solution
Module 2 : Introducing Power BI
This module introduces Power BI.
Lessons
Power BI
The Power BI service
Power BI mobile apps
Lab : Cresting a Power BI dashboard
After completing this module , you will be able to :
Describe Power BI
Describe the Power BI Service
Implement Tenant Management
Describe Power BI mobile apps
Create a simple dashboard
Module 3: Power BI Data
This module describes Power BII data sources
Lessons
Using Excel as a Power BI data source
Using database as a Power BI data source
The power BI service
Lab : Import data into Power BI
After completing this module, you will be able to :
Use excel as a Power BI source
Use databases as a Power BI data source and describe the R language
Configure the Power BI Service
Module 4 : Shaping and Combining Data
This module describe how to shape and combine data
Lessons
Power BI desktop queries
Shaping data
Combining data
Lab : Shaping and combining data
After completing this module , you will be able to :
Create Power BI desktop queries
Shape data
Combine data
Module 5 : Modelling Data
This module describes how to model data in Power BI
Lessons
Relationships
DAX queries
Calculations and measures
Lab : Modelling data
After completing this module , you will be able to :
Configure the Power BI Service
Create Relationships
Write simple DAX queries
Create calculations and measures
Module 6 : Interactive Data Virtualizations
This module describes Power BI visualizations
Lessons
Creating Power BI reports
Managing a Power BI solution
Lab : Creating a Power BI report
After completing this module , you will be able to :
Use Power BI Desktop to create interactive data visualizations
Describe the management of a Power BI solution