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 data warehouse implementation approaches and their limitations. What challenges need to be addressed, and can Data Vault help?
  • Enterprise Data Warehouse: What it is and how Data Vault fits into this concept.
  • The team: Data warehousing within an organisation, roles and teams.

Data Vault

  • Multidimensional model: Discussion of the star model in relation to the Data Vault layer.
  • Reporting: Ready-to-use data, including Report Marts and Flat Data.
  • Business support: Self-service capabilities for end users.

Workshops

  • Test database: Environment setup for technical sessions.
  • Analysis: Preliminary EDW design based on the test database.
  • ETL: Creating data loading procedures for the developed structures.

Automation

  • Automated DV: Automating Data Vault loading processes.

Requirements

There are no specific prerequisites required to attend this course.

 14 Hours

Number of participants


Price per participant

Testimonials (2)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories