Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications

2017-07-07 02:10:07

Listed in this matrix are roles , not people! Multiple roles can and probably will be assigned to one individual; occasionally, one role may be assigned to multiple individuals.

Development Step ^[a]	Vital Roles Involved in the Step ^[b]
1. Business Case Assessment	Business representative Business sponsor Data quality analyst Project manager Subject matter expert
2. Enterprise Infrastructure Evaluation
Section A. Technical Infrastructure Evaluation	BI infrastructure architect Database administrator
Section B. Nontechnical Infrastructure Evaluation	BI infrastructure architect Data administrator Data quality analyst Meta data administrator
3. Project Planning	Application lead developer Business representative Data administrator Data quality analyst Database administrator ETL lead developer Meta data administrator Project manager Subject matter expert
4. Project Requirements Definition	Application lead developer Business representative Data administrator Data quality analyst Meta data administrator Subject matter expert
5. Data Analysis	Business representative Data administrator Data quality analyst ETL lead developer Meta data administrator Stakeholders (including data owners ) Subject matter expert
6. Application Prototyping	Application lead developer Business representative Database administrator Stakeholders Subject matter expert Web master
7. Meta Data Repository Analysis	Data administrator Meta data administrator Subject matter expert
8. Database Design	Application lead developer Data administrator Database administrator ETL lead developer
9. Extract/Transform/Load Design ^[c]	Data quality analyst Database administrator ETL lead developer Subject matter expert
10. Meta Data Repository Design	BI infrastructure architect Data administrator Meta data administrator
11. Extract/Transform/Load Development	Business representative Database administrator ETL developers ETL lead developer Subject matter expert Testers
12. Application Development	Application developers Application lead developer Business representative Database administrator Subject matter expert Testers Web developers Web master
13. Data Mining	Business representative Data mining expert Database administrator Subject matter expert
14. Meta Data Repository Development	Business representative Database administrator Meta data administrator Meta data repository developers Testers
15. Implementation	Application developers Application lead developer Data mining expert Database administrator ETL developers ETL lead developer Meta data administrator Meta data repository developers Web developers Web master
16. Release Evaluation	Application lead developer BI infrastructure architect Business representative Business sponsor Data administrator Data mining expert Data quality analyst Database administrator Developers (ETL, application, meta data repository, and Web) ETL lead developer Facilitator (not on the BI project team) Meta data administrator Project manager Scribe (not on the BI project team) Stakeholders (including data owners) Subject matter expert Web master

^[a] Steps that can be performed in parallel are boxed together to indicate potential overallocation of resources, depending on how the roles are assigned (if different overlapping roles are assigned to the same person).

^[b] Only the roles that perform vital development work are listed. Supporting roles, such as data owner, IT auditor , network services, technical support, and so on are not listed in this matrix.

^[c] Although all design activities can be started and performed in parallel, the design of the BI target databases must be finalized before the design of the ETL process can be completed. This mainly affects the time allocation for the database administrator, who must actively participate in both steps.

Категории