When you're talking about business intelligence, there's an underlying assumption that's not always obvious," says Jonathan Einbinder, M.D., corporate manager of clinical informatics research and development at Boston-based Partners HealthCare System. "Data has strategic value beyond its original use." In recent years, hospital executives have been tapping various forms of business intelligence to utilize their data to stay ahead in an increasingly competitive world. But is business intelligence (BI) something new, or is it just increased reporting capability under a fancy name?
"Gartner was using the term business intelligence 17 years ago. It's hot now because it takes time for these things to mature," says Kurt Schlegel, a consultant with Stamford, Conn.-based Gartner Inc. Operational reporting for a particular business process traditionally went directly against the data source of the application to do reporting but, according to Schlegel, that has become too limiting. "Insightful reports need to tap into the secondary uses of data."
Einbinder agrees. "If you're looking for a system, be it clinical or otherwise, you should be thinking about using the data for secondary purposes. How are you going to get the data out? What data needs to be captured in a reliable, high-quality way? If you don't think about that up front, reporting is often an afterthought, and you're up the creek without a paddle," he says.
The profit motive drove many of the enterprise resource planning (ERP) models that have been in use for years. The difference between ERP and BI is that the ERP models traditionally are more core business oriented, including materials management, payroll, general ledger, billing and accounts payable. Adding clinical information in a way that allows for interoperability in reporting is how most view BI today.
But isn't it possible just to run reports off an application? "I feel very strongly you don't report off the applications," Einbinder says.
Schlegel agrees. "You have more due diligence that the data is correct when using a data warehouse than when going directly from an application. To build reports that are more insightful they need to be based upon multiple domains and that's where the data warehouse is born," he says.
The data warehouse is a retrospective way to combine data across multiple sources — it's a way to aggregate and combine information in a manner that makes sense. Partners reuses information captured in the clinical information systems for secondary use: reporting quality improvement, research, clinical understanding and population management. "Our clinical data has strategic value — the treatment, payment and operations," says Einbinder. "A lot of data is captured due to all those processes. One way to think of it is focusing on populations instead of the individual."
Most say the retrospective view of a data warehouse is sufficient to make informed business decisions. "For looking at quality or trying to understand practice patterns, having real time data is not that important — and the closer to real time you get, the more expensive it gets," he says. "There's usually a sweet spot where you try and optimize for your business purposes. Are people doing real time data warehousing?" Einbinder says. "The short answer in healthcare is, no."
But with so many sources of data, from clinical and business information systems, is a single data warehouse necessary or can a good BI system run off multiple domain-specific data warehouses? And can IT systems like Lawson and Oracle provide enough interoperability to achieve BI? For the time being, anyway, they may have to. "A lot of your mid-sized hospitals don't even have data warehouses," says Schlegel. "And technically it is possible to integrate data." That's especially true with the siloed systems most hospitals have today.
"There are lots of reasons for the silos," says Mychelle Mowry, vice president at Oracle. "Every department wants a different kind of product because it has their little bells and whistles. Organizations have legacy products that they've put a lot of money into and they're not ready to dismantle those and go into an expensive and lengthy implementation of a new product." She says what's really required are tools to pull data into one data store that's appropriate for business intelligence. "However," she adds, "That is a lot easier said than done."
A data warehouse facilitates BI at Brigham and Women's Hospital, part of Partners, for what executives call a "balanced scorecard initiative." With over 70 feeds, it's viewed as one stop shopping for management and users. "What we've done successfully here is a partnership with information systems and the clinical decision support group," says Sue Schade, CIO of Brigham. Schade says there are four quadrants to the scorecard — financial, external to customers, internal to employees and lastly, operations, quality and efficiency. "You've really got to look at your performance in a balanced way and use the key metrics within all those quadrants." For the balanced scorecard, Brigham defined key metrics on an institutional level and drilled down to the departments. "You're always comparing apples to apples," Schade says. "And if you have questions, every indicator has an owner." Brigham is using a SAS (Cary, N.C.) data warehouse sitting under their balanced scorecard with 70 data feeds.