Course Content
Introduction to Data Warehousing
- Introduction to Data Warehouse
- Basic concepts of a data warehouse
- The architecture of data warehouse
- Data Warehouse processes
- Categories of Data Warehouse technology
- Data Warehouse project and initiative types
Introduction to the Dimensional Model
- Facts
- Dimensions
- Star schemas
- Snowflakes
Project Management Deliverables
- Data Warehouse strategy
- Data Warehouse project scope
- Managing a Data Warehouse project
- Data Warehouse project plan
- The iterative release model
Architectural deliverables
- Requirements
- Analysis
- Design
- Infrastructure
- Implementation
Implementation, Operation and Expansion
- Implementation Deliverables
- Outcomes from design
- Outcomes from analysis
- Outcomes from deployment
- Outcomes from construction
- Operational Deliverables
- Outcomes of usage
- Service level agreements
- Data Warehouse monitoring and governance
Normalization and Schema
- Introduction to Normalization
- What is a schema
- Types of Schema
Maintaining the Data Warehouse
- Incremental Data warehouse releases
- Follow-up to DW
- On-going assessment
- Post mortem and lessons learned
- Managing consultants
- Managing the vendor
- Getting started with data warehousing
ETL in Detail
- Concepts of ETL
- Data Loading techniques
- Transformation - Data Validation, Data Accuracy, Data Type Conversion, Business Rule Application
Modelling
- Requirement gathering
- Principles of dimensional modelling
- Modelling - ER diagrams