For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Subscribe to
Computerworld 40 years of the most authoritative source of news and information for IT leaders.
Tame the BI Jungle
or
Other Data Mining Stories
|
|
|
|
September 19, 2005 (Computerworld) -- 
Many 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.
| |||||||||||||||||||
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.
|
Print this Story |
|
Send Us Feedback |
|
E-mail this Story |
|
Digg this Story |
|
Slashdot this Story |
|
|
|
|
|
|
 |
|
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 |
 See your link here
|
 |
||||||||
| ||||||||
| ||||||||
| ||||||||
|
Download this Computerworld Report, free for a limited time, compliments of HP.
Long Tail Supplier Collaboration - What's In It For You? 
Read up on the latest ideas and technologies from companies that sell hardware, software and services.
- 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
The Impact of Messaging and Web Threats Messaging, internal and Web-based threats are increasing in number and severity. The risks to organizations large and small are real problems that users and their employers face if they do not establish adequate defenses against this growing variety of threats.Read this Osterman Research paper to learn how organizations must implement a layered defensive strategy to protect against all types of threats and how Sunbelt Software can help. Download this white paper now
|
The Information Management Roadmap
Structured data. Unstructured data. Semi-structured data. It doesn't matter what kind of data it is or where it comes from. Your job is to develop a strategy around Information Management that harnesses any data needed to make business decisions, and to deliver it increasingly in real time. The success of your organization hangs in the balance.
Join Computerworld, SAS, and IDC to learn the best Information Management strategy for your organization.
Watch this webcast now
 |
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
|
