Course Outline

Fundamentals

  • What is a data warehouse? A single source of truth or a single source of lies?
  • Popular solutions: popular schools of implementing data warehouses and their drawbacks. What problems need to be solved and can Data Vault help with this?
  • Enterprise Data Warehouse: what it is and how does Data Vault fit into this concept
  • Team: Data warehouse in the organization, roles, and teams

Data Vault

  • Multidimensional model: Discussion of the star schema in relation to the DV layer.
  • Reporting: Ready data, or Report Marts and Flat Data.
  • Business support: Self-service for consumers.

Workshops

  • Test database: Configuring the environment for technical exercises
  • Analysis: Initial EDW project based on the test database
  • ETL: Creating loading procedures for the created structures

Automation

  • Automated DV: Automating Data Vault loading

Requirements

There are no specific requirements needed to attend this course.

 14 Hours

Number of participants


Price per participant

Testimonials (2)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories