1. Introduction
  3. Core Concepts
  4. Dimension
  5. Fact
  6. Grain
  7. Star Schema
  8. Keys (surrogate, natural, foreign)
  10. Transformations
  11. Prepare / standardise
  12. Join
  13. Union
  14. Keys & Unknown member
  16. Patterns & Edge Cases
  17. Unknown member
  18. Late-arriving members
  19. Degenerate dimensions
  20. Outrigger
  21. Resolution engines (map_)
  22. Composite keys
  23. Views for business (vw_)
  25. Conventions
  26. Slowly Changing Dimensions (SCD)
  27. Naming (sk, code, number, is, vw, map)
  28. Key strategy (hash hybrid, surrogate keys)
  30. Reference
  31. Dimensions catalogue
    ❱
    1. Standard Cost
    2. Sales Territory
  32. Facts catalogue
    ❱
    1. Invoice Lines
  34. Glossary
  35. SCD, grain, degenerate dim, conformed dim, etc.