Modeling Data Warehouse with Data Vault 2.0

Description

In this course, you will :

• Understand the fundamentals of traditional data warehouse concepts.
• Learn the fundamentals of Data Vault modelling.
• Learn the fundamentals of Agile Project Management in Data Vault. 2.0
• Integrating Big Data Platforms with Data Vault 2.0
• Understand the architecture and layers of the Data Vault.
• Learn about Business and the Information Vault.
• Recognize advanced data modelling techniques.
• Create a Data Vault practical scenario from the ground up.
• 3NF and Dimensional Model to Data Vault conversion
• In Data Vault, comprehend the dimensions model principles.

Syllabus :

1. Traditional Modeling Concepts

• Entity Relationship Diagram
• Conceptual & Logical & Physical Model
• What is OLTP, What is Data Warehouse?
• Database Normalisation, 1NF & 2NF 3NF
• DWH Design Approaches “Top Down & Bottom up"
• Dimensional Modeling
• Star Schema & Snowflake Schema
• Slowly Changing Dimensions
• Conformed Dimensions
• Project 1: Convert ER Diagram to 3NF and 3NF to Dimensional Model

 

2. Data Vault Basics

• What is Data Vault
• Data Vault Basics
• Modeling Steps of Data Vault
• How to split source records to target DV tables

 

3. Link Detail

• Non-Historized (Transactional) Link
• Alternative Method to Model Transactions
• Link to Link Denormalization
• Flexibility and Granularity of Link
• Same-As Link
• Hierarchical Link
• Exploration Link

 

4. Satellite Detail

• Load End Date
• Multi active Satellite
• Status Tracking Satellite
• Record Tracking Satellite
• Effectivity Satellite & Driving Key

 

5. Data Vault Architecture

• Data Vault Layers

 

6. Business Vault

• Point in Time Table
• Bridge Table
• Reference Table

 

7. Information Vault

• Dimensional Model in Data Vault
• Type-1 Dimension with Single Satellite
• Type-1 Dimension with Multiple Satellite
• Type-2 Dimension with Single Satellite
• Type-2 Dimension with Multiple Satellite
• Fact Table

 

8. 3NF & Dimensional Model & Data Vault

• 3NF & Dimensional Model & Data Vault
• Project 2: Convert 3NF to Data Vault
• Project 3: Convert Dimensional Model to Data Vault

 

9. Data Loading Architecture

• Data Load Terminologies
• Loading Data Vault Tables

 

10. Big Data Integration & Agile Methodology

• Agile Methodology
• Introduction to Big Data
• Big Data & Data Vault Integration
• Reference Documents

Show more