Newsletters Welcome, Guest Log In | Register

Subscribe

Sign up now and get the best business technology insights direct to your inbox.

  • Daily Edge
  • CTO Edge Update
  • Business Tools & Templates
  • Aligning IT & Business Goals
  • Maximizing IT Investments

Be a Guest Author

Have an opinion you would like to see published here?

6

Measuring the Return on Investment for Business Intelligence

by Dorothy Miller, Redstone360
Feb 24, 2009 9:52:48 AM

Business intelligence quality is different from the return on investment (ROI) for BI. A business intelligence project or system is designed to deliver specific information. BI quality is, most often, an IT-based assessment of the results of a business intelligence project. Measuring the quality of the BI system includes the basic logistics: getting the right information to the right people when needed and meeting the stated business goals for the BI system. Thus, BI quality is determined by assessing:

 

  • The correctness and integrity of the data.
  • The translation of the data into usable information.
  • The speed and format of the delivery.
  • How well the information meets the design criteria and business requirements in the preliminary design. (Do the users approve it?).

 

On the other hand, the ROI for BI is a business-management question. The ROI assessment is perhaps even more important to the organization. However, there are no industry standards for measuring the benefits of business intelligence. But listing them as “intangible” is no longer an acceptable answer.

 

Can We Calculate ROI for BI?

 

Placing a tangible value on the benefits of BI has been frustrating. In most cases, organizations have had to accept on intuition and faith that the benefits of BI are worth the costs, and that the risks of not making those investments are too great. What if your competitors are translating all their data into some fantastic information that will give them the edge?

 

We can start with the total cost of ownership for BI, which can be calculated with some level of reasonable accuracy. Deciding what should be included in those costs may be a matter of interpretation. However, there can be some standard and relatively straightforward decisions that will allow project-by-project comparisons and overall resource estimates. These costs include those for the data warehouse; information delivery; data gathering and management; and all the associated infrastructures, software, tools and support resources.

 

In addition, the BI project development, management and delivery costs, including the infrastructure, are part of the cost equation. What is most likely not being considered in current cost calculations are those involved in the training and experience base of the people who are a critical component of the BI product. Deciding what should be included in BI investment costs may be a matter of interpretation, but all these costs can be calculated, or at least identified, prorated and estimated.

 

Much more difficult is placing a value on the benefits received. How well are we using the information to make better decisions? There are metrics, such as comparisons of operational efficiencies, before and after, that are relatively standard for some of the most simple of BI applications. However, projecting and calculating tangible values for returns, especially on more complex BI investments, is not simple. The process can be frustrating and has often seemed impossible and, perhaps, pointless. But if we can assess these benefits and provide some tangible ratings, we can provide a basis for management decision-making about BI investments for the organization.

 

Think about it this way:

 

Good BI is the fusion of the right information, the right time, the right format, and the right human and/or system resources. If we wish to improve BI, we ask these questions:

  • Do the people (or intelligent systems) have the information needed, when they need it, to make decisions?
  • Do those people have the expertise, training and mindset to use that information in the best way for the good of the organization?
  • Are they doing their job better because of the information being delivered?
  • How much difference does that information make to them?

 

A Benefits Audit for BI

 

The most effective way to assess the benefits of BI is to ask the people who are involved. We can use questionnaires and surveys administered at regular intervals. This is a simple and direct approach. However, such a benefits audit must also be rigorous and structured to give tangible, realistic assessments of the relative benefits of BI projects, BI capsules (designated BI groupings), and the total organizational BI investment.

 

Using formal, well-constructed metrics and patterns, we can turn the opinions of experts into a trustworthy assessment of the benefits of BI for the organization. Those experts are the people who use the information and the managers who daily assess the value of the performance of those people who use this information. We may also wish to add competitive analysis and opinions from customers, marketing teams and consultants. Thus, we can turn expert evaluations into a practical, meaningful assessment tool for management.

 

There are a number of valuable features to be gained from such a benefits audit. We can:

 

  • Make better decisions regarding commitment of resources to BI. The relative values of BI projects can be identified before spending the money on development. Opportunity costs and risks can be evaluated up front.
  • Improve management planning, both strategic and tactical. Competitive, legal and regulatory requirements can more easily be assessed and planned for, and associated risks can be reduced.
  • Encourage better decision-making.
  • Improve the quality of BI and BI projects through a better understanding of the results. We will be able to feed results back into the processes for BI design, development and use.
  • The organization’s culture can evolve and improve through an increased awareness of BI, integration and communication.
  • Provide encouragement and support for our people. Just administering such audits will send a message that the organization cares about them, respects their opinions and is open to new ideas.
  • Encourage creativity and broader use of BI  through recognition and associated education, training and awareness.

 

The questions, formats and process of the BI benefits audit will provide increased awareness, understanding and training for those who develop and implement the audit, as well as for those who participate.

Add a comment Leave a comment on this blog post.
Feb 25, 2009 7:40 PM Guest Peter Thomas  says:

I agree that it is difficult to measure the RoI of BI directly. You need to use proxies, these would include things like: -

 

1. User adoption

 

How many people use the system and do more people want to use it? How do these numbers change over time? What is penetration like in different areas of the organisation?

 

2. User retention

 

Of the people who are given access to the system and training in its use, how many go on to become regular users? How does this change over time?

 

3. Usage

 

Of course this relates to the previous two points as well, but directly measuring usage and even using your BI tool to analyse how this changes over time is important.

 

4. Demand for enhancements / extension to the BI system

 

If you have people wanting the system to do more, then they must be happy with how it is working in general terms.

 

5. Surveys

 

It always helps to get feedback on what you are doing. Partial results of one such survey appear on my blog at: http://tinyurl.com/dfxpkj

 

6. Do business users mention your system in meetings

 

When presenting figures to senior management, is the source quoted as a matter of course (hopefully to establish that the figures are reliable)?

 

7. Productivity studies

 

In a BI project I ran recently, we moved from it taking 5-7 days to assemble certain types of information to it being available virtually instantaneously.

 

8. Improvements in what you are measuring

 

If there is a correlation between what you are measuring and improvements in it, then you are on the right track. When this is sales and profitability, then RoI becomes somewhat easier to establish.

Feb 26, 2009 1:10 AM Guest nSynergy  says:

Business Intelligence with Office SharePoint Server 2007 provides an infrastructure that makes it easy for decision-makers to access information anytime, anywhere. People can get up-to-date information where they work, collaborate, and make decisions, whether it's on the desktop or over the Web.

 

There is more information on Business Intelligence solution at http://www.nsynergy.com/Products/SharePoint/Pages/Business_Intelligence.aspx or please mail to info@nsynergy.com.

Mar 1, 2009 2:18 PM Dorothy Miller Dorothy Miller    says in response to Peter Thomas:

Hi

(I replied last week to your note - but have not seen it posted - let's try again.)  

Thanks so much for your comments.   Sounds like you agree with the need for more tangible ROI measurements for BI.   I think that most of us think we need the ROI but have stuck with the 'intuitive' approach because there are no practical, standardized metrics and templates which are easy to apply.  Your ideas for some of the possible metrics sound reasonable to me also.   I have been working for several years on applying Six Sigma methods to BI for effective management for the IT community.  However, I have concluded that there are some major differences in what the general business management community needs for management of the organization BI resources and assets.   I believe that coming up with a way to calculate a tangible  Return on Investment is a key.  

 

Perhaps some of our other readers may have some thoughts on this?

 

Dorothy Miller

www.bi-metrics.com

dmiller@bi-metrics.com

 

Thanks

Mar 3, 2009 3:10 PM Guest Peter Thomas  says in response to Dorothy Miller:

Dorothy,

 

You are right in assuming that I would like to see better ways to calculate the benefits of BI, getting to a proper RoI would be great, but I think the road is strewn with obstacles. Strangely it may be easier to calculate RoI for operational BI (i.e. by looking at correlations with productivity - which BI itself can measure) than for, more typical, financial or results-focussed BI.

 

I posted a thread related to your article (and my comments on it) at LinkedIn.com, the URL is http://www.linkedin.com/groupAnswers?viewQuestionAndAnswers=&gid=48613&discussionID=1706567 if you are interested. You need to be a member of LinkedIn.com and the CIO Magazine group to view it.

 

All the best

 

Peter

May 19, 2009 2:10 PM Guest Per Solli  says in response to Peter Thomas:

Peter and Dorothy,

 

I had the pleasure to work on a project sponsored by Gary Crittenden when he was the CFO at American Express. In his view all discretionary spending in an organization should be measured with an ROI in all branches of the organization. Whether we are promoting costly marketing programs, pursuing customer retention, acquiring new customers bases, doing R&D or helping the field sales people with a new CRM solution we are all spending money and also contributing to the ROI of the money we are spending. "If it can't be measured, it is not being managed".

 

So all branches from sales, marketing, r&d and IT were measured on the benefits provided to the organization based on Risk, Strategy and ROI.

 

The ROI is measured in both tangible benefits like dollar saved or dollars earned, but we must also be open to measure intangible benefits like increase in efficiency, customer satisfaction, reducing risk and strategic attractiveness.

 

American Express chose to look at every discretionary dollar spent went into a project that had certain risk, stratgic linkage and other factors investment managers were being manged on.

 

Taken this approach to BI, it is the same: We need to look at the hard dollars we are going to spend, with the benefits of the community and the linking the project provides to the overall company strategy.

 

If the organization's maturity level is high and all levels understands the importance of being measured and rewarded, investing in an investment optimization portfolio is step number one to start recognizing how to adopt the best BI initiatives and strategically select, re-allocate and optimize the portfolio of ongoing initiatives.

 

Please email me for more information and white-papers on investment optimization for BI-initiatives.

 

Great discussion you have started with lots of common points. The challenge is usually the organizational change required to institute a culture of 'being measured'.

 

Regards,

 

Per Solli

per@orangepeelcorp.com

Lowering Your IT Costs with Oracle Database 11g Release 2

This white paper identifies the key capabilities a database management solution needs to successfully deliver more information with higher quality of service, make more efficient use of IT budgets, and reduce the risk of change in data centers.

Oracle Data Guard with Oracle Database 11g Release 2

Read this white paper to learn about a unique data protection and recovery solution that creates synchronized standby databases that protect data from failures, disasters, errors, and corruptions, addressing both high availability and disaster recovery requirements.

Data Management

Data management tips and techniques that insure ease of access, comprehensive security and absolute privacy for your invaluable company information.

Information Management

Tools, tips and solutions to help you manage your data more efficiently to tackle today's challenging economic environment.

Data Warehousing for Business Intelligence

Comprehensive storage solutions for better data access and retrieval, leading to better-informed business decisions.

Business Intelligence

Best-practice tools, strategies and technologies for determining and managing the data you need to make better business decisions.

Strategic IT Planning & Governance Best Practices Guide

Use this guide — along with the more than 60 templates included — to ensure the overall success of your entire IT department.

Learn more >

Six Sigma Framework for IT

This collection of tutorials, calculators, and templates will show you how to apply six sigma thinking to IT service management.

Learn more >