Healthcare // Analytics
07:15 PM

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.

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

2 of 3
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
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
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of July 17, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week to get the "story behind the story."
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.