Course curriculum
-
1
Course Introduction
05:51- Introduction
- Course Curriculum
- Course Approach
- Course Resources
-
2
Synthetic Keys
16:05- Synthetic Keys Basics
- Load Dimension Tables
- Challenge - Synthetic Key
- Solution - Synthetic Key
- Data Model Viewer
- Test Your Knowledge
-
3
Adding Flat Files
27:52- Load Excel Files
- Challenge - Load Suppliers Table
- Solution - Load Suppliers Table
- Challenge - Qualify Statement
- Solution - Qualify Statement
- Variables
- Challenge - Variables
- Solution - Variables
- Include Files
- Challenge - Include Files
- Solution - Include Files
- Test Your Knowledge
-
4
Dealing with Data Model Challenges - Part I
28:55- Using Record Counters
- Challenge - Record Counters
- Solution - Record Counters
- WHERE Clause
- Resident Load
- WHERE EXISTS Clause
- Challenge - WHERE EXISTS
- Solution - WHERE EXISTS
- Test Your Knowledge
-
5
Master Calendar
17:12- Master Calendar Fundamentals
- FieldValue() Function
- Create a Master Calendar
- Test Your Knowledge
-
6
Mapping Tables
19:02- Mapping Load Fundamentals
- Add Mapping Table
- Challenge - Mapping Tables
- Solution - Mapping Tables
- Challenge - Preceding Load Statement
- Solution - Preceding Load Statement
- Test Your Knowledge
-
7
Data Model optimization
28:18- Joins Deep Dive
- Challenge - Join Tables
- Solution - Join Tables
- Concatenation
- Implicit and Forced Concatenation
- Challenge - Concatenate
- Solution - Concatenate
- Consolidate Fact Tables
- Test Your Kowledge
-
8
Dealing with Data Model Challenges - Part II
37:00- Circular Reference
- Cross Table
- Add Cross Table
- Link Table
- Create a Link Table
- Challenge - Class Function
- Solution - Class Function
- IntervalMatch
- Test Your Knowledge
-
9
QVD Fundamentals
18:35- QVD Fundamentals
- Creating QVD Files
- Optimized QVD Load
- Test Your Knowledge
-
10
Set Analysis
40:31- Set Analysis Fundamentals
- Create a Chart with Set Expression
- Challenge - Set Modifier
- Solution - Set Modifier
- Aggr()
- Challenge - Set Analysis with Aggr()
- Solution - Set Analysis with Aggr()
- FirstSortedValue()
- Challenge - FirstSortedValue()
- Solution - FirstSortedValue()
- Test Your Knowledge