Stages in BI Project an Overview

Stages in BI project

•  Project Preparation / Requirement Gathering
•  Business Blueprint
•  Realization
•  Final Preparation
•  GO Live & Support

Project Preparation / Requirement Gathering

Collect requirement thru interviews with Business teams /Core users / Information Leaders .

 Study & analyze KPI 's (key figures) of Business process .

 Identify the measurement criteria's (Characteristics).

 Understand the Drill down requirements if any.

 Understand the Business process data flow if any .

 Identify the needs for data staging layers in BW u2013 (i.e need for ODS if any)

 Understand the system landscape .

 Prepare Final Requirements Documents in the form of Functional Specifications containing :

Report Owners,

Data flow ,

measurement 

Report format along with drill down requirements .

 Business Blueprint

Check Business content against the requirements

Check for appropriate

Info Objects - Key figures & Characters

Check for Info cubes / ODS

Check for data sources & identify fields in source system

Identify Master data

document all the information in a file u2013 follow standard templates

 Prepare final solution

Identify differences (Gaps) between Business Content & Functional

specification. propose new solutions/Developments & changes if required at different levels such as Info Objects ,Info cube , Data source etc . Document the gaps & respective solutions proposedu2013 follow standard templates

Design & Documentation

Design the ERD & MDM diagrams for each cube & related objects

Design the primary keys/data fields for intermediate Storage in ODS

Design the Data flow charts right from data source up to Cube .

Consider the performance parameters while designing data models

Prepare High level / Low level design documents for each data model.

Identify the Roles & Authorizations required and Document it u2013 follow standard templates

 Sign off the BBP documents

 Realization

Check & Apply Latest Patches/Packages ...in BW & R/3 systems.

Activate/Build & enhance the cubes/ODS as per data model designs...maintain the version documents .

Identify & activate Info objects / Master data info sources / attributes ,prepare update rules

Assign data sources .prepare transfer rules , prepare multi providers . prepare Info packages .

perform the unit testing for data loadsu2026.both for master data & transaction data .

develop & test the end user queries .

Design the process chains ,schedule & test

create authorizations / Roles u2026assign to users ..and test

Apply necessary patches & Notes if any .

freeze & release the final objects to quality systems

perform quality tests .

Re design if required . (document changes, maintain versions)

 Final Preparation

Prepare the final check list of objects to be released .identify the dependencies & sequence of release

perform Go Live checks as recommended by SAP in production system

keep up to date Patch Levels in Production system

Test for production scenarios in a pre-production system which is a replica of production system .

Do not Encourage the changes at this stage .

freeze the objects .

GO Live & Support

keep up to date Patch Levels

Release the objects to production system

Run the set ups in R/3 source system & Initialize Loads in BW

Schedule Batch jobs in R/3 system (Delta loads)

schedule the process chains in BW .

Performance tuning u2013 on going activity

Enhancements - if any