Skip to content Skip to navigation

Data Warehouses: Overcoming Governance, Integration Issues

May 15, 2012
by Jennifer Prestigiacomo
| Reprints
CIOs strategize how to best create a single source of truth to drive analytics
Click To View Gallery

The CIOs who participated in a panel that tackled strategies for creating data warehouses at the Healthcare Informatics Executive Summit on May 7 largely agreed that the main challenges in doing so centered around issues of governance and integration.

“I think that governance for us is still the greatest problem,” said Patricia Skarulis, vice president, information systems and CIO, Memorial Sloan- Kettering Cancer Center. “I mean it in the sense that there are still some areas where [departments] withhold their data from putting it into the warehouse.”

Skarulis, who was part of the “Beyond the Data Warehouse: Strategizing the Use and Analysis of Clinical Data for Meaningful Use” panel, one of several discussions at the HCI Executive Summit last week in Orlando, Fla., said that Memorial Sloan- Kettering Cancer Center in New York City has had a robust data warehouse for more than 25 years, which contains 1.25 million patient records. “We have every piece of information about them that we can put our hands on,” said Skarulis. “We not only know what’s happened to them clinically, we know how long they waited to see a doctor after the initial request for a visit; we know [the amount of time] between a blood draw and when they saw a physician in the office itself, as well as all the financials—what we billed and received. So, we have a very thorough resource used by everyone at the institution.”

Skarulis emphasized the importance of having an institution-wide policy governing data warehouse usage that discourages departments from withholding their data in separate databases. She said that the greatest fear within her organization is that a researcher could make a faulty comparison from using the data when publishing research. She said to mollify opponents, certain departments have been allowed to maintain their own separate databases, which receive feeds from the central data warehouse.

At Children’s Hospital and Medical Center in Omaha, an issue addressed by its governance committee is data definitions, said George Reynolds, M.D., vice president, CMIO, and CIO. Reynolds said that at his 143-bed hospital the governance process mostly focuses on data quality and agreeing on the meaning of the data points like for instance, length of stay, which can be four calculated four different ways.  

Children’s, as a part of its clinical analytics and business intelligence project, and its broader journey towards becoming a data-driven, continuous improvement-focused organization, has a federated data warehouse that feeds more than 40 dashboards to support inpatient care, as well as the organization's affiliated pediatric physician practices, addressing financial performance and system-wide operational issues.

“Each of our dashboards has a champion or group of owners, and they’re developed in an interactive, iterative way, so we can determine what goes in them, and give [users] the rights management for what goes in them, [which] is pretty simple,” said Reynolds. “We’ve done all the front-end work [with definitions], so we don’t spend a lot of time after the fact worrying about what these data points mean.”
Phase two for Children’s will be moving toward a single vendor solution (from the Verona, Wis.-based Epic) for its clinical information systems to provide more integration for its data warehouse.

Rick Schooler, vice president and CIO, Orlando Health, said that his nine-facility regional health system’s executive governance committee creates priorities for next steps for its data warehouse that are based on the institution’s focus on quality, which includes reducing readmission rates and harm events. He said that integration, and the culture shift necessary to drive it, has been difficult for his organization. Orlando Health has invested millions of dollars in automating both its back office and point of care operations, but has yet to have build an integrated location for patient information, Schooler said.

“The problem has been driven by all the disparate technologies that we’ve invested in over the years in hopes that we could tie them all together,” said Schooler. “In our organization this is where the big challenge has been to culturally agree that we are going to begin consolidating all these pockets of business intelligence. We’re actually going to begin consolidating the teams, which means we’re going to have fewer people because we’re going to use common platforms. We’re going to let their focus be on using the information, instead of finding it.”

To bypass some governance issues, Bobbie Byrne, M.D., vice president of IT at Edward Hospital, took what she called a “stealth” approach to creating a data warehouse for her 350-bed hospital in the Chicago suburbs. “I’d seen a whole lot of data warehouses that were 10 years in the making before you ever got anything useful out of it,” said Byrne. “I was certain that we would under-promise and over-deliver.”