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