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 LinstedtProvides 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 warehouseDemystifies Data Vault Modeling with beginning, intermediate, and advanced techniquesDiscusses 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 INDICE: Chapter 1: Introduction to Data WarehousingChapter 2: Scalable Data Warehouse ArchitectureChapter 3: Agile Data Warehouse Development MethodologyChapter 4: The Data Vault 2.0 MethodologyChapter 5: Data Vault ModelingChapter 6: Intermediate Data Vault ModelingChapter 7: Advanced Data Vault ModelingChapter 8: Dimensional ModelingChapter 9: Physical Database DesignChapter 10: Master Data ManagementChapter 11: Metadata ManagementChapter 12: Data ExtractionChapter 13: Loading the Data VaultChapter 14: Implementing Data Quality in the Data VaultChapter 15: Loading the Dimensional Data MartChapter 16: Relational Reports (Optional)Chapter 17: Multidimensional DatabaseChapter 18: Refactoring the Data WarehouseChapter 19: Data Mining (Optional)Chapter 20: Data Warehouse Administration (Optional)Chapter 21: Best Practices (Optional)

• ISBN: 978-0-12-802510-9
• Editorial: Morgan Kaufmann
• Encuadernacion: Rústica
• Páginas: 640
• Fecha Publicación: 01/10/2015
• Nº Volúmenes: 1
• Idioma: Inglés