~ Seminar Outline

1. Introduction to Data Warehouse

   • Problems that lead to data warehouse
   • Goals and ojectives of data warehouse
   • Cost justification and benefits

2. Data Warehouse Architecture

   • OLTP versus data warehouse
   • ODS vs. data warehouse vs. data mart
   • Data Mining

3. Risks And Failures

   • Economic failure
   • Political failure
   • Technical failure
   • Common risks
   • Risk scenario planning

4. Infrastructure

   • Hardware and network
   • Tools and software
   • Standards
   • Methodology

5. Data Management

   • Cost of poor quality data
   • Dirty data categories
   • Data cleansing guidelines

6. Data Models and Meta data

   • Logical data model
   • Meta data and repositories
   • DW modeling extensions
   • Physical data models
   • Design reviews

7. Data Warehouse Methodology

   • Rapid Application Development
   • Iterative and "looping"
   • Parallel development efforts
   • Major milestones
   • Tasks and deliverables

8. Development Contract

   • Functional scope
   • User expectations
   • User responsibilities
   • Contract components

9. Data Warehouse Organization

   • Roles and responsibilities
   • Core team
   • Extended team
   • Data warehouse administration

10. Project Planning And Control

    • What's different about DW
    • Developing the project plan
    • Seven deadly sins

11. Vendor Management

    • Product categories
    • Product evaluation
    • Vendor evaluation

12. Critical Success Factors

    • DW critical success factors
    • Measuring success
    • Bare essentials for success