Subscribe to our e-mail newsletters
For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Data Management
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
More E-Mail Newsletters 
Computerworld 2007Subscribe to Computerworld
40 years of the most authoritative source of news and information for IT leaders.

Tame the BI Jungle

A single set of BI reporting tools can bring order to the chaos.
Heather Havenstein   Today’s Top Stories    or  Other Data Mining Stories  
 

Sign up to receive Security Resource Alerts

September 19, 2005 (Computerworld) -- Return to the Special ReportMany companies are eager to make sure data gathered from business intelligence tools gets into the right hands. Although the power user normally gets the benefit, the real value is in pushing BI data out to frontline workers for operational decision-making and up to executives for strategic adjustments in the direction of the business.

However, to successfully obtain the "one version of the truth" needed to exploit BI data for decisions that might affect daily operations, many companies find they must first eliminate multiple redundant BI tools and instead embrace a standard set of tools.

Five years ago, for example, Del Monte Foods Co. began an assessment of its BI and analytic tools to determine the company's strengths and weaknesses and develop an approach for enterprise BI. The San Francisco-based company found it had six different query and reporting tools, says Andy Wojewodka, Del Monte's director of business systems and decision support. "It was almost like whatever package that addressed transactional systems had a reporting tool bolted onto it," he says. "People were going off and developing their own reports. There wasn't any cohesiveness, and we ended up with numerous versions of the truth."

In late 2004, Del Monte decided to use Cognos Inc.'s Cognos Enterprise BI tools for business and production reporting and data analysis. In May, the company rolled out the first phase of its Cognos deployment to sales, marketing and finance users for a project to enable trade spending analysis. By the end of the year, the company will have 600 users on the system, Wojewodka says.

Del Monte has built a single Oracle enterprise data warehouse with information to support BI inquiries companywide. In addition, the company has layered Cognos analytics on top of the warehouse to provide interactive dashboards for executives.

"The business owner has a dashboard available where they can assess how they are trending and then can quickly link... with additional information to answer questions they may have so they can take action," Wojewodka says.

From Manual to Meaningful
Like many other companies, Cross Country Healthcare Inc. needed to standardize BI in order to bolster visibility and interpret data generated by different back-end transactional systems. Before standardizing on Business Objects SA's XI platform earlier this year, Cross Country was using tools from Cognos, Microsoft Corp. and other vendors to perform queries in silos based on the platform, says Kip Vann, CIO of the Boca Raton, Fla.-based medical staffing company.

"It took an act of Congress to get anything meaningful to the business, [and] every request required manual intervention with spreadsheets," he says. "We couldn't get a full view of the customer."

Although Cross Country hasn't completed projections of its return on investment from the standardization, Vann says 60% of requests to the company's IT department require information reporting. The company has consolidated its support staff around XI, which justifies the cost of the software, he adds.


Seven Tips for Consolidating BI Tools
1 Build a strong case for displacing existing tools.
2 Build trust between users and the IT department.
3 Develop tool preference based on concrete selection criteria.
4 Create an acquisition process that requires approval from a BI competency center before buying new BI licenses.
5 Establish internal user groups to help promote standard tools.
6 If users refuse to cooperate, introduce a BI usage policy.
7 Prove to the business on a recurring basis that its needs can be met with standard tools
SOURCE: Gartner Inc., Stamford, Conn
Pearl River Resort, which operates a resort and casino in Mississippi, uses a Unix-based system to track slot-machine activity and an IBM AS/400 system to track other guest gaming habits; different databases track guest buying behavior at its water park, hotels and restaurants.

Before turning to a BI system from Cary, N.C.-based SAS Institute Inc., the company was using AS/400 querying tools or Access databases connected to source tables to generate reports about guest behavior, says Jason York, director of database marketing and special projects at the Choctaw, Miss.-based company.

"To get information on our guests from a gaming standpoint was very labor-intensive and required a lot of technical knowledge about the different operational systems," York says. "There were performance issues with regard to getting at the data. Everybody was looking for specific information that was unique to their area, and more and more questions began to arise." Since launching the SAS tools, Pearl River has reduced the time it takes to answer a simple query about guest behavior from several weeks to one day, he adds.

Smooth Transition
The cost and complexity of maintaining multiple BI tools is the main driver for most organizations to consolidate, notes Dan Vessett, an analyst at IDC. However, enterprises need to be aware that the biggest obstacle to standardizing is end-user reluctance to give up tools they are accustomed to using, he adds.

"One way to get around that is to make sure the new interface matches exactly or as closely as possible whatever end users were used to seeing in their old applications," he says.

But for those companies that have successfully migrated to a single tool set, the benefits can be substantial. For example, La Petite Academy Inc., a Chicago-based company that operates 650 preschools, has been able to lower its labor costs by 10% to 20% since replacing reporting tools included in its AS/400 and SQL and Access databases with an enterprise BI system from Information Builders Inc.

Before using WebFocus, the company's IT staff had to monitor multiple reports, since the company imported financial and operational field data from each location, says Chuck Mason, La Petite's senior business intelligence analyst.

"It was difficult for our operational staff to coordinate efforts when issues occurred," he says. "Our solution was to provide a simple daily report that monitors and provides updates on our nightly import processes from all our academies. This provides our staff one report to monitor and use to investigate any outstanding data issues, instead of having to track down issues across several machines and reports."

For many companies, reducing the number of tools used to extract data from back-end systems is a key step toward relying on BI as a mission-critical application. And though they might encounter user resistance along the way, those that persevere have found the benefits of reduced cost and complexity worth the effort.

Special Report


Smarter BI
Stories in this report:



Print this Story Send Us Feedback E-mail this Story Digg! Digg this Story Slashdot this Story
Tame the BI Jungle
"We don't need al-Qaeda to blow us up. We are perfectly capable of lighting the fuse ourselves, courtesy of our..." Read more...
"Analyzing data from online and your network may be a little easier because of a new browser. Yes, a browser...." Read more...
Read more Business Intelligence posts or See all Blogs
HP confirms XP SP3 endless reboot snafu, promises patch
Yahoo tells Icahn that its own board knows best
Tools circulate that crack Debian, Ubuntu keys
More top stories...
Former Microsoft manager offers free fix for XP SP3 'endless reboot'
Can Icahn take on the Yahoo board and win?
DNS trouble knocks NSA off Internet
Specialists have retrieved about 99% of the data on a disk drive on board the crashed space shuttle Columbia. Don't miss the photographs of the recovered drive.
These big ideas were supposed to revolutionize technology, but they never actually appeared. In a few cases, you'll be glad they didn't.
Nearly 20 years after the first Internet worm, Steven J. Vaughan-Nichols takes stock of the malware/anti-malware landscape and spotlights how the two sides are approaching the battle.
Though some thought it was released too soon, Mac OS X 10.5 has matured into a solid operating system, says reviewer Michael DeAgonia.
Reviews, analyses, how-tos, visual tours, hot issues and predictions about Microsoft's new OS.
Four years from now, the IT field will be a vastly different place. Will you be ready?
All Zones
Application Performance Zone
Enterprise-Class Security Zone
Enterprise Solutions Zone
The File Data Management Zone
Grid Computing on Windows Zone
Security Management Zone
ITIL Best Practices Zone
The SAS Zone
Storage Virtualization Zone
The Data Center Management Zone

Ads by TechWords

See your link here
Computerworld Report: Virtual Reality
Download this Computerworld Report, free for a limited time, compliments of HP.
(Source: Computerworld) The data center is real, but storage is turning virtual at many organizations that need to manage exploding storage needs. Learn how virtualizing your enterprise will save you money in this Computerworld Report, a $49.95 value, available free for a limited time, compliments of HP.
Download this executive briefing download
Managing B2B Web Channels For Success
Download this survey results white paper for free, compliments of Tealeaf.
(Source: Tealeaf) In March 2008, Computerworld invited Web site visitors to participate in a survey regarding their organizations' use of the Web. Specifically, the goal of the survey was to better understand organizations' goals and priorities for their B2B Web channels in 2008. The survey was commissioned by Tealeaf, but data was gathered and tabulated independently by Computerworld Research. The following report represents top-line results of the survey conducted among 250 respondents at organizations that leverage the Web for B2B commerce or self-service.
Download this white paper go
Long Tail Supplier Collaboration - What's In It For You?
Long Tail Supplier Collaboration - What's In It For You?
Download this webcast, free, compliments of Sterling Commerce
Go to the webcast 
White Papers
Read up on the latest ideas and technologies from companies that sell hardware, software and services.
Six Support Issues That Keep Execs Awake at Night
Spam Spikes: A Real Risk to Your Business
The New Foundation of Storage: Xiotech's Intelligent Storage Element
View more whitepapers 
SAS Information Management Kit

SAS is the leader in business intelligence and analytical software and services. Only SAS offers leading data integration, storage, analytics and business intelligence applications within a comprehensive enterprise intelligence platform. SAS gives 97 of the top 100 companies in the 2007 Fortune 500 THE POWER TO KNOW®.

Webcast: The Information Management Roadmap
Imagine high-quality data, cleansed, analyzed and delivered throughout your organization. Join Computerworld, IT visionary Thornton May and a panel of experts to learn how SAS® can help you make it happen.

View this webcast 
Research Report: Information Management Initiatives at Midsize and Large Organizations
See the top-line results of this Computerworld sponsored survey to see how IT and business leaders are handling information management implementation.

Download this report 
White Paper: Information Management: Better Information for Winning Decisions.
This white paper explains how the SAS Information Evolution Model aids companies in assessing how they use this information to make strategic decisions and drive business.

Download this white paper