Building a Scalable Data Warehouse with Data Vault 2.0

Building a Scalable Data Warehouse with Data Vault 2.0
Author :
Publisher : Morgan Kaufmann
Total Pages : 684
Release :
ISBN-10 : 9780128026489
ISBN-13 : 0128026480
Rating : 4/5 (480 Downloads)

Book Synopsis Building a Scalable Data Warehouse with Data Vault 2.0 by : Daniel Linstedt

Download or read book Building a Scalable Data Warehouse with Data Vault 2.0 written by Daniel Linstedt and published by Morgan Kaufmann. This book was released on 2015-09-15 with total page 684 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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


Building a Scalable Data Warehouse with Data Vault 2.0 Related Books

Building a Scalable Data Warehouse with Data Vault 2.0
Language: en
Pages: 684
Authors: Daniel Linstedt
Categories: Computers
Type: BOOK - Published: 2015-09-15 - Publisher: Morgan Kaufmann

GET EBOOK

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 or
An Introduction to Agile Data Engineering Using Data Vault 2. 0
Language: en
Pages: 50
Authors: Kent Graziano
Categories:
Type: BOOK - Published: 2015-11-22 - Publisher:

GET EBOOK

The world of data warehousing is changing. Big Data & Agile are hot topics. But companies still need to collect, report, and analyze their data. Usually this re
Super Charge Your Data Warehouse
Language: en
Pages: 0
Authors: Dan Linstedt
Categories: Data compression (Computer science)
Type: BOOK - Published: 2011-11-11 - Publisher: Createspace Independent Publishing Platform

GET EBOOK

Do You Know If Your Data Warehouse Flexible, Scalable, Secure and Will It Stand The Test Of Time And Avoid Being Part Of The Dreaded "Life Cycle"? The Data Vaul
The Data Vault Guru
Language: en
Pages: 676
Authors: Patrick Cuba
Categories:
Type: BOOK - Published: 2020-10-06 - Publisher:

GET EBOOK

The data vault methodology presents a unique opportunity to model the enterprise data warehouse using the same automation principles applicable in today's softw
Modeling the Agile Data Warehouse with Data Vault
Language: en
Pages: 434
Authors: Hans Hultgren
Categories: Data warehousing
Type: BOOK - Published: 2012-11-16 - Publisher:

GET EBOOK

Data Modeling for Agile Data Warehouse using Data Vault Modeling Approach. Includes Enterprise Data Warehouse Architecture. This is a complete guide to the data