Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search

Resource Portals
Business Intelligence
Business Performance Management
Data Integration
Data Quality
Data Warehousing Basics
More Portals...


Information Center
DM Review Home
Web Seminars & Archives
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

General Resources
Industry Events Calendar
Vendor Listings
White Paper Library
Software Demo Lab
Monthly Product Guides
Buyer's Guide

General Resources
About Us
Press Releases
Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Data Warehouse Delivery:
How about 0% ROI?

  Column published in DM Review Magazine
January 1999 Issue
  By Douglas Hackney

I recently had the pleasure of participating in an extended Q&A; session with about 400 data warehousing professionals at The Data Warehousing Institute's Orlando conference. The attendees and moderators Richard Rist and Wayne Eckerson asked the questions while Pieter Mimno, Bob Craig, Ken Rudin, Michael Haisten, Ralph Kimball, Claudia Imhoff, the irrepressible duo of Neil Raden and Herb Edelstein, and I provided the responses. While the range of topics covered was very diverse, I found one quite striking - the topic of measuring return on investment (ROI) from data warehouse systems.

The initial question related to establishing ROI to justify a data warehouse/data mart system, which is the traditional place and time for this topic to arise. As a follow-up to the question, Richard Rist conducted an impromptu survey of the audience and found that around twenty had attempted to project an ROI before they built their systems. Remarkably, no more than a handful had attempted to measure the actual ROI of their systems once they were up and running.

There has been some questioning by the theorist community of using ROI as a measurement, with no less than Bill Inmon weighing in with the opinion (in a keynote speech a few months ago) that ROI is not a valid measurement of data warehouse success. In Bill's view, using ROI as a metric isn't valid because you "can't measure it until the data warehouse is complete." This being a room and panel full of practitioners, I didn't hear anyone echo Bill's unique opinion. We all knew, all too well, that a data warehouse system is never "complete," and most businesses consider some form of financial analysis of real-world multi-million dollar investments a viable and necessary evaluation criterion.

From the "in the trenches" perspective, the audience and panel brought up some key thoughts to ponder regarding projecting and/or measuring the ROI of your data warehouse/data mart system:

1. First, if you're going to base the justification of your system on a financial measurement like ROI, you'd better be building something measurable. A data mart built to improve customer satisfaction will be hard pressed to measure a finite ROI, whereas a data mart built to support a sales force automation (SFA) application stands a reasonable chance of capturing discrete metrics that can be turned into a meaningful financial analysis.

2. Secondly, there is the problem of how you are going to actually construct your ROI formula. Many IT practitioners consider ROI a single, one-time expense and a single, aggregate return of increased revenue or decreased costs. The worlds of data warehousing and financial analysis are much more complex than this simple vision. Data warehouse systems, as the panel was quick to point out, are never-ending investments. This brings the challenge of how to project the ongoing outflows related to system maintenance and growth. How do you calculate the net present value (NPV) of something that you can't begin to predict the volatility of in the first place? Couple this with a very irregular return, instead of the steady, even inflows of a more common income stream, and the basic financial calculation becomes much more complex than the typical IT analysis. You are best to hook up with a qualified financial analyst and delve deep into the financial functions of your favorite spreadsheet.

3. The panel also brought to light several corollary measurements to ROI, such as the opportunity cost of investing in the data warehouse/data mart system in the first place. In your ROI calculations, you must also present the calculation of what the return would have been had the funds not been invested in your project, but invested in other opportunities. An associated measure is the cost of doing nothing at all. While you're not building a data warehouse system, what is the cost associated with the fact that all of your competitors are?

4. Another metric to ponder is the "functional ROI." This relates to the functions and processes that are altered and enabled by a data warehouse/data mart system. What functions and processes will exist in the enterprise that did not or could not exist before? What is the economic or competitive value of these functions and processes? What is the value of being able to tell good business from bad business, of knowing the exact inventory turn related to promotions, or of understanding the relationships between training programs and accident rates?

While many well-meaning data warehousing teams are quick to quote industry studies that proclaim 400-500 percent ROI for data warehousing systems, you would be well advised to tread carefully on that thin ice. The sample sets were self- selective and the methodology flawed (be sure to read the footnotes). In the end, I believe that a valid ROI measurement for data warehouse systems consists of several measures: pure financial ROI, opportunity cost, "do nothing" cost and a "functional ROI." In the real world, your financial ROI may be 0%, but the overall return of all the measures can easily be well over 100%. Taken together, these measures will allow your enterprise to make an informed decision on the investment in, or the ongoing value of, your data warehouse/data mart system.


For more information on related topics visit the following related portals...
DW Administration, Mgmt., Performance, DW Design, Methodology and Strategic Intelligence.

Douglas Hackney is the president of Enterprise Group Ltd., a consulting and knowledge-transfer company specializing in designing and implementing data warehouses and associated information delivery systems. He can be reached at www.egltd.com.

Solutions Marketplace
Provided by IndustryBrains

SAP Software Migration for Customers
If your current applications are at risk, SAP Safe Passage provides a clear roadmap for solution migration with maintenance support & integration technology. View free demos now!

Design Databases with ER/Studio ? Download Now!
ER/Studio delivers next-generation data modeling. Multiple, distinct physical models based on a single logical model give you the tools you need to manage complex database environments and critical metadata in an intuitive user interface.

Save on Business Intelligence and Data Warehousing
Leverage Open Source database software and PC-based commodity hardware for an unsurpassed price/performance value. ExtenDB transforms the economics in developing a Business Intelligence infrastructure.

OrindaBuild Java source code generator for Oracle
OrindaBuild examines your Oracle database and creates a matching Data Access Object factory class and Web Service classes for your chosen SQL statements and PL/SQL procedures. Fully functional demo version available.

Help Desk Software Co-Winners HelpSTAR and Remedy
Help Desk Technology's HelpSTAR and BMC Remedy have been declared co-winners in Windows IT Pro Readers' Choice Awards for 2004. Discover proven help desk best practices right out of the box.

Click here to advertise in this space

View Full Issue View Full Magazine Issue
E-mail This Column E-Mail This Column
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2005 DM Review and SourceMedia, Inc. All rights reserved.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.