Data Model Design using Power BI Desktop – Level 2 Virtual Classroom Live May 20, 2026

Price: $600

This course runs for a duration of 1 Day.

The class will run daily from 7 AM PT to 3 PM PT.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

This is the second course in this 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

Course Overview

Lesson 1: Understanding BI Data

Understanding the Process
Understanding BI Data Sources
Table Roles

Lesson 2: Creating Data Models

Analyzing the Data Source
Creating New Tables
Creating Relationships

Lesson 3: Customizing Data Models

Additional Transformations
Editing Applied Steps
Merging, Appending, Unpivoting Data
Transformations in Table View
Using the Options Dialog Box

Lesson 4: Accessing Additional Data Sources

Using Relational Databases
Creating a Composite Data Model
Creating a Data Model from Cloud Sources
Storage Modes (ImportQuery vs. DirectQuery)
Query Folding
Performance Analyzer

Lesson 5: Power BI Functions – Intro to DAX

Calculated Columns
DAX Measures
Working with Date Tables

Lesson 6: M Language

Getting Started with M Language
Basic M Language Queries
Adding, Duplicating & Splitting Columns
The “Last Refresh” Indicator

Prerequisites

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

Other Available Dates for this Course

Virtual Classroom Live
April 10, 2026

$600.00

Featured Class 1 Day 7 AM PT - 3 PM PT

Virtual Classroom Live
June 24, 2026

$600.00

Featured Class 1 Day 7 AM PT - 3 PM PT

Virtual Classroom Live
July 29, 2026

$600.00

1 Day 7 AM PT - 3 PM PT

Virtual Classroom Live
September 02, 2026

$600.00

1 Day 7 AM PT - 3 PM PT

Knowledge Transfer Consulting Services Inc. is a single-source solution provider offering a full range of Training Delivery and Training Management solutions from concept to delivery. Learn more

Data Model Design using Power BI Desktop – Level 2 Virtual Classroom Live May 20, 2026

Price: $600

Enroll today to reserve your spot!

Description

Course Overview

Prerequisites

Other Available Dates for this Course

Find a Course

Corporate Services

Contact us