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
  • Team: Data warehousing within an organization, roles, and teams

Data Vault

  • Multidimensional model: Discussion of the star schema in relation to the DV layer.
  • Reporting: Data ready, i.e., Report Marts and Flat Data.
  • Business Support: Self-service for consumers.

Workshops

  • Test Database: Configuration of the environment for technical sessions
  • Analysis: Preliminary EDW design based on the test database
  • ETL: Creating data loading procedures for the created structures

Automation

  • Automated DV: Automation of Data Vault loading

Requirements

There are no specific requirements needed to attend this course.

 14 Hours

Testimonials (2)

Upcoming Courses

Related Categories