Get in Touch

Course Outline

Fundamentals

  • What is a data warehouse? A single source of truth or a single source of lies?
  • Popular solutions: Common data warehouse implementation methodologies and their drawbacks. What problems need to be solved, and can Data Vault help?
  • Enterprise Data Warehouse: What it is and how Data Vault fits into this concept.
  • Teams: 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: Data at rest – Report marts and flat data.
  • Business support: Self-service for consumers.

Workshops

  • Test database: Configuring the environment for technical exercises.
  • Analysis: Preliminary EDW design based on the test database.
  • ETL: Creating data loading procedures for the designed structures.

Automation

  • Automated Data Vault: Automating Data Vault loading.

Requirements

There are no specific requirements to attend this course.

 14 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories