OVERVIEW This class is a 2-day intensive course. This class continues where the CDVP2 Boot Camp stops – the use of the Data Vault 2.0 model to deliver information. It discusses how to implement business logic in the Business Vault and how to derive various target models from the enterprise data warehouse, including star schemas, snowflake schemas and fully denormalized information models.  MAJOR TOPICS Common Requirements in Information Delivery Introduction to Data Vault 2.0 Architecture Business Vault Reviewed Agile Delivery of Information Assets PIT and Bridge Tables for Performance Tuning Advanced Business Vault Patterns Information Marts and Target Models Reviewed Introduction to Multi-Temporal Solutions Real-Time Information Delivery Information Delivery in CDC…

OVERVIEW This class is a 2-day intensive course that builds on top of the Data Vault 2.0 Boot Camp. Therefore, the attendance of the Data Vault 2.0 Boot Camp is a requirement for this class. A passed CDVP2 certification is not required but strongly recommended. The objective of this class is to provide attendees the concepts of multi-temporal data warehousing and the foundation to develop such solutions on their own in a Data Vault 2.0-based enterprise data warehouse. To achieve this goal, various timelines and perspectives are discussed before specific patterns for multi-active, real-time and other scenarios are provided.  MAJOR TOPICS Introduction to different timelines Temporality in EDW’s Temporal SQL functions and performance considerations…

OVERVIEW This 1-day introductory class explains Data Vault 2.0 and all its pillars to a general audience. It helps business analysts and managers, involved in an agile data warehouse project based on Data Vault 2.0, to understand the principles and decisions made. This class generally helps to increase management support of Data Vault 2.0 projects by explaining concepts such as managed self-service Business Intelligence, agile delivery of functionality, and agile requirements management. The amount of content in this class is equal to the content covered on the first day of the Boot Camp. AGENDA COMPUTER BASED TRAINING, ON-LINE ONLY What is Data Vault 2.0? DV1.0 Compared to DV2.0 Issues Faced…

OVERVIEW Learning how to use Data Vault and become certified Discussing business justifications and technical descriptions of all pillars of Data Vault 2.0 Exploring the architecture, implementation, methodology, and modeling components of Data Vault 2.0 Understanding ETL design paradigms – working templates within conceptual and SQL formats Developing best practices for successful Data Vault 2.0 implementations AGENDA COMPUTER BASED TRAINING, ON-LINE ONLY What is Data Vault 2.0? DV1.0 Compared to DV2.0 Issues Faced Today Data Vault 2.0 In Business Managed Self-Service BI Agile Delivery and DV2.0 Methodology Agile Requirements Gathering Technical Numbering Roles and Releases Architecture Components DAY 1 What is Data Vault 2.0?  Business Vault Information Marts defined Data…

OVERVIEW Learning how to use Data Vault and become certified Discussing business justifications and technical descriptions of all pillars of Data Vault 2.0 Exploring the architecture, implementation, methodology, and modeling components of Data Vault 2.0 Understanding ETL design paradigms – working templates within conceptual and SQL formats Developing best practices for successful Data Vault 2.0 implementations AGENDA COMPUTER BASED TRAINING, ON-LINE ONLY What is Data Vault 2.0? DV1.0 Compared to DV2.0 Issues Faced Today Data Vault 2.0 In Business Managed Self-Service BI Agile Delivery and DV2.0 Methodology Agile Requirements Gathering Technical Numbering Roles and Releases Architecture Components DAY 1 What is Data Vault 2.0?  Business Vault Information Marts defined Data…

OVERVIEW Learning how to use Data Vault and become certified Discussing business justifications and technical descriptions of all pillars of Data Vault 2.0 Exploring the architecture, implementation, methodology, and modeling components of Data Vault 2.0 Understanding ETL design paradigms – working templates within conceptual and SQL formats Developing best practices for successful Data Vault 2.0 implementations AGENDA COMPUTER BASED TRAINING, ON-LINE ONLY What is Data Vault 2.0? DV1.0 Compared to DV2.0 Issues Faced Today Data Vault 2.0 In Business Managed Self-Service BI Agile Delivery and DV2.0 Methodology Agile Requirements Gathering Technical Numbering Roles and Releases Architecture Components DAY 1 What is Data Vault 2.0?  Business Vault Information Marts defined Data…