Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Advanced Data Transformations & Modeling
Introduction
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:29)
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)
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:28)
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:25)
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:53)
How to reduce the file size of your models (6:36)
Your Feedback
Course Survey
Intermediary tables
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock