Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
Advanced Data Modelling & DAX
Course Content
Expand All
Introduction to Data Modelling with Power BI
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Review of the Four Stages of Self-Service BI
Introduction to Data Modelling
Thinking of Data in Tables
Review of Adventure Works Sample Database
Summary – Intro to Data Modelling with Power BI
Power BI Data Model
8 Lessons
Expand
Module Content
0% Complete
0/8 Steps
Loading Data
Two Types of Power BI Tables
Relationships in Power BI
Data Compression
Default Aggregations, Custom Themes, Summary
Planning Your Data Model
Best Practices and Tips
Summary – Power BI Data Model
Writing DAX Formulas
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
Measures
Calculated Columns
DAX Functions
Why to write DAX Formulas
Practice Exercises 1
Answers to Practice Exercises 1
Summary – Writing DAX Formulas
The CALCULATE Function Explained
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
The CALCULATE Function
Debugging Your DAX Formulas – 6 Step Process
Filter Behaviour Revisited
Summary – Calculate Function
Leveraging the CALCULATE Function
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
The ALL Function
Alternatives in Using ALL Function
Practice Exercises 2
Answers to Practice Exercises 2
Summary – Leveraging the CALCULATE Function
Time Intelligence
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Introduction to Time Intelligence
Auto Time Intelligence
Running Totals
Change vs Prior Year/Month
Summary – Time Intelligence
The FILTER Function Explained
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
The FILTER Function
Filter Function is like a Calculated Column
FILTER Function Pattern to get Business Insights
Summary – Filter Function
Multiple Data Tables
2 Lessons
Expand
Module Content
0% Complete
0/2 Steps
Loading and Connecting a Second Data Table
Measures to Derive Business Insights from 2 Data Tables
Simple Transformations
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Cleansing Data