Get in Touch

Course Outline

Fundamentals

  • What is a data warehouse? The single source of truth, or the single source of lies?
  • Popular solutions: Common data warehouse implementation schools and their drawbacks. What problems need to be solved, and can Data Vault help with that?
  • Enterprise Data Warehouse: What it is and how Data Vault fits into this concept.
  • The Team: Data warehouses in organizations, roles, and teams.

Data Vault

  • Multidimensional Model: Discussing the star schema in relation to the DV layer.
  • Reporting: Data already available, meaning Report Marts and Flat Data.
  • Business Support: Self-service for end users.

Workshops

  • Test Database: Configuring the environment for technical sessions.
  • Analysis: Preliminary EDW design based on the test database.
  • ETL: Creating data loading procedures for the established 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)

Upcoming Courses

Related Categories