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

Initiation phase	Requirement Analysis	Design
Activities: 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	Activities: Risk Assessment Info Security Assessment Data Dictionary Capture Business requirements Source Data Analysis Defining source system format Capture Non Functional requirements Deliverables: Business requirement document, Functional specification document , Data dictionary, etc	Activities: 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

Testing	Implementation
Activities: 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	Activities: 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