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