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

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from £3800 online delivery, based on a group of 2 delegates, £1200 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Testimonials (2)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories