Data Warehouse Lifecycle:
Who should attend?
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.
Course Outline:
Data Warehousing framework
- Concepts and definitions
Project Planning
- Scoping and risk assessment
- Data warehouse project team roles and responsibilities
- Project plan development and maintenance
Dimensional Modelling
- 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
Product Selection
- Techniques
Deployment
- speeding up the load cycle
- Integrating data from multiple sources
- Data Quality and Data Cleansing
- User Education
Technical Architecture
- Overview of technical architecture
- Architecture and Infrastructure
- Planning and Growth
- Common components and services
- Staging area considerations
- Data warehouse user types
Metadata Management
- Sources and management of metadata
Design and Development
- Operational Data Store (ODS)
- Data management
- Basic extract, transformation and load techniques
- Surrogate key creation and maintenance
- Fact table extract issues
- Building aggregates
On-going Maintenance
- Training and support approaches
- User support
- Documentation and the web
- On-going system maintenance
Click here for the full schedule of this course.
Click here to return to the training section.
