Microsoft Power BI for Power Users

This course is designed for everyone.

After completing this course, students will be able to

• Perform Power BI desktop data transformation.

• Describe Power BI desktop modelling.

• Create a Power BI desktop visualization.

• Implement the Power BI service.

• Describe how to connect to Excel data.

• Describe how to collaborate with Power BI data.

Module 1: Introducing Power BI

• The Microsoft Self-Service Business Intelligence Solution

• The Power BI Universe

• Installing Power BI Desktop

• A First Power BI Desktop Dashboard

Lab: Creating a Power BI dashboard using Power BI Desktop

• Connecting to Power BI data

• Create a Power BI dashboard

Module 2: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, buil-in tools. This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.

Lessons

• Introduce Power Query Editor

• Shaping data

• Combining data

Lab : Shaping and combining data

• Shape power BI data

o Detecting data type

o Rename columns

o Remove unnecessary rows, columns

o Use first rows as headers

o Extracting columns

o Unpivot columns

• Combine Power BI data

o Appending

Module 3: Modeling data

This module describes how to shape and enhance data.

Lessons

• Relationships

• Introduce DAX

• Calculated columns and measures

Lab : Modeling Data

• Create relationships

• Adding calculated columns to data model:

o Joining columns with &

o Basic calculations across table with RELATED()

o Simple Logical: IF(), AND(), OR()

• Create measures:

o Simple aggregations: SUM(), AVERAGE()

o Filter functions: CALCULATE(), ALL(), ALLEXPECT()

o Examine filter context: SELECTEDVALUE()

o Time Intelligence functions:

▪ TOTALYTD(), TOTALQTD(), TOTALMTD()

▪ PREVIOUSYEAR(), SAMEPERIODLASTYEAR()

▪ DATEINSPERIOD()

Module 4: Interactive Data Visualizations

This module describes how to create and manage interactive data visualizations.

Lessons

• Creating Power BI reports

• Formatting visuals

Lab : Creating a Power BI report

• Drill up, drill down

• Creating Popup tooltips

• Creating drill-through

Module 5: Publishing report to Power BI Services

This module describes how to publish & share reports in Power BI Services.

Lab:

• Introduce Power BI Services

• Publish and share reports

• Create a dashboard.