sulee

• Aug 22nd, 2007

 

 

STRAGEGY & PROJECT PLANNING

Definition of scope, goals, objectives & purpose, 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 of interviews and group sessions with users

Review of existing documents

Study of source operational systems

Derivation of business metrics and dimensions needed for analysis

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 DBMS

Selection and installation of ETL and information delivery 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 recovery

MAINTENANCE

Ongoing monitoring of the data warehouse

Continuous performance tuning

Ongoing user training

Provision of ongoing support to users

Ongoing data warehouse management

idanh79

 Profile Answers by idanh79 

• Dec 7th, 2009

 

1. project planning
2. business requirement definition
3. dimension modeling+ technical architecture design
4. pysical design+ product selection
5. data staging design and development+end-user application development
6. deployment+QA

Idan Halfon