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 ...
Get Data Warehousing Fundamentals for IT Professionals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.