Fundamentals of Data Warehousing (Three Days)
Click here for the full outline of this course.
Advanced Data warehousing Course content:
- Overview of Technical Architecture
- Architecture & Infrastructure
- Planning for growth
- Data Models and Levels of Detail
- Common Components and Services
- Back Room & Front Room
- Staging area considerations
- Data warehouse user types
- Reporting
- Data Mining
- Meta data repository
- Operational Data Store (ODS)
- Physical Database Design
- Aggregation navigation and strategy
- Index types and guidelines
- Data management
- Basic extract, transformation and load techniques
- Surrogate key creation and maintenance
- Fact table extract issues
- Building aggregates
- Speeding up the load cycle
- Integrating data from multiple sources
- Data quality and data cleansing
- Deployment release process-alpha, beta, roll-out
- 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.
