Data Warehouse Spiral Roadmap:
from Inception to Implementation and Beyond

by Shaku Atre


This seminar provides a soup-to-nuts spiral roadmap for building Data Warehouses.
Regardless whether this is your first attempt at Data Warehousing, or it is your tenth Data Warehouse iteration, you will need an agile and adaptive development approach. If you attempt to use a traditional waterfall methodology as your development guide you will struggle with its rigidity, its linear approach, its missing tasks and roles, and with its stand-alone system focus.
This seminar will show you the dynamic and adaptive spiral approach to Data Warehouse development. It will give you a complete set of development steps for all six engineering stages of a Data Warehouse: Justification, Planning, Business Analysis, Design, Construction and Deployment.
It will include steps not found in traditional methodologies, such as Enterprise Infrastructure, Prototyping as an analysis technique, and building a Meta Data Repository.
At the end of each development step you will apply what you learned in dynamic team exercises. This seminar is a complete "how-to" instructional guide for Data Warehouse projects. To provide this agility this seminar will include a Roadmap Matrix, which is the spiral roadmap at a glance.
This matrix shows time estimating guidelines, cost estimating guidelines, roles, entry criteria, exit criteria, deliverables, activities and tasks for every development step. Additional guidelines are provided for each development step, such as the DO's and DON'Ts as well as Tips and Rules of Thumb.

Main Topics

  • Business Case Assessment
  • Non-Technical Infrastructure
  • Technical Infrastructure
  • Project Planning
  • Project Delivery Requirements
  • Data Content Analysis
  • Application Prototyping
  • Meta Data Repository Analysis
  • Meta Data Repository Design
  • Database Design
  • Extract/Transform/Load (ETL) Design
  • Extract/Transform/Load (ETL) Development
  • Application Development
  • Data Mining
  • Meta Data Repository Development
  • Implementation
  • Evaluation