数据仓库建模_4

return on investment (ROI)
net present value (NPV) or internal rate of return (IRR)
The major roles involved in the DW/BI implementation front office, coaches, regular lineup, and special teams

Front Office: Sponsors and Drivers Folks in the front office aren't involved on a daily basis, but they have a significant
influence on the rest of the team.

DW/BI Director/Program Manager

Some team members are assigned to the project full time; others are involved on a
part-time or sporadic basis.

Project managers need strong
organizational and leadership skills to keep everyone involved moving in the same direction.

Business Analyst
The business analyst is responsible for leading the business requirements definition activities and then representing those requirements as the technical architecture,

Metadata Manager

This person is not responsible for inputting all the metadata, but rather is a watchdog to ensure that everyone is contributing their relevant piece,

Special Teams

Technical Architect/Technical Support Specialist Depending on your environment, there may be platform specialists who get involved in early stages of the design to perform resource and capacity planning.

Lead Tester he lead tester develops test methodologies, and confirms that the tests cover the span of the data, processes, and systems.

The DW/BI project needs a detailed, integrated project plan given its complexity, both in terms of tasks and players.

If a single task requires more than two weeks, subtasks should be identified. 我觉得超过1周的都需要.

best project management software package will be worthless unless the time is invested to input and maintain the project plan

tracking the following information for each task

Resources: 

Original estimated effort

Original estimated start date

Original estimated completion date:

Status:

Updated start date

Updated completion date:

Effort to finish:

Late days:

% Completed:

Dependencies:

Also don't forget that ETL development is a classic software development task with five distinct phases: development, unit testing, system testing, acceptance testing, and final rollout with documentation. Inexperienced project managers may focus most of their attention on what turns out to be only the first of the five steps. ETL的测试需要分层级.