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 (Exc. Tax)

Testimonials (1)

Provisional Courses

Related Categories