Free Newsletters
Technology & Business Daily

InfoWorld
Log-in | Register

Seeing the future with BI

Tedious data mining and static reports have had their day. The new business intelligence applies business analytics to fresh data and puts analysis in the hands of those who need it

By Jeff Angus
August 18, 2005
 

Patterns gleaned from the past should always inform planning for the future. In most enterprises, though, there’s been a serious disconnect.

Free IT resource

TechNet: More ways to know it, share it, and keep it running.

Sponsored by Microsoft

Free IT resource

Attend the SOA Executive Forum: Breaking SOA Bottlenecks SOAExecForum.com/may2007

Sponsored by InfoWorld

Return to special report

DOWNLOAD PDF

Click here to download InfoWorld's special report Business intelligence analytics


For years, business analysts have enjoyed a clear “rearview mirror” picture of the past based on loads of historical data extracted with data-mining tools and massaged with business intelligence reports. The view “through the windshield,” however, has largely been based on siloed, simplified roll-ups of those numbers crunched in desktop spreadsheets. With neither the near-real-time access to granular data nor the tools to analyze it, many significant opportunities or pitfalls looming ahead simply can’t be anticipated.

BI is now filling that gap with new analytical features plus the capability to access a broad, up-to-date array of data sources made available recently through advanced integration technology. Meanwhile, the fruit of that higher-quality number crunching is being delivered to a much broader range of users. Visually informative dashboards and scorecards are multiplying up and down the enterprise.

Much of the latest BI innovation has been driven by the only two consistent growth sectors in the economy: health care and security. Ironically, both sectors are purely overhead functions. Therefore, both must constantly demonstrate their benefit and -- for different reasons -- adapt to events in real time.

Instant Predictive Analysis
“Dashboards certainly are something you can apply to historical data, but they are exciting as a business tool only when you use them in a real-time context,” says Nathaniel Palmer, chief analyst at Delphi Group.

Palmer thinks that advantage is even stronger with the addition of predictive analytics. “It’s hot,” he says, “and over time we’re seeing an emergence of online analysis of the stream of real-time data.”

One organization that has embraced this model is Emergency Medical Associates (EMA), a hospital emergency-room practice with a post-911 “syndromic surveillance” system.

EMA -- which has hospital contracts across New York and New Jersey -- realized that in the event of a biological terrorist attack, early victims would end up at the emergency rooms it runs. With the right systems in place, EMA staff could not only evaluate symptoms at the point of treatment but also keep abreast of what was transpiring at multiple emergency rooms, thereby enabling them to identify possible outbreaks, note the geographic pattern of how they are moving, and broadcast medical knowledge in real time to combat the spread.

Jonathan Rothman, director of data management at EMA, put into place a Business Objects Application Foundation in late 2003. “We might not have done it without 9/11,” he says. “But having done it, we established ourselves as the analytics department for the hospitals -- when we’re working out contracts, we sell them the idea of reports and analytics.” In other words, the same technology used to detect an epidemic is being used to spot trends and analyze treatment effectiveness and customer satisfaction.


Click for larger view.
Retail Intelligence
As opposed to health care and security, home improvement and hardware retailers are not part of an overhead sector. Wafer-thin margins and the ability of a few giant players to sell goods at a loss make the use of BI for defensive purposes essential.

As part of that effort, Christopher Dorsey, CIO of Chase-Pitkin, decided to tackle the rampant pilfering occurring at its Northeast chain stores. Rather than just react to the problem, he says, “We decided we’d do better getting ahead of the curve.”

Dorsey says two years ago their BI system -- built on Hyperion’s BI solution -- indicated that 16 of the stores’ 38,000 items made up half of all the pilferage. Dorsey added analytical capabilities from SPSS and altered processes to get the results Chase-Pitkin was looking for. “Instead of doing inventory on every item during the slowest time of year, we started doing a weekly one of the subset of most-pilfered items during the busy season,” Dorsey says.

The SPSS predictive analytics examined the attributes of pilfered products and then projected the next most likely theft candidates when the current top choices were secured. According to Dorsey, “We moved from reactive to being ahead of them to actually creating prevention. We can predict in real time what the next problem is likely to be" – and take steps to head it off.


Continued
1 | 2 | Next Page » 



 


 
Jeff Angus is an InfoWorld contributing editor. Contact him at jeff_angus@infoworld.com.
 

TOP NEWS:


»  Troubleshooting tool for Java offered
Sun's Java VisualVM open-source technology views apps while they run on a JVM and is billed as all-in-one solution

»  Python backing eyed for NetBeans
Scripting language capabilities of the open-source IDE continue to expand

»  Microsoft sets Windows XP SP3 automatic download for Thursday
The latest service pack for Windows XP will be pushed to Automatic Update at 7a.m. EDT on July 10

»  Real Software, Veryant bolster dev tools
RealBasic, Cobol apps platforms get improvements

»  Microsoft sets hosted-services pricing, irks partners
By offering 38 percent discount to customers who buy entire hosted business productivity suite, Microsoft undercuts partners selling similar services

»  Adobe readying new mashup tool for business users
Mashup interface code-named 'Genesis' will open up desktop 'workspace' combining business application data, documents, analytics, and instant messaging




Develop an integrated management and security strategy
Watch this Webcast and discover a scalable mobile software platform that combines mobile device management, enterprise-to-edge security, email/messaging, and back-office application extension capabilities, to empower employees to do their work anywhere, anytime, on any device. Sponsor: Sybase iAnywhere

»  Click here to view this Webcast
  The Silver Lining: Cloud Computing
This IT Strategy Guide digs deep into cloud computing helping put you ahead of the curve on this hot topic. It explores the differences between cloud computing, grid computing and utility computing and then helps you see where and how each applies to your business. Sponsored by Box.net

»  Click here to download now

- Special Advertising Partners -
WHITE PAPERS
 

» Technology White Papers Library

Technology White Papers by Topic

Technology White Papers E-mail Alert

Find out when the latest white paper is available:
 
 
INFOWORLD MARKETPLACE
 
» BUY A LINK NOW
 

FIND PRODUCTS AND COMPANIES
» COMPLETE PRODUCT GUIDE



TECHNOLOGY INDEX
• Applications
• Application Development
• Security
• Networking
• Wireless
• Platforms
• Hardware
• Data Management
• Storage
• Web Services
• Business
• Telecom
• Professional Services
• Standards

TECH WATCH 


What's the 411 on GOOG-411?
Just as Google has become synonymous with "performing a Web search," 411 is understood to mean "information" -- as in "what's the 411?" I was thus surprised to discover, from a billboard, no less, that the king of search is taking on the ...

Apple HTML source reveals 'iPhone Extreme'
"This one's a stretch..." reports AppleInsider. Um, yeah. Reporting on HTML code sightings of product names could be called a stretch, but iPhone Extreme has a ring to it. Now, that sounds like the product Apple should have released first, rather ...

COLUMNISTS

Unified under law
Ephraim Schwartz's Column and Blog (InfoWorld) - In the litigious world we live in, deploying a unified communications platform in your enterprise could...
» MORE COLUMNISTS

MORE INFOWORLD BLOGS


Open Sources 
Product Management
When I joined MySQL four years ago, there was quite a lot of debate about product management. We didn't actually have ...

Zero Day 
Botnet herders tending smaller flocks
New research backs up the theory that botnet operators are keeping their networks smaller in a continued effort to keep ...



• Advice Line
• Database Underground
• The Deep End
• Enterprise Mac
• Geeks in Paradise
• Grid Meter
• The Gripe Line
• InfoWorld Daily
• Inside IT
• IT Troubleshooter
• ITXtreme
• Open Sources
• ProdBlog
• Real World SOA
• Reality Check
• Security Adviser
• SMB IT
• The Storage Network
• Tech Watch
• Virtualization Report
• Zero Day

ADVERTISEMENT


RESOURCE CENTERadvertisement 

GOVERNMENT IT & POLICY
'If you don't go after the network, you're never going to stop these guys. Never.'
From the State Department, All the News for Inquiring Minds
TechPresident, the Internet Citizenry's New Consensus Taker



Sponsored Technology Links

 
 
 HOME  NEWS  BLOGS  PODCASTS  VIDEOS  TECHNOLOGIES  TEST CENTER  EVENTS  CAREERS   About | Advertise | Awards | RSS | Contact Us 

Copyright © 2008, Reprints, Permissions, Licensing, IDG Network, Privacy Policy, Terms of Service.
All Rights reserved. InfoWorld is a leading publisher of technology information and product reviews on topics including viruses,
phishing, worms, firewalls, security, servers, storage, networking, wireless, databases, and web services.

CIO :: ComputerWorld :: CSO :: Demo :: GamePro :: Games.net :: IDG Connect :: IDG World Expo
Industry Standard :: IT World :: JavaWorld :: LinuxWorld :: MacUser :: Macworld :: Network World :: PC World :: Playlist