Managing more than half a million patient visits annually at three hospitals and 16 neighbourhood locations, Children’s Healthcare of Atlanta (CHOA) is one of the largest clinical care providers for children in the USA.
As an organization committed to enhancing the lives of children through excellence in patient care, research and education, CHOA wanted to ensure that its doctors, researchers and management team were always armed with the right answers for informed and precise decision making. But years of providing analysis and reports with nearly all of the leading Business Intelligence (BI) platforms had left the CHOA BI team with expensive implementation schedules, scope reductions and a dissatisfied user base, which ultimately led to a strained relationship between IT and Business.
Meanwhile, CHOA’s cardiology unit, Sibley Heart Center Cardiology, evaluated and selected QlikView to replace IBM Cognos. When CHOA management saw that Sibley users were able to run reports and analysis in minutes rather than waiting a week for answers, they decided to conduct a proof-of-tool project with QlikView partner IPC Global.
“Working with the QlikView development team from IPC Global, we were able to extract data, create business logic and provide a presentation layer that made the end users happy. And we did it in 30 days – a fraction of the time it would have taken with any of our other tools,” explained Michael Thompson, Director of Business Intelligence, Children’s Healthcare of Atlanta.
Upon selecting QlikView, the CHOA BI team first set out to replace — and improve — the existing financial reporting process. Because achieving revenue cycle success requires management decisions based on projections, actual performance and trending analysis, CHOA developed a dashboard that would provide a holistic view of revenue management. The dashboard integrates records from four different data sources, all updated daily.
Equivalent to the information previously available in 50 different static reports, CHOA executives, directors and managers now have a single view of revenue billed each day, by each of its three hospitals, by each service line within those hospitals, by sub-service line, and against targeted goals, disease codes and acting physicians. Before QlikView, each report would have taken approximately 30 hours to build. Now, all of that detail — and more — is available in a dashboard that was built in a month.
As one of the largest hospital networks for children’s visits in the U.S., CHOA is a pre-eminent research enterprise for pediatrics. Integrating data that dates back to 1985, QlikView now enables CHOA research users to query across multiple databases for population identification, diseases, demographics, visits, lab orders and results.
In the past, researchers and physicians had to wait 4-6 weeks for the reports and detail they needed for their grant proposals. Today, they can instantly access a portal that offers a complete picture of the clinical experience, especially the diagnosis-treatment-outcome relationship, and better target research studies. Users can even bookmark each query for easy access once a grant is approved.