- Introduction
- What is Data Vault
- Explain the use case with traditional star schema
- Problems with traditional data warehouse model
- Raw Vault Vs Business Vault
- Step By Step Data Vault Modeling
- Sample SQL to get report
- How to design a GDPR complaint Data Architecture using Data Vault approach
- Business Data Vault : PIT, Bridge, Reference table
- When To Use Data Vault and When Not To Use Data Vault
- Data Modeling Tools
What you'll learn
- Data Vault Modeling
- Data Modeling
- When to use Data Vault Model
- Problems with traditional OLAP Modeling
- Step By Step Data Vault Model Creation from a Business Case
- How to design a GDPR complaint Data Architecture using Data Vault approach
Description
This is a beginner course for understanding Data Vault Modeling.
This course describes below topics
1) What is Data Vault : Generic Definition,
Data Vault is an agile system of business intelligence built to solve inadequacies in the Data Warehouse. Data Vault is one of the most popular methodologies when it comes to developing and maintaining a Data Warehouse.
2) What is the problem with traditional OLAP modeling i.e star schema : Problems such as scalability, non-agility, GDPR implementation.
3) How to resolve those problems with Data Vault Modeling.
4) Step by step process to create the data vault model.
5) Benefits of Data Vault, Drawbacks of Data Vault.
6) What is GDPR or General Data Protection Regulation?
General Definition GDPR outlines the specific rights that ensure individuals are in control of their personal data, can request a copy of their data at any time, and can ask for it to be deleted. GDPR will also mean individuals have to give consent before organizations can contact them - putting an end to random direct mail and companies selling data on to others.
7) Problems with implementing GDPR compliant data architecture.
8) Designing GDPR compliant data model using the data vault approach.
9) What is Business data Vault. Designing Bridge, PIT and Reference tables
10) When to use Data Vault Modeling and when not to use Data Vault approach.
11) Data Vault Modeling Tools
All the concepts mentioned above are explained in the course with examples.
After completing the course, the learner will be able to design data vault models and will be able to answers the above-mentioned points.
Other Courses
Create a WordPress Website for Your Web Design Business
A beginner's guide to creating a WordPress website without any coding for your web design & SEO business.
Day Trading For Dummies: 1-Hour Beginner Course
Learn About Stocks, Day Trading, Technical Analysis, Risk Management, & More in This Beginner Trading Course!
Azure Basics Part2 (Network , Compute and Load Balancers)
Azure Basics - (How to create a Network , Virtual Machine and Load balancers in Azure )
Mini English Speaking Course - How to Speak English Fluently
Learn How to Speak English Fluently and Build Your Vocabulary Quickly - Learning English Speaking was Never so Easy
About the instructors
- 3.65 Calificación
- 844 Estudiantes
- 1 Cursos
Pritha Chakraborty
Cloud Data Architect at Google
A Data Enthusiast. Worked in both data modeling and data engineering. I take one-to-one online sessions on Data Modeling, Interview Preparation for Data Engineering Roles, Python. I am also a mentor in one leading technical institute. A lifetime learner. Helped many students or professionals to land their dream roles and switch to their dream jobs
Student feedback
Course Rating
Reviews
Right to the point!
Poor and incomplete content. Wouldn't have purchaseed this course.
Can I get the data model provided in atep 6