Monday, 21 July 2014

Data WareHouse and Business Intelligence Project Activities in Waterfall/Agile Methodology

Initiation phase

Requirement Analysis



  • Cost benefit analysis and ROI calculation

  • Project feasibility analysis

  • Business case study

  • Project cost estimation

  • Resource identification and allocation, other project management tasks

  • Vendor identification

  • Proof of concepts


  • Risk Assessment

  • Info Security Assessment

  • Data Dictionary

  • Capture Business requirements

  • Source Data Analysis

  • Defining source system format

  • Capture Non Functional requirements


  • Business requirement document, Functional specification document ,

  • Data dictionary, etc


  • High Level Architecture Design- Architecture Design artifacts , Project Technical review

  • Detailed design- Application Design (ETL/Report Design), Database Design

  • Data profiling, Data Quality analysis

  • Proof of concepts

  • Source Data Analysis

  • Source Target mapping

  • Logical/Physical Data Modeling

  • Design of workflows and schedule

  • Design walkthrough, review and sign offs

Deliverables: Design documents, data models, data mapping documents, etc




  • Prepare test strategy, test plan and test cases

  • Test document review and sign off

  • Test data set up

  • Test scripts creation

  • System integration/functional testing

  • Data validation

  • Performance testing

  • Defect logging and tracking

  • QA testing sign off

  • User acceptance testing and sign off

Deliverables: Testing documents, Defect summary, etc


  • Prepare Implementation plan or deployment guides

  • Raise change management/implementation tickets and get necessary approvals

  • Prepare runbooks

  • Support implementation group during implementation

  • Knowledge transfer

  • Provide post production support during warranty period

Deliverables: Production implemented code, run books, support manuals, change tickets, etc