Building a Scalable Data Warehouse with Data Vault 2.0 - Softcover

Linstedt, Daniel; Olschimke, Michael

Softcover

ISBN 10: 0128025107 ISBN 13: 9780128025109

Publisher: Morgan Kaufmann, 2015

Synopsis

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 discuss:

• 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

About this title

Review

This book 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, also including tactics on how to create the inner and presentation layer of the data vault 2.0 standard.

About the Author

Dan has more than 25 years of experience in the Data Warehousing and Business Intelligence field and is internationally known for inventing the Data Vault 1.0 model and the Data Vault 2.0 System of Business Intelligence. He helps business and government organizations around the world to achieve BI excellence by applying his proven knowledge in Big Data, unstructured information management, agile methodologies and product development. He has held training classes and presented at TDWI, Teradata Partners, DAMA, Informatica, Oracle user groups and Data Modeling Zone conference. He has a background in SEI/CMMI Level 5, and has contributed architecture efforts to petabyte scale data warehouses and offers high quality on-line training and consulting services for Data Vault.

Edition details

• Publisher: Morgan Kaufmann
• Publication date: 2015
• ISBN 10: 0128025107
• ISBN 13: 9780128025109
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 688