EncartaLabs

Data Vault

( Duration: 5 Days )

Data Vault is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its flexible, scalable, consistent and adaptable design encompasses the best aspects of 3rd normal form (3NF) and star schema. In Data Vault training course, delegates will learn to understand the architecture and design concepts behind Data Vault, and its interaction with Big Data, NoSQL and AI.

By attending Data Vault workshop, delegates will learn to:

  • Use data vaulting techniques to enable auditing, tracing, and inspection of historical data in a data warehouse.
  • Develop a consistent and repeatable ETL (Extract, Transform, Load) process.
  • Build and deploy highly scalable and repeatable warehouses.

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

The Data Vault class is ideal for:

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

COURSE AGENDA

1

Introduction

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

Overview of Data Vault architecture and design principles

  • SEI / CMM / Compliance
3

Data Vault applications

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

Data Vault components

  • Hubs, Links, Satellites
5

Building a Data Vault

6

Modeling Hubs, Links and Satellites

7

Data Vault reference rules

8

How components interact with each other

9

Modeling and populating a Data Vault

10

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

11

Understanding load dates, end-dates, and join operations

12

Business keys, relationships, link tables and join techniques

13

Query techniques

14

Load processing and query processing

15

Overview of Matrix Methodology

16

Getting data into data entities

17

Loading Hub Entities

18

Loading Link Entities

19

Loading Satellites

20

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

21

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

22

Building and deploying highly scalable and repeatable warehouses

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top