TLGPBICDM - Data Model Design using Power BI Desktop - Level 2

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.

Student Testimonials

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


Data Analysis using Power BI Desktop - Level 1 - Report Builder

Detailed Class Syllabus

Lesson 1: Understanding Power BI Data Queries

Overview of Power BI Queries
Power Query
Data Sources

Lesson 2: Creating and Transforming Data Models

Understanding a Basic Data Model
Creating the Initial Data Query
Converting Raw Data into a Data Model

Lesson 3: Data Transformations

Query Editor Transformations
Altering the Data
Creating new Data
Refreshing Data

Lesson 4: Accessing Additional Data Sources

Using an Access database
Creating a Hybrid Data Model
Working with Data

Lesson 5: DAX Calculated Columns and Measures

Review of Calculated Columns
Power BI Measures
Evaluation Context
Optimize Model Performance
Date Tables

Lesson 6: Introduction to the M Language

Power BI Functions: M Language
M Language Syntax
Adding Columns


Storage Modes (Import vs DirectQuery)
Power Query and Query folding