BI QuestionsBusiness Intelligence

What is the Business Intelligence Project Lifecycle

What is the Business Intelligence Project Lifecycle

What is the Business Intelligence Project Lifecycle

Question: Define what is the business intelligence project lifecycle. Explain all the phases in detail with examples.

Answer: The Data Warehouse Project Life Cycle model consists of the following phases:

  • Envision
  • Plan
  • Build
  • Stabilize
  • Deploy


What is the Business Intelligence Project Lifecycle

  • The initial phase is the Envisioning phase where the Vision and the final scope needs to be agreed and approved.
  • The second phase is the Plan phase where interviews with the business sponcers and the stake holders (Direct & Indirect) are conducted to gather business requirements. Project planning is done based on requirements and a BI functional document is created.
  • The Build phase is the longest phase where based on the agreed scope, Design and implementation of the BI architecture is done. The developers will design and develop the data models and integrate with data marts and LOB (Line of Business Applications) such as CRM, Retail, ERP, IT and the Web. Using tools like SSIS (SQL Server Integration Services) Extract, Transform & Load (ETL) is done to populate the de-normalized databases in the data warehouse.
  • In the Stabilize phase, product stability is tested before moving to production.
  • The final phase is the Deployment phase, where the complete development process is completed and the system is moved into production for end users.

Activities that take place throughout all phases of the project:

  • E2E Project management throughout all phases.
  • Status and communication to Stake Holders.
  • Quality control from the build phase onwards.
  • Scope and change management if any.
  • Knowledge transfer and Training to End users from UAT onwards.

Envisioning and Project scope

  • Business & IT Requirements
  • Initial Analysis and assign Priorities
  • Project & Resource planning.
  • Project Management tool using Microsoft Project.

Development & Deployment Setup

  • Design the Infrastructure and setup (Cloud or Local)
  • Physical databases (Data Warehouse and Data Marts)
  • Extract, transform and load (ETL)
  • Data Model Design (OLAP)
  • Presentation Layer for Reporting and analytical functionality

Testing at the Stabilize Phase

  • Unit Tests
  • Integration
  • Acceptance


  • Operations startup and liason with IT Team.
  • Production roll-out to End Users.
  • Transition to IT and End Users, Training.
  • Project Closure


Disclaimer: The Questions and Answers provided on are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose.

What's your reaction?

In Love
Not Sure

You may also like

Comments are closed.