The Data Warehousing Process

Stage 1 :

Determine Informational Requirements
• Identify and analyze existing informational capabilities.
• Identify from key users the significant business questions and key metrics that the target user.Group regards as their most important requirements for information.
• Decompose these metrics into their component parts with specific definitions.
• Map the component parts to the informational model and systems of record.

Stage 2 :

Evolutionary and Iterative Development Process

When you begin to develop your first data warehouse increment, the architecture is new and fresh. With
the second and subsequent increments, the following is true:
• Start with one subject area (or subset or superset) and one target user group.
• Continue and add subject areas, user groups and informational capabilities to the architecture
based on the organization’s requirements for information, not technology.
• Improvements are made from what was learned from previous increments.
• Improvements are made from what was learned about warehouse operation and support.
• The technical environment may have changed.
• Results are seen very quickly after each iteration.
• The end user requirements are refined after each iteration.
Data Warehousing is an evolutionary/iterative process that follows a spiral pattern
• The warehouse architecture is initially developed at the start.
• The first increment is developed based on the architecture.
• Building the first increment causes architectural changes.
• Operation of the warehouse brings architectural changes.
• Each additional increment extends the warehouse.
• Each new increment may cause architectural adjustments.
• Continued operation may cause architectural adjustments.