BI QuestionsBusiness Intelligence What is the Business Intelligence Project Lifecycle May 20, 20161530 views0 Share By IG Share 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 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 Implementation 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 https://www.gigxp.com 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. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
PowerBI How to Do Conditional Formatting In Power BI with Rules – Font Color Scales By Navneeth NagrajanFebruary 2, 2018
Business Intelligence Power BI Service Desktop & Embedded Interview Questions and Answers By IGMarch 5, 2017
Business Intelligence How to Create Troubleshoot and Resolve PowerBI Gateway Issues By IGJune 21, 2016