Building BI Project

Efficiency at its best…

Cost Justifying BI Solutions

• Cost justification is a substantiation of the need for expenditure with documentary or other evidence.

• Four aspects:1. Hardware2. Software3. Personnel4. Consulting Services

Increasing Returns using BI (ROI)

• ROI is a main highlight of a business

• Methods to increase ROI:– Increase revenue– Decrease Costs– Improve effeciencies

Increasing Revenue

• Identify and acquire new customers• Increase rate of selling eg. Via Cross selling• Empower sales force to sell more or quicker• Make money from information• Increase market penetration• Explore new or wider market opportunities

Decrease costs

– Reduce excessive overheads

– Reduce wastes

– Reduce the unnecessary layers of data duplication in the data warehouse environment

Improve Effeciencies

• Stream Line Operations- (streamline is to improve efficiency by simplifying or eliminating unnecessary steps using modernizing techniques or taking other approaches)

• Reduce data delivery delays

• Provide better info. to decision makers in shorter period of time

Measuring Success

• TCO- Total Cost of Ownership is a financial estimate intended to help buyers and owners determine the direct and indirect costs of a product or a system

• ROI- Return on Investment• NPV- Net Present Value• IRR- Internal rate of return• Rate of End user adoption

Collecting User requirements

• Purpose- to get best ideas from employees and, after consultation, to prioritize them simultaeonusly maintaining the integrity of the project plan and meeting the budget and timeline

• Requirement Gathering Techniques

• Validating BI requirements

• Prioritizing BI requirements

• Changing requirements

Requirements Classification for BI

Validating BI requirements

• A few of the collected requirements may be working at cross purposes

• Validation ensures that the requirements make sense when viewed together and are in the context of the underlying businesses

• Steps:-Laying out requirements-Finding commonalities-List out unknowns and questions-mapping out feasiblle data needs of the project

Prioritizing BI requirements

• The priorities of the requirements are focused upon• Causes- excess features or too few resources or

less time. So work needs to be done in phases.• 3 categories of classifications:

1. Must 2. Should 3. Could• After they are vetted, run them by a group of high

level stake holders• Final critical step is the sign of from the important

concerned party(s)• Goal is to create a requirements baseline that

cannot be altered.

Thank You