An Introduction to Data Vault

2022

TL; DR

A brief introduction to the Data Vault modelling method.

Session Details

Data Vault Modeling is a database modeling method that is designed to provide long-term historical storage of data coming in from multiple operational systems. It's the flexible layer that sits between source data and a data warehouse. In this session we'll look at what it is, what it looks like, how you might go about building a Data Vault, why you may (or may not) want to and how it can help us improve our data modelling either way.

3 things you'll get out of this session

Barney Lawrence's other proposed sessions for 2026

(Almost) Everything You Wanted To Know About Purview Data Governance - 2026

An Introduction to Window Functions - 2026

DAX Explained Through Dance, Memes and Dad Jokes - 2026

Barney Lawrence's previous sessions

Data Linkage Options: MDM vs Splink (PySpark)

Comparison of various data linkage solutions.

The Metadata Driven Data Warehouse

Tired of writing the same old Insert/Update/Delete statements over and over? Is your pipelines folder overflowing? Need to get your new data warehouse up and running as fast as possible? Metadata (data about data) comes to the rescue and in this session we’ll show you how.

DAX as Dance-Contexts Explained

Dance your way to an understanding row and filter contexts in DAX.