Building a Scalable Data Warehouse with Data Vault 2.0

Building a Scalable Data Warehouse with Data Vault 2.0 covers everything users need to create a scalable data warehouse from scratch, including a presentation of the Data Vault modeling technique, which provides the foundations to create a technical data warehouse layer. In addition, the book presents tactics on how to create the input layer (the stage layer) and the presentation layer (data mart) of the Data Vault 2.0 standard. Drawing upon years of practical experience and using numerous examples and an easy to understand framework, Dan Listedt and Michael Olschimke discuss tactics on 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, and data quality services (DQS) and master data services (MDS) in the context of the data vault architecture. * Learn from the inventor of the Data Vault Methodology, Dan Linstedt* Provides a complete introduction to data warehousing, applications, and the business context so readers can get-up and running fast * Explains the 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