Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (2)
The variety of the information shared and the clarity to explain terms in plain English.
Arisbe Mendoza - Fairtrade International
Course - GDPR Workshop
It's a hands-on session.