Data Warehousing Fundamentals for IT Professionals

APPENDIX A

PROJECT LIFE CYCLE STEPS AND CHECKLISTS

DATA WAREHOUSE PROJECT LIFE CYCLE: MAJOR STEPS AND SUBSTEPS

Note: The substeps indicated here are at a high level. Expand these substeps as necessary to suit the requirements of your environment.

Project Planning

Definition of scope, goals, objectives, and expectations

Establishment of implementation strategy

Preliminary identification of project resources Assembling of project team

Estimation of project schedule

Requirements Definition

Definition of requirements gathering strategy

Conducting interviews and group sessions with users

Review of existing documents

Study of source operational systems

Derivation of business metrics and dimensions needed for analysis

Design

Design of the logical data model

Definition of data extraction, transformation, and loading functions Design of the information delivery framework

Establishment of storage requirements

Definitions of the overall architecture and supporting infrastructure

Construction

Selection and installation of infrastructure hardware and software

Selection and installation of the DBMSs

Selection and installation of ETL and BI (business intelligence) tools

Completion of the design of the physical data model

Completion of the metadata component

Deployment

Completion of user acceptance tests

Performance of initial data loads

Making user desktops ready for the data warehouse

Training and support for the initial set of users

Provision for data warehouse security, backup, and ...