Course curriculum

    1. Introduction

      FREE PREVIEW

    2. Course Outline and Key Learning Outcomes

      FREE PREVIEW

    3. Get the Materials

    1. Enterprise data warehouse environment

      FREE PREVIEW

    2. Introduction to Data Vault

      FREE PREVIEW

    3. Data warehouse architecture

    1. Struggling of data warehouse with changes

    2. Data vault 2.0 architecture

      FREE PREVIEW

    3. Business rules application

    4. Staging area layer

    5. Data warehouse layer

    6. Information mart layer

    7. Extension of data vault 2.0 architecture >> Metrics Vault

    8. Business Vault

    9. Operational Vault

    1. Project planning

    2. Project planning >> Roles & Duties

    3. Project planning >> Communication

    4. Project planning >> CMMI maturity model

    5. Project planning >> SCRUM

    6. Project planning >> Estimation of the project

    7. Project execution

    8. Project execution >> Implementation steps under agile - Scrum methodology

    1. The data vault modelling

    2. Data vault 1.0 use case, requirement, database diagram & table structure

    3. Data vault 1.0 modelling

    4. Data vault 1.0 hub, link, satellite, ETL load

    5. Data vault 2.0 definition

    6. Data vault 2.0 application >> hub application

    7. Link application >> Link on Link

    8. Link application >> Same as Link

    9. Link application >> Hierarchical Link

    10. Link application >> Computed Aggregate Link

    11. Link application >> Exploration Link

    12. Satellite application >> Overloaded Satellites

    13. Satellite application >> Multi-active Satellites

    14. Satellite application >> Status tracking Satellites

    15. Satellite application >> Effectively Satellites

    16. Satellite application >> Computed Satellites

    17. Advanced data vault modeling >> Point-In-Time tables

    18. Advanced data vault modeling >> Bridge tables

    19. Data vault 2.0 flexibility

      FREE PREVIEW

    1. Data vault 2.0 introduction & use case implementation

    2. Data vault 2.0 load patterns >> hub, link, satellite, ETL load

    3. Data vault 2.0 load patterns >> hash key & parallel

About this course

  • $26.00
  • 60 lessons
  • 6 hours of video content

Reference, Rating, and Feedback

Intended learners

What will you learn in the course?

  • Modernizing Data Warehousing for Advanced Analytics with the powerful methodology of Data Vault 2.0

  • Scalable Data Vault 2.0 data warehouse architecture

  • Data Vault 2.0 methodology in discussing project planning & execution

  • How to Modelling Data Vault 1.0 & 2.0

  • The real practical of Data Vault 2.0 with Loading Patterns, ETL Load, HashKey

  • How to design Dimensional Model

  • Master Data Management from architecture to implementation steps

  • Meta data management on each data layers and how to capture metadata

  • Update Enterprise Data warehouse (DWH) Platform from IBM, AWS and Data Vault 2.0 technology landscape

  • Hands-On Lab with loading source to datavautl, to datamart and to OLAP CUBE by using SQL Server, SSIS, SSAS

Instructor(s)

Instructor Bio:

I'm a seasoned author deeply passionate about data strategy and management. With over 15 years in IT, spanning banking, insurance, and retail, I've held key roles such as Data Division Director and Chief Data Officer. Currently, as Director of Data Division, I shape data initiatives, while as a Governance & Analytics expert, I establish robust frameworks. Through my writing, I share practical strategies and insights honed from diverse industry experience.

Dien Pham Cong

Chief Data Officer

Discover your potential, starting today

Enroll today

Subscribe to our Newsletter!

Add your email to the mailing list to get the latest updates.

Thank You