Modeling Data Warehouse with Data Vault 2.0

Course covers the basics and fundamentals of Data Vault 2.0 along with Agile Methodology and Big Data

4.35 (2889 reviews)
Udemy
platform
English
language
Other
category
Esra Ekiz
instructor
Modeling Data Warehouse with Data Vault 2.0
13,303
students
6 hours
content
Mar 2022
last update
$74.99
regular price

What you will learn

Get understanding about Traditional Data warehouse concepts

Learn fundamentals of the Data Vault modeling approach

Understand principles of Agile Project Management in Data Vault 2.0

Learn Big Data Platforms Integration with Data Vault 2.0

Understand Data Vault architecture and layers

Learn Business and Information Vault

Understand advanced data modeling techniques

Design a Data Vault practical scenario from scratch

Convert 3NF & Dimensional Model to Data Vault

Understand Dimensional model principles in Data Vault

Why take this course?

Data Vault is an innovative modeling technique invented by Dan Linstedt to simplify data integration from multiple sources, offers auditability and design flexibility to cope with data from the heterogeneous information systems which supports most business demands today

It is designed to deliver an Enterprise Data Warehouse while solving many of the drawbacks of the 3NF (Inmon) and Dimensional Modelling(Kimball).

In this course, you will

  • Learn the basics of Data Modelling to become familiar with core concepts

  • Understand the fundamentals of traditional Data Warehouse approaches

  • Learn many of today’s Data Warehousing problems and issues with 3NF or Star Schema

  • Understand how Data Vault addresses these challenges and provide an innovative approach

  • Learn the fundamentals of the Data Vault modeling approach from core concepts to advanced, and from architecture to key benefits

  • Learn how to effectively model Hubs, Links and Satellites

  • Understand DV Modeling constructs in detail

  • Understand the different architectural and modeling layers of DV 2.0

  • Learn Business Vault, Information Vault and significance of Dimensional Layer

  • Understand where to use 3NF, Dimensional Model or Data Vault

  • Understand loading patterns and architecture

  • Learn  how to handle schema and grain changes on the Data Vault model

  • Learn why Agile Methodology is important for scalable Data Warehouses

  • Get familiar with Big Data Terminologies along with Data Vault Methodology

  • It also contains a hands-on case study to get participants familiar with the principles and concepts 

Footnote: Automatically created subtitles are corrected!

Screenshots

Modeling Data Warehouse with Data Vault 2.0 - Screenshot_01Modeling Data Warehouse with Data Vault 2.0 - Screenshot_02Modeling Data Warehouse with Data Vault 2.0 - Screenshot_03Modeling Data Warehouse with Data Vault 2.0 - Screenshot_04

Reviews

Matilda
May 19, 2023
Clear explanation and easy to understand. I have many years experience but I am getting the course to update myself with terminology.
Allen
May 19, 2023
Very informative. Like a refresher course of what I already know. Looking forward to content specific to DV 2.0 DV 2.0 content is very informative, but at some points confusing. An actual practice assignment would really be helpful at this stage.
Taoufik
May 16, 2023
very good lecture gives a overview and benchmark of all approaches of data modeling, and also very good animated and documented. the structural part of the course is very good, strating from basics to the more difficult. I think for a bigenner and intermediate level is good enough to know all about DV2. the spoking languige is very clear.
Mahdi
May 16, 2023
So boring explanation without any real practical scenario I was looking to see some real case examples with 0-100 steps but unfortunately, it only talks about theoric concepts which are really boring and useless. not recommended for those looking to get something and implement in their real case issues
William
May 4, 2023
This course is presented by a non-native English speaker reading from a script and clicking through slides. If this material is new, it will be very difficult to follow. I find myself just reading the captions and getting little value.
Ximena
April 26, 2023
El curso está bien estructurado. Parte de lo básico, explica bien los conceptos de DataVault 2.0 y luego revisa los posibles escenarios y el patrón de modelamiento a utilizar. Es para personas que tienen experiencia modelando y necesiten utilizar o evaluar DataVault 2.0. Requiere conocimientos previos de modelamiento 3FN.
Chandru
April 19, 2023
Data modeling complex strategies like degenerated keys load into satellite tables and how to proceed on the same
Mary
April 19, 2023
The content is good, it is just difficult to understand the instructor due to her accent. I plan to finish the course. It takes more effort.
Alvin
April 18, 2023
Coming from 5yrs of technical data background, this course gave a great overview and ideology of Data Vault 2.0. Note that hands-on tutorial is not provided but it comes with practical example which is sufficient for me to understand its application. Well done!
Yaqi
April 10, 2023
The structure is good, and the existing modeling examples (The 3 examples) are good! However, the audio is not very easy to follow and more hands-on exercises would be appreciated.
Quam
April 2, 2023
I have a book about data vault but it is hard to understand. In this lesson, the instructor summarize clearly data vault concepts. This course help me to understand the data vault of my company. Thank you.
Diego
March 31, 2023
- falta de exercícios hands on - slides sem guia, ou seja, a medida que a instrutora fala, ela não indica em que parte do slide está a informação que ela está comentando, o que dificulta a compreensão da aula, especialmente em slides com muita informação e, também, considerando que o inglês não é a língua nativa da instrutora. Ou seja, para a melhor compreensão da aula, é necessária a utilização dos subtitles. Contudo ou se tenta encontrar a parte do slide que está sendo abordada no momento, ou se lê os subtitles. E isso dificulta o entendimento da aula - Subtitles ficam em cima do slide. Considerando que diversos alunos devem utilizar os subtitles, os slides deveriam conter conteúdo somente até certo ponto, evitando que os subtitles cobrissem conteúdo de aula
Paulius
March 27, 2023
Actually important parts are mentioned just briefly, listening is a pain, I did found mistakes in SQL code, PPT tables.... Just poor quality overall, maybe good to grasp on some concepts, but seems useless for actual work
Michael
March 24, 2023
Touch to understand everything the teacher/moderator is saying. Both due to language differences and her sounding like she's in a well. I have to put on closed captioning so that I can understand what's being said.
Brad
March 13, 2023
I have a hard time understanding how changes over time are implemented in this model. I'm confused by the differences between the calculated hash in the link and the degenerate key in the link table. I assume one is a hash and the other is functioning as an sales line number that repeats for every sale.

Charts

Price

Modeling Data Warehouse with Data Vault 2.0 - Price chart

Rating

Modeling Data Warehouse with Data Vault 2.0 - Ratings chart

Enrollment distribution

Modeling Data Warehouse with Data Vault 2.0 - Distribution chart

Related Topics

Agile
Big Data
Data Warehouse
3655144
udemy ID
11/23/2020
course created date
7/2/2021
course indexed date
Bot
course submited by