Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Transformations & Modeling
Introduction
How to get certified for this course?
Course resources - demo data, demo models, date table code
My best practice tips for the query editor & data model (6:03)
Why you always need to use the query editor (4:53)
What's possible with the query editor (8:28)
How to bring in data to the query editor (7:07)
Tips and techniques to work through in the query editor (8:14)
Understanding M code (10:47)
How to fix things if they fall over in here (8:19)
How to organize the query editor well (4:11)
Review Questions
Review Question Feedback
Data transformation examples
Column transformations (9:02)
Row transformations (6:53)
Filtering tables for unrequired data (4:18)
Creating and modifying a date table (7:35)
Advanced transformation and querying techniques
Staging queries (5:28)
Referencing & duplicating queries (5:27)
Appending queries (5:21)
Merging or joining your queries (8:48)
Unpivoting your tables (9:06)
Columns from examples (5:49)
Custom & conditional columns (8:42)
Creating & using parameters (8:33)
Custom functions (10:13)
Bringing advanced transformations together (5:24)
Review Questions
Review Question Feedback
Designing advanced data models
What are we trying to achieve with the data model? (3:36)
Best practice tips for setting up the data model (5:47)
Setting up complex models (11:25)
What to do if you don't have a lookup table (7:48)
Measure tables / groups (7:27)
Intermediary tables (8:40)
Supporting tables (9:13)
Scenario tables ('what if' parameters) (3:44)
Adding dimensions to lookup tables (7:14)
Multi layered models (4:18)
Advanced modeling concepts
Active vs inactive relationships (7:24)
Optimising your models
How you can improve your models (4:52)
How to reduce the file size of your models (6:36)
Review Questions
Review Question Feedback
Your Feedback
Course Survey
Certification
Certificate & Badge
Scenario tables ('what if' parameters)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock