Get in Touch

Course Outline

Fundamentals

  • What is a data warehouse? Is it the single source of truth, or the single source of falsehood?
  • Common solutions: Popular schools of data warehouse implementation, their drawbacks, and the key problems to address. Can Data Vault provide a solution?
  • Enterprise Data Warehouse: Definition and how the Data Vault concept aligns with it
  • Team structure: Data warehousing within an organization, roles, and teams

Data Vault

  • Multidimensional model: Discussion of the star model in relation to the Data Vault layer
  • Reporting: Immediate data availability through Report Marts and Flat Data
  • Business support: Self-service capabilities for end users

Workshops

  • Test database: Environment configuration for technical exercises
  • Analysis: Preliminary Enterprise Data Warehouse design based on the test database
  • ETL: Developing data loading procedures for the created structures

Automation

  • Automated DV: Automating the Data Vault loading process

Requirements

There are no specific prerequisites required to attend this course.

 14 Hours

Testimonials (2)

Related Categories