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

View all Portals

Scheduled Events

White Paper Library
Research Papers

View Job Listings
Post a job


DM Review Home
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

Buyer's Guide
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

About Us
Press Releases
Advertising/Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Information Management: Charting the Course:
What About Forecast Data?

  Column published in DM Review Magazine
September 2003 Issue
  By Bill Inmon

The traditional use of a data warehouse has been to store historical data. Stored at both the detailed level and the summary level, data warehouses provide a description of what has happened in the past. Historical data may be used to look at the forest and the trees, look at customer trends and provide a basis for asking "what if" questions, among other things.

Data warehouses are unique in that they recognize that data is captured and stored over a panorama of time. Contrast a data warehouse's recognition of the element of time with that of OLTP (transaction-based) systems. In OLTP transaction-based systems, the only time that matters is right now. In transaction-based systems you ask such questions as:

  • How much money do I have in my account right now?
  • What insurance coverage do I have right now?
  • How many seats are available on an airplane flight right now?
  • What is the status of the order right now?

All questions are phrased in terms of the value of information right now. Transaction-based systems focus almost exclusively on the most current up-to-the-second status of data. They spend a lot of energy on guaranteeing the accuracy of information that is current.

However, what about other forms of time? Can a data warehouse be used to hold other forms of time variance? The answer is yes. A data warehouse can be used to hold future information, such as forecast information, as well as past information.

Like other information in a data warehouse, the forecast can be made at different levels of granularity (i.e., the forecast can be made in terms of days, weeks, months or years). The specifics of the frequency of the forecast depend entirely on the nature of the business of the entity that is being forecast. Making an annual forecast for the amount of bubblegum that will be manufactured hourly doesn't make much sense. Nor does an hourly forecast of annual revenue make sense.

One of the most innovative uses of forecasts is that of periodically comparing forecast data to actual usage data. For example, suppose an energy company makes a monthly forecast for the usage of natural gas. Then, as each month passes, the company tracks the difference between what has been forecast versus what has been actually used. In so doing, the company can start to get a handle on how reliable their forecasts are.

By making a monthly comparison between actual and forecast, an organization can start to understand what variables they are subject to. Consider an energy company, for example. The energy company records variables are used to shape their forecast including:

  • the El Nino weather pattern,
  • the number of new residents in a state,
  • the number of new businesses in the state,
  • the number of high-consumption businesses in the state,
  • the number of new students in the state, and
  • the number of total students in the state.

Once the correlation between the forecast and the actual is calculated, the organization can start to understand what variables the organization is sensitive to and what variables the organization is not sensitive to. In doing so, the organization can start to shape the forecasts ever more accurately.

Multiple forecasts are also useful. The multiple forecasts can be done by different individuals or by sensitivity to different variables. On a monthly basis, the variables can be compared to the actuals to create a confidence index for each forecast. For a forecast that is consistently off, the confidence index will be low. For a forecast index that is consistently close, the confidence index will be high. Forecasts may be both short term and long term.

Once the forecasts are made, as time passes, they become history and are integrated into the historical part of the data warehouse.

The data warehouse designer does not have to be limited to forecasts. Budgets can be treated the same way.

The addition of forecast and budget data to the data warehouse environment can add a dimension of information that rounds out the historical and current information that is found there. Interestingly, tracking the difference between actual and forecast can provide major insight into how to make better forecasts in the future.


For more information on related topics visit the following related portals...
DW Basics.

Bill Inmon is universally recognized as the father of the data warehouse. He has more than 35 years of database technology management experience and data warehouse design expertise. His books have been translated into nine languages. He is known globally for his seminars on developing data warehouses and has been a keynote speaker for many major computing associations. For more information, visit www.inmongif.com and www.inmoncif.com. Inmon may be reached at (303) 681-6772.

Solutions Marketplace
Provided by IndustryBrains

Data Validation Tools: FREE Trial
Protect against fraud, waste and excess marketing costs by cleaning your customer database of inaccurate, incomplete or undeliverable addresses. Add on phone check, name parsing and geo-coding as needed. FREE trial of Data Quality dev tools here.

Speed Databases 2500% - World's Fastest Storage
Faster databases support more concurrent users and handle more simultaneous transactions. Register for FREE whitepaper, Increase Application Performance With Solid State Disk. Texas Memory Systems - makers of the World's Fastest Storage

Manage Data Center from Virtually Anywhere!
Learn how SecureLinx remote IT management products can quickly and easily give you the ability to securely manage data center equipment (servers, switches, routers, telecom equipment) from anywhere, at any time... even if the network is down.

Design Databases with ER/Studio: Free Trial
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.

Free EII Buyer's Guide
Understand EII - Trends. Tech. Apps. Calculate ROI. Download Now.

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) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.