Build models that answer better questions. In DAX for Data Modeling, you’ll explore how DAX shapes the way your data behaves—through context, relationships, and carefully chosen table expressions. You’ll learn when to use calculated columns vs. Measures, how filter and row context affect results, and where relationship settings (active/inactive, direction, cross-filtering) make or break your analysis. Then we’ll put DAX to work on real modeling tasks. You’ll connect tables with RELATED/RELATEDTABLE, activate the right path with USERELATIONSHIP, refine propagation with CROSSFILTER, and build tidy tables using VALUES, DISTINCT, SUMMARIZE, SELECTCOLUMNS, and FILTER. Along the way, Greg shares practical performance tips so your models stay fast, accurate, and easy to maintain.
Overview
COURSE DIFFICULTY
COURSE DURATION
2h 34m
Skills Learned
After completing this online training course, students will be able to:
Leverage Copilot AI to enhance productivity
Draft and edit documents using Copilot in Word
Apply Copilot across Microsoft 365 applications
Build ETL packages using SQL Server Integration Services
Data Engineers, Business Professionals, Knowledge Workers
None
01. What You Need to Get Started
02. Introduction
03. Drafting and Transforming
04. Copilot Pane Features
05. Extra Use Cases
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Leverage Copilot AI to enhance productivity
Draft and edit documents using Copilot in Word
Apply Copilot across Microsoft 365 applications
Build ETL packages using SQL Server Integration Services
WHO SHOULD ATTEND
Data Engineers, Business Professionals, Knowledge Workers
PREREQUISITES
None
COURSE OUTLINE
01. What You Need to Get Started
02. Introduction
03. Drafting and Transforming
04. Copilot Pane Features
05. Extra Use Cases
