The Data Vault Guru: A Pragmatic Guide on Building a Data Vault

Why Write a Book?

There exists plenty of literature on the web about data vault modelling and often the message and methodology are conflicting, designed based on old school principles of data delivery or particular understandings of Agile delivery.

As a data professional with experience in ETL/ELT and data modelling, I felt something was needed to bring both viewpoints of data delivery together, one originating from data automation and the other from data modelling. They are not the same but if a data vault is properly delivered it must be cognizant of both.

Data vaults continue to evolve and communities of data vault modelling practitioners exist around the world. Forums and meetups focus on how data vault modelling has been applied to specific situations and tools. However, the problem with these resources is that attendees often don’t have access to the tools or may never encounter the unique situation. Data vault models are delivered with a partial view of the standards. Although data vault implementations have evolved, the standards remain consistent.

Although the book is a written account of what I consider to be an almost complete implementation of data vault modelling, it has to be said that reading about data vault and getting trained in it does not necessarily mean you know how to deliver a data vault. The book takes a platform-agnostic view and describes the intended delivery and modelling patterns of a…