Data Model Design using Power BI Desktop – Level 2
- Duration
- 1 day
- Starting Price
- From $325.00
This second course in the Power BI Desktop series is designed for Report Builders ready to create custom data models. It covers Power Query for data extraction and transformation, with introductions to the M language and Data Analysis Expressions (DAX).
Course Outline
1 - Understanding Power BI Data Queries
- Overview of Power BI Queries
- Power Query
- Data Sources
2 - Creating and Transforming Data Models
- Understanding a Basic Data Model
- Creating the Initial Data Query
- Converting Raw Data into a Data Model
3 - Data Transformations
- Query Editor Transformations
- Altering the Data
- Creating New Data
- Refreshing Data
4 - Accessing Additional Data Sources
- Using an Access Database
- Creating a Hybrid Data Model
- Working with Data
5 - DAX Calculated Columns and Measures
- Review of Calculated Columns
- Power BI Measures
- Evaluation Context
- Optimize Model Performance
- Date Tables
6 - Introduction to the M Language
- Power BI Functions: M Language
- M Language Syntax
- Adding Columns
Upcoming Sessions
- Nov 16, 2026 Online7:00 AM - 3:00 PM PT$325.00Register →
- Dec 16, 2026 Online7:00 AM - 3:00 PM PT$325.00Schedule TentativeRegister →