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
Basics
- What is a data warehouse? The single source of truth, or the single source of lies?
- Popular solutions: popular schools of data warehouse implementation and their disadvantages. What problems need to be solved, and will Data Vault help with this?
- Enterprise Data Warehouse: what it is and how Data Vault fits into this concept
- The team: Data warehouse in an organisation, roles and teams
Data Vault
- Multi-dimensional model: Discussion of the star model in relation to the DV layer.
- Reporting: Data at hand, i.e., Report Marts and Flat Data.
- Business support: Self-service for recipients.
Workshops
- Test database: Configuring the environment for technical classes
- Analysis: Preliminary EDW design based on the test database
- ETL: Creating data 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
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.