Course Outline


  • The shortcomings of existing data warehouse data modeling architectures
  • Benefits of Data Vault modeling

Overview of Data Vault architecture and design principles

  • SEI / CMM / Compliance

Data Vault applications

  • Dynamic Data Warehousing
  • Exploration Warehousing
  • In-Database Data Mining
  • Rapid Linking of External Information

Data Vault components

  • Hubs, Links, Satellites

Building a Data Vault

Modeling Hubs, Links and Satellites

Data Vault reference rules

How components interact with each other

Modeling and populating a Data Vault

Converting 3NF OLTP to a Data Vault Enterprise Data Warehouse (EDW)

Understanding load dates, end-dates, and join operations

Business keys, relationships, link tables and join techniques

Query techniques

Load processing and query processing

Overview of Matrix Methodology

Getting data into data entities

Loading Hub Entities

Loading Link Entities

Loading Satellites

Using SEI/CMM Level 5 templates to obtain repeatable, reliable, and quantifiable results

Developing a consistent and repeatable ETL (Extract, Transform, Load) process

Building and deploying highly scalable and repeatable warehouses

Closing remarks


  • An understanding of data warehousing concepts
  • An understanding of database and data modeling concepts


  • Data modelers
  • Data warehousing specialist
  • Business Intelligence specialists
  • Data engineers
  • Database administrators
 28 Hours

Number of participants

Price per participant

Testimonials (1)

Related Courses

Knowledge Discovery in Databases (KDD)

21 Hours

Cluster Analysis with R and SAS

14 Hours

From Data to Decision with Big Data and Predictive Analytics

21 Hours

Data Mining and Analysis

28 Hours

Data Mining

21 Hours

Data Mining with Python

14 Hours

Data Mining with R

14 Hours

Data Visualization

28 Hours

Data Mining with Excel

14 Hours

Data Mining with Weka

14 Hours

Data Mining & Machine Learning with R

14 Hours

Data Science for Big Data Analytics

35 Hours

Foundation R

7 Hours

KNIME Analytics Platform for BI

21 Hours

Platforma analityczna KNIME - szkolenie kompleksowe

35 Hours

Related Categories