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…

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 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…

ÜBERBLICK Erlernen der Verwendung von Data Vault und Vorbereitung auf die ZertifizierungDiskussion von geschäftlichen Begründungen und technischen Beschreibungen aller Säulen von Data Vault 2.0Auseinandersetzung mit der Architektur, Implementierung, Methodik und den Modellierungskomponenten von Data Vault 2.0Verstehen von ETL-Design-Paradigmen – Templates in konzeptionellen und SQL-FormatenEntwicklung von Best Practices für erfolgreiche Data Vault 2.0-Implementierungen AGENDA COMPUTERGESTÜTZTES TRAINING (vorab), NUR ONLINE Was ist Data Vault 2.0? DV1.0 im Vergleich zu DV2.0 Heutige Probleme Data Vault 2.0 in der Praxis Managed Self-Service BI Agile Delivery und DV2.0-Methodik Agile Erfassung von Anforderungen Technische Nummerierung Rollen und Freigaben Komponenten der Architektur TAG 1 Was ist Data Vault 2.0? Business Vault Information Marts definiert Daten als Asset…

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…

ÜBERBLICK Erlernen der Verwendung von Data Vault und Vorbereitung auf die ZertifizierungDiskussion von geschäftlichen Begründungen und technischen Beschreibungen aller Säulen von Data Vault 2.0Auseinandersetzung mit der Architektur, Implementierung, Methodik und den Modellierungskomponenten von Data Vault 2.0Verstehen von ETL-Design-Paradigmen – Templates in konzeptionellen und SQL-FormatenEntwicklung von Best Practices für erfolgreiche Data Vault 2.0-Implementierungen AGENDA COMPUTERGESTÜTZTES TRAINING (vorab), NUR ONLINE Was ist Data Vault 2.0? DV1.0 im Vergleich zu DV2.0 Heutige Probleme Data Vault 2.0 in der Praxis Managed Self-Service BI Agile Delivery und DV2.0-Methodik Agile Erfassung von Anforderungen Technische Nummerierung Rollen und Freigaben Komponenten der Architektur TAG 1 Was ist Data Vault 2.0? Business Vault Information Marts definiert Daten als Asset…

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…

ÜBERBLICK Erlernen der Verwendung von Data Vault und Vorbereitung auf die ZertifizierungDiskussion von geschäftlichen Begründungen und technischen Beschreibungen aller Säulen von Data Vault 2.0Auseinandersetzung mit der Architektur, Implementierung, Methodik und den Modellierungskomponenten von Data Vault 2.0Verstehen von ETL-Design-Paradigmen – Templates in konzeptionellen und SQL-FormatenEntwicklung von Best Practices für erfolgreiche Data Vault 2.0-Implementierungen AGENDA COMPUTERGESTÜTZTES TRAINING (vorab), NUR ONLINE Was ist Data Vault 2.0? DV1.0 im Vergleich zu DV2.0 Heutige Probleme Data Vault 2.0 in der Praxis Managed Self-Service BI Agile Delivery und DV2.0-Methodik Agile Erfassung von Anforderungen Technische Nummerierung Rollen und Freigaben Komponenten der Architektur TAG 1 Was ist Data Vault 2.0? Business Vault Information Marts definiert Daten als Asset…

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…