The Data Warehouse Lifecycle

This course is valuable for all those involved in major roles on a data warehouse project, from project managers to DBAs to data modellers and application developers. It is also ideal for IT professionals from various backgrounds including Information technology, who plan to cross train into Data warehousing and Dimensional modelling to enhance their careers.

Scoping and risk assessment
Data warehouse project team roles and responsibilities
Project plan development and maintenance
Definition of dimensional modelling
Definition of Fact and dimension tables
4-step process for designing dimensional models
Denormalizing dimension hierarchies
Surrogate keys
Factless fact tables
Degenerate dimensions
Conforming dimensions
Slowing changing dimension techniques
Types of Fact tables
Large dimension design considerations
Multi-valued dimension attributes

Stoke on Trent
London EC

Guide Price: £975 Ex VAT

Delivery: Classroom
Regions:
  • The West Midlands
  • London
Category: Data warehousing