Data Vault 2.0 Simplified: Hands-on Guide to Agile DWH

سرفصل های دوره

Master Data Vault 2.0 with Hands-on Practice Sessions

1. Introduction to the course

1. Course Overview

2. Introduction to Data Vault 2.0

1. What is Data Warehouse

2. What is Data Vault

3. Advantages of using Data Vault

4. Disadvantages of using Data Vault

3. Data Vault - Basics

1. Data Vault modeling process and steps

2. Hash Keys and benefits

3. Introduction to Hubs

4. Case Study 1- Identify Hubs

5. Case Study 2- Identify Hubs

6. Introduction to Satellites

7. Case Study 1- Identify Satellites

8. Case Study 2- Identify Satellites

9. Introduction to Links

10. Many to Many relationship

11. Case Study 1- Identify Links

12. Case Study 2- Identify Links

13. Link - Unit of Work

14. An example of Unit of work

15.1 coffee shop - data model image.zip

15.2 coffee shop.zip

15. Coffee Shop Case Study

16. Data Vault 2.0 Basic Quiz.html

4. Data Vault Architecture

1. Typical architecture for Data Vault 2.0

2. Staging Layer

3. Raw Data Vault

4. Business Vault

5. Information Mart

5. Data Vault - Intermediate - Links

1. Link on Link

2. An example of Link on Link

3. Same As Links

4. An example of Same As Links

5. Hierarchical Links

6. An example of Hierarchical Links

7. Non-historized Links

8. An example of Nonhistorized Links

9. Non-descriptive Links

10. An example of Nondescriptive Links

11. Computed Aggregate Links

12. An example of Computed Aggregate Links

13. Exploration Links

14. An example of Exploration Links

15. Data Vault 2.0 Intermediate Quiz.html

6. Data Vault - Intermediate - Satellites

1. Overloaded Satellites

2. An example of Overloaded Satellites

3. Multi-Active Satellites

4. An example of Multi-Active Satellites

5. Status Tracking Satellites

6. An example of Status Tracking Satellites

7. Effectivity Satellites

8. An example of Effectivity Satellites

9. Record Tracking Satellites

10. An example of Record Tracking Satellites

11. Computed Satellites

12. An example of Computed Satellites

13. Data Vault Intermediate Satellites Quiz.html

7. Data Vault - Advanced

1. Point-in-Time Tables

2. An example of Point-in-Time Tables Part 1

3. An example of Point-in-Time Tables Part 2

4.1 Bridge table example.xlsx

4.2 bridge table objective.zip

4.3 bridge table preparation.zip

4.4 bridge table validation.zip

4. Bridge Tables

5. An example of Bridge Tables

6. No-History Reference Tables

7. An example of No-History Reference Tables

8. History Reference Tables

9. An example of History Reference Tables

10. Data Vault 2.0 Advanced Quiz.html

8. Case Study

1. Detailed Case Study Part 1

2. Detailed Case Study Part 2

9. Practice Case Studies

1.1 short term rental business - data model image.zip

1.2 short term rental business.zip

1. Short Term Rental Business.html

2.1 football league - data model image.zip

2.2 football league.zip

2. Football League.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy