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 an organisation, roles, and teams

Data Vault

  • Multidimensional model: Discussing the star schema in relation to the DV layer.
  • Reporting: Data at hand, namely Report Marts and Flat Data.
  • Business Support: Self-service for consumers.

Workshops

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

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