Course 201. 3 days - Data Warehouse
Lifecycle
Course benefits - click here to download details as a PDF
The data warehouse continues to be one of the most organisationally complex and technically interesting projects in Information Technology and we believe the market today requires professionals to be multi talented and strategically positioned for the growth in Data warehousing and Dimensional Modelling currently happening in corporations. This course will prepare you for the implementation of a successful data warehouse.
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 to 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 content
Data Warehousing Framework
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
- De-normalizing 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
Deployment
- Speeding up the load cycle
- Integrating data from multiple sources
- Data quality and data cleansing
- User Education
|
Course content
Technical Architecture
- Overview of Technical Architecture
- Architecture & Infrastructure
- Planning for 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
|
