Building a Scalable Data Warehouse with Data Vault 2.0

by Dan Linstedt, Michael Olschimke

The Data Vault was invented by Dan Linstedt at the U.S. Department of Defense, and the standard has been successfully applied to data warehousing projects at organizations of different sizes, from small to large-size corporations. Due to its simplified design, which is adapted from nature, the Data Vault 2.0 standard helps prevent typical data warehousing failures.

"Building a Scalable Data Warehouse" covers everything one needs to know to create a scalable data warehouse end to end, including a presentation of the Data Vault modeling technique, which provides the foundations to create a technical data warehouse layer. The book discusses how to build the data warehouse incrementally using the agile Data Vault 2.0 methodology. In addition, readers will learn how to create the input layer (the stage layer) and the presentation layer (data mart) of the Data Vault 2.0 architecture including implementation best practices. Drawing upon years of practical experience and using numerous examples and an easy to understand framework, Dan Linstedt and Michael Olschimke



How to load each layer using SQL Server Integration Services (SSIS), including automation of the Data Vault loading processes.

Important data warehouse technologies and practices.

Data Quality Services (DQS) and Master Data Services (MDS) in the context of the Data Vault architecture. Provides a complete introduction to data warehousing, applications, and the business context so readers can get-up and running fast Explains theoretical concepts and provides hands-on instruction on how to build and implement a data warehouse Demystifies data vault modeling with beginning, intermediate, and advanced techniques Discusses the advantages of the data vault approach over other techniques, also including the latest updates to Data Vault 2.0 and multiple improvements to Data Vault 1.0

Genres: Nonfiction

664 pages, Kindle Edition

First published October 2, 2015

Reviews

[Bjoern · Rating 3 out of 5]

A solid technical idea wrapped with a thick layer of business bullshit bla that hides lots of the actually interesting concepts. The examples can help to bring the learnings to action, however it’s not a „fun read“ but rather a lengthy write-up of the DataVault model which could have probably been covered on half the number of pages.

[Zsombor Zsuffa · Rating 5 out of 5]

Very useful book for learning about Data Vault 2.0. It is much improved in comparison to the Data Vault 1.0 book.

The practical examples with SSIS help a lot in implementing the concepts even if you are a very experienced SSIS developer.

[Francesco Puppini · Rating 5 out of 5]

In a world that scales, you need a system that scales. Data Vault 2.0 is innovative, visionary, and robust. Highly recommended.

[Emanuel · Rating 5 out of 5]

Good entry point on Data Vault

Enjoyed:
- touches all data vault entities+ddl+loading.

NOK
- bit outdated in some aspects as of 2022 where Data Vault practice changed some recommendations.
- I didn't appreciated the fact all examples using sql servers with screenshots of sql server or analysis server. I think a reference semantic book should had been agnostic of specific technology.

[Anil · Rating 4 out of 5]

This book is simple.
It covers the basics of the data vault modeling like hubs, satelites etc.
1) How to load them
2) Data Quality issues etc.

[Lolo · Rating 4 out of 5]

Great ideas and practical examples. The chapters on project management and scrum don’t match the quality of the rest of the book. Overall a must read for data warehouse architects.