Healthcare // Analytics
News
9/3/2008
07:15 PM
50%
50%

Smart Stuff: The State Of Business Intelligence 2008

Our special report highlights what top companies are doing right with their BI initiatives, and what you can learn from them.

AVOID SPREADSHEET OVERLOAD
To promote the sort of broad adoption that benefitted TSA, BI vendors have been talking up "pervasive BI" and "operational BI" in recent years. Yet these buzz phrases fly in the face of ongoing complaints about their software; in fact, "complexity of tools and interfaces" and "cost of software and user licenses" were ranked first and second by survey respondents as impediments to success.

Vendors have responded to demands to make BI more accessible and user-friendly with Web-based options, including visual dashboards and key performance indicators, that can be embedded within portals or applications. But when it comes to grassroots use of BI, no option has been more deployed than integration with desktop applications, with Microsoft Excel usually the tool of choice. More than half of all respondents, 57%, say they've implemented desktop integration, with 70% of "very successful" companies having done so.

Desktop integration projects are typically one-way, supporting automated and on-demand delivery of pre-set metrics, alerts, and reports. Those can even include raw data extracts from a central repository, generally a data mart or warehouse but sometimes an operational data store or system of record, such as ERP.

Truly interactive tools have been slow to come. Within the last year, vendors including Microsoft and SAP's Business Objects unit have added two-way integration functions that let authorized users edit or revise information in Excel and then update the central repository. The latest integration advances also allow for refreshing data in linked Excel-, Word-, and PowerPoint-based reports and presentations when they're opened, so users don't have to manually update their documents. Oracle became the latest to add this capability with a BI platform upgrade announced in July.

But the real art in exploiting desktop integration, as well as dashboards, is coming up with user-friendly presentations that help people make better decisions. At Esselte, a $1 billion-a-year manufacturer of office supplies, that meant creating visual, dashboard-like presentations formatted for Excel. "The last thing we wanted was for people to see spreadsheets with tons of data," says Luis Becerril, a director who oversees reporting at the company's plants and distribution centers.

Esselte pulls data from more than 300 legacy-system reports using mining software from DataWatch that then delivers, via e-mail and the Web, customized Excel-based charts and dashboards geared to specific roles. Becerril says standardization eliminates the problem of "people developing unique reports and coming up with different conclusions in different plants."

chart: BI's Inroads

Previous
2 of 3
Next
Comment  | 
Print  | 
More Insights
Big Love for Big Data? The Remedy for Healthcare Quality Improvements
Big Love for Big Data? The Remedy for Healthcare Quality Improvements
Healthcare data is nothing new, but yet, why do healthcare improvements from quantifiable data seem almost rare today? Healthcare administrators have a wealth of data accessible to them but aren't sure how much of that data is usable or even correct.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest, Nov. 10, 2014
Just 30% of respondents to our new survey say their companies are very or extremely effective at identifying critical data and analyzing it to make decisions, down from 42% in 2013. What gives?
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 16, 2014.
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.