Building a Scalable Data Warehouse with Data Vault 2.0 1st Edition

A wonderful Data Vault book! Mr. Dan Linstedt has found an excellent co-author in Michael Olschimke. I read this one cover to cover, and I highly recommend it to Data Vaulters old and new.The fact that this book includes detailed implementation guidance for Data Vault via the Microsoft BI stack should not discourage non-Microsoft industry people from reading it. Here’s why: As Data Vault has matured and evolved as a methodology, no book besides this one has covered the state of the art in a way that combines such narrative clarity and technical depth. Also, Microsoft is a fine BI platform.Moreover, the coverage of DV 2.0 method details, with the transition to MD5 Hash Keys (vs. auto-numbers) is well documented right down to the level of code samples. The ample ETL code samples are also of enormous benefit. With them, an ETL engineer can pretty quickly appreciate how to not only load the Data Vault (pretty easy), but also how to efficiently pull data out of it (harder, admittedly) and load downstream layers with Business Rules and/or fact and dimension tables or views.For a moment, back to the Microsoft-specific implementation sections of this book, it’s exciting to see this content, and it reminds me of when The Kimball Group published “The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset”, in which they so aptly described the implementation of their compelling message for dimensional modeling in the Microsoft BI platform of that time. Soon afterwards, Microsoft teams were running fast with dimensional models, and the rest is history. I hopes that this excellent book will help to create similar traction for Data Vault. When armies of Microsoft implementers are using a given method, it has indeed hit the mainstream.Underneath Data Vault’s time-tested methods for handling real-world data ugliness with, oh yes, enforced referential integrity and without breaking, providing logical interoperability between increasingly disparate source data, and the need for fast, easily parallel loading, lies an elegant, wonderfully simple set of design patterns that revolutionize the speed and flexibility with which enterprises can build and support sustainable data integration in our new world of gigantic, oddly structured Big Data and NOSQL, and the seemingly unquenchable demand for analytic insight.One minor reservation: Although the Microsoft BI Stack is broad and strong, I don't personally regard their Data Quality Services (DQS), to be a particularly useful tool, notwithstanding the interesting implementation coverage it gets in this book. Still, a minor issue, and not directly related to Data Vault architecture anyway.Data solution architects and BI developers who do not understand Data Vault are, in my view, missing out on a compelling architectural choice for agile RDBMS data integration. For readers ready to take it to the next level, especially insofar as you must tolerate the initial discomfort over the proliferation of tables (> 2x your source tables), this book will assuredly take you a long ways down the road, and you will be rewarded, even astonished, at the flexibility and sustainability that Data Vault affords you once it gets into your blood.

This is good book for data vault, I ordered hard copy for this book , but later realized that digital copy would have been better for search.

Finally, a Data Vault book that has everything you need from end-to-end to build a data vault warehouse from the ground up!I've read the Supercharge Your Data Warehouse book from Dan, I've read all of Hans Hultgren's books, I've read and watched DV fundamentals training material, and I never really felt like I fully understood everything end to end. I grasped the big picture and was excited about the possibilities, but working alone after all of that I felt like I still didn't really have the tools I needed to complete a data vault on my own. With this book, I finally do!This book takes you from concepts to implementation, from beginning to end. There are actual screen shots of how to create databases, what indexes to put on your vault tables, how to create an SSIS package, TSQL code, Master Data Services and Data Quality Services examples, there's MDX code, all of it. And it's not just details to get you to a data vault and then leaving you on your own to figure out the info marts, this takes you all the way to putting data in your dimension and fact tables.All in all, this is the most complete Data Vault book that's ever been created and it's a fantastic value for the money. It's like 684 pages. Once I started, it was literally 8 hours a day for 4-5 days of plowing through all the information and going back and re-reading and getting more details out of it before I was done. It's not a book you can just flip through in a couple of hours. I HIGHLY recommend this book for anyone interested in data vault or data warehousing in general.

Absolutely love it!(Bold & Underline) A MUST MUST READ FOR ALL DATA ARCHITECTS.Can't ask for more, this book has everything. By far the best book I have ever purchased and a MUST MUST READ FOR ALL PEOPLE who works in Data warehouse (DWH) Projects. We are currently building a highly scalable DWH using these modelling techniques, and reaping amazing results. It is repeatable, pattern oriented development of a DWH, and very AGILE to the business changes.What I really liked about this book is "It is a comprehensive implementation book using Microsoft BI tools - DV 2.0".I have to thank both the Authors for sharing their invaluable experience about DV 2.0 for just less than $100. Thanks you very much!With Gratitude,Chandru.Twitter - @vchandm23