Course:

Course Description

This is the second course in TLG Learning’s custom Power BI Desktop training series. What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Power BI Report Users.

Outline

Lesson 1: Getting Started with Power Query

Overview of Power BI Query
Power Query Interface

Lesson 2: Get Data from Data Sources

Identify and Connect to Data Sources
Change data source settings
Storage Modes (Import vs DirectQuery)
Dataverse

Lesson 3: Prepare the Data

Building Master and Source Tables
Query Editor Transformations
Date Tables
Modeling View & Features

Lesson 4: Model Data – Creating a Data Model

DAX Measures
Creating Measures
Best Practices

Lesson 5: DAX Calculated Columns and Measures

Review of Calculated Columns
Power BI Measures
Evaluation Context
Optimize model performance

Lesson 6: Power BI Functions – M Language

Power BI Functions: M Language
Basic M Language Queries
M Language Syntax
Adding Columns

Audience

This course is designed for students who want to take advantage of the cloud service reporting features of Power BI.

Prerequisites

PBICRB: Data Analysis using Power BI Desktop – Level 1 – Report Builder

PBICDMD16: Data Model Design using Power BI Desktop – Level 2