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 Warehousing Horizons:
Data Warehousing: What the Future Holds

  Column published in DM Review Magazine
November 2001 Issue
  By John Onder

Within a year, the overall information technology industry has gone through a major upheaval. How has this affected our marketplace, and what does the future bring for those that specialize in the data warehouse (DW) and business intelligence (BI) space? This article is a series of observations and thoughts based on the experiences with Headstrong's customer base in our Digital Intelligence Practice.

Many changes are looming on the horizon for our industry. First is a focus on the return to basics - drive revenue, cut costs, and acquire and retain customers. C-level and board applications are moving to displace departmental applications as the starting point for data warehouse development. The reasons are many and varied and include the maturing of departmental applications, the overall return to sound business basics after the dot-com boom/bust and the ever-important focus on the customer and on shareholder value.

Other trends indicate that the future will bring a level of complexity and business importance that will raise the bar for all of us. The real-time implementation of a business action, decision or change of direction that is based on the results of strategic data analysis is now the reality. The data issues surrounding this trend aren't getting any easier or smaller. Combine the need for real-time data warehousing and increased data size and complexity, and we set the stage for a new type of warehouse - the "virtual" enterprise data warehouse. This virtual DW or private hub for both operational and informational needs will begin to drive new demands on the ability of organizations to assimilate vast data assets stored in merged/acquired companies or divisional enterprise resource planning (ERP) and legacy environments. The time and/or dollars needed to integrate all the operational systems will make the traditional method of data integration impractical. This intersection of Web channels and data warehousing has the potential to become the standard architecture for large, complex organizations.

Next, it is without a doubt that the entire customer relationship management (CRM) explosion is driving a large portion of the current data warehouse projects in the industry. But is this really new? I've always stated that those of us who are veterans in the DW world were building and running CRM environments before there was an acronym for CRM. Furthermore, we are definitely seeing a reverse evolution in the CRM space, which accentuates the importance of analyzing and measuring the effectiveness and efficiency of operational CRM capabilities. Continuing on the theme of measurement, remember the executive information system (EIS)? The EIS was the easy-to-use, show-me-the-numbers application directed at the senior business management of a company. The intent of an EIS was to make the key performance indicators essential to running a business available at the touch of a button. These applications were the rage in the mid-'80s. The EIS lives again as the digital dashboard. All the leading online analytical processing (OLAP) software vendors have developed or are in the process of developing key performance indicator modules; and many dashboard-specific vendors are starting up and/or growing rapidly.

Lastly, the complete scope of the organization, structure and processes needed for a successful customer deployment of a large, complex data warehouse continues to be a major problem for most organizations. Making it happen successfully takes a unique focus and team of people. Mainly, the ability of an organization to change or dispose of the conventional wisdom regarding the correct mix and role of staff is important. Regarding this topic, I have the following observations. Your customer deployment team structure must mimic your desired business goals; and the team should reside within the same space - business operations, business analysts and IT professionals need to learn to cohabitate. Training must go beyond basic tool training to include pure business solution analysis tied to the desired outcome. Tight tracking and measurement of the expected business return has to be easily understood and continually revisited against expectations. Include in your engineering of the customer deployment shop not just what the team members will do, but how they will do it. What process can be made repeatable, scalable and flexible enough to change with the business?


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

John Onder, a partner in Chicago Business Intelligence Group (CBIG), has extensive experience in all facets of providing information technology services, business reengineering, system assessment and planning services. He has in-depth expertise in business planning and practical implementation of business intelligence and data warehouse applications across many industries. CBIG is a full service, vendor-independent DW/BI consultancy staffed by senior level professionals. Onder can be reached at john.onder@chicagobigroup.com or (773) 477-8783.

Solutions Marketplace
Provided by IndustryBrains

SAP Safe Passage for Current 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.

Data Mining: Strategy, Methods & Practice
Learn how experts build and deploy predictive models by attending The Modeling Agency's vendor-neutral courses. Leverage valuable information hidden within your data through predictive analytics. Click through to view upcoming events.

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.