Data Vault 2.0

The audit-first, source-volatile-first alternative to Kimball. Hubs, links, satellites, hash keys, and PIT tables — and the honest discussion of when Vault is the right tool versus when it's cosplay.

The audit-first, source-volatile-first alternative to Kimball. Hubs, links, satellites, hash keys, and PIT tables — and the honest discussion of when Vault is the right tool versus when it's cosplay.

Intermediate11 chapters· 2h 16m· in Semantic & Metrics Layer

Course content

  1. 01Lab SetupFree
  2. 02Why Data Vault ExistsFree
  3. 03Hubs — The Business-Key Layer🔒
  4. 04Links — Many-to-Many, Always🔒
  5. 05Satellites — Attributes with History Built In🔒
  6. 06Hash Keys and Hash Diffs🔒
  7. 07Raw Vault vs Business Vault🔒
  8. 08Point-in-Time (PIT) Tables🔒
  9. 09Bridge Tables and Same-As Links🔒
  10. 10Loading Patterns — Insert-Only Everything🔒
  11. 11When NOT to Use Data Vault🔒

Prerequisites

What to learn next

Read the first chapter free

Start reading now — no account required for the free chapters.