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.

Intermediate10 chapters· 2h 8m· in Semantic & Metrics Layer

Course content

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