The Evolution of Business Intelligence
A white paper released this week by The Data Warehousing Institute shows organizations slowly moving toward operational business intelligence. But the journey is sure to present a number business and technical challenges.

  By Antone Gonsalves
Intelligent Enterprise

August 3, 2007
 
     
 

The concept of business intelligence is changing. Once the tools of only tech-savvy business analysts, BI is slowly evolving into a technology that merges analytics and operational processes into a unified whole.

But the road toward operational BI is sure to present a number of business and technical challenges, many of which are outlined in a white paper released this week by The Data Warehousing Institute.

TDWI believes operational BI is the "turning point" in the evolution of business intelligence, and defines it as the ability to deliver information and insights to a broad range of users within hours or minutes for the purpose of managing or optimizing operational or time-sensitive business processes.

That's a long ways from most BI deployments today. The majority of users continue to be business analysts and executives using sophisticated tools to improve the effectiveness of strategic or tactical decisions by analyzing trends and patterns in large volumes of historical data.

While BI will certainly continue to be used in that way, the full value of the technology won't be realized until it merges analytics and operational processes. But delivering BI to everyone from the shipping clerk to the chief executive has its challenges.

TDWI believes operational BI requires a rebuilding of current BI systems, so queries can be returned in seconds, not minutes or hours; reports can be updated dynamically, and the system can capture large amounts of data in near real-time without interfering with the operations of other software. In addition, as BI becomes more critical to operations, better backup and recovery systems need to be in place to prevent long periods of downtime during server outages.

Faced with such a large undertaking, it's no surprise that a lot of organizations are moving slowly toward operational BI. A TDWI survey of 423 corporate IT professionals, the majority of whom were mid-level managers in the U.S., found only a small percentage that claimed to have systems that were "fully" or "fairly" mature. "While a majority of organizations have implemented some form of operational BI, few have mature or sophisticated systems," TDWI said.

Indeed, the departments leading the way in some form of operational BI deployment are the same ones using more traditional BI tools. Those departments include finance, sales, service, and marketing.

For businesses taking BI to a new level, the biggest challenge, according to the TDWI survey, is architecting the system, followed by managing expectations of users, query performance, obtaining funding and working around technology limitations.

To reduce the number of problems, TDWI advises organizations to first define the requirements of the system to avoid building what's not needed. If users only need information that's updated twice a day, then there's no need to spend a lot more money for updates every minute.

In addition, if just-in-time data is needed, then organizations should rethink business processes to take full advantage of the capability. Other pieces of advice include setting reasonable expectations, so business users aren't surprised by results; and training users so they can reap all the benefits of faster data access.

On the technical side, organizations must decide whether to use a data warehouse, and select the right technology from three categories: data acquisition, data storage and data delivery. In addition, systems should be scalable, so they can later handle more users, connect to more data sources, and handle higher volumes of data with increased rates of throughput.

 
     
More Case Studies
Mannington Mills Case Study

Mannington Mills scales with Dell and SAP

Tellabs Case Study

Tellabs pushes virtualization with Dell PowerEdge servers

Acuity Case Study

Acuity streamlines with Dell virtualized servers and storage

Edmunds Case Study

Edmunds.com chooses Dell to support exponential growth

IT Survival Guide: The Art Of IT Spending
InformationWeek
September 29, 2007

More News
Resources
 

New CASE STUDY: Oracle Consolidates On-Demand Hosting Environment on Dell PowerEdge Servers
Read more »

New SQL DEPLOYMENT WHITEPAPER: Deploying Microsoft SQL Server 2005 Business Intelligence and Data Warehousing Solutions on Dell PowerEdge Servers and Dell PowerVault Storage
Read more »

New SQL DEPLOYMENT WHITEPAPER: Deploying Microsoft SQL Server 2005 Standard x64 Edition SP2 with Microsoft Windows Server 2003 Standard x64 Edition with SP2 on Dell PowerEdge Servers and Dell PowerVault Storage
Read more »

POWER SOLUTIONS FEATURE: Business Continuity and Disaster Recovery with Virtualization and Double-Take
Read more »

POWER SOLUTIONS FEATURE: Streamlining Technology Management to Increase Workplace Productivity
Read more »

WHITE PAPER: 3 Key Enhancements to Enterprise Messaging
Read more »

POWER SOLUTIONS FEATURE: Access Everywhere. Business Anywhere. How Microsoft Exchange Server 2007 Makes It Happen
Read more »

POWER SOLUTIONS FEATURE: A Blueprint for Implementing Microsoft Exchange Server 2007 Storage Infrastructures
Read more »

POWER SOLUTIONS FEATURE: The Business of IT: Planning a Strategic Framework for Anywhere Data Access
Read more »

POWER SOLUTIONS FEATURE: Understanding the Architecture and Features of Microsoft Exchange Server 2007
Read more »

 
More Resources