Delivering a data solution to improve extraction, reporting and analysis.
For 40 years, Epic has worked at the intersection of health care and information technology to connect people and systems around the world.
They use the latest technology to create solutions that let communities and people engage in their own health. Whether they are supporting the clinical, financial or operational areas of a hospital or health system, Epic’s tools are designed to work for today and think for tomorrow.
Epic supports its clients by surfacing data that enables them to make informed decisions for better management of operations, while arming their clinicians with the information they need to provide smarter care.
With the data solution developed by InfoMagnus, a large healthcare provider was able to access actionable information and help improve performance measurement and the efficiency of laboratory services.
The business challenge: To improve the efficiency of laboratory services.
Measuring performance at a granular-level has been a challenge for this client based on the complexities of “slicing and dicing” data from Epic.
Users often have a difficult time gathering the data they need. They must go through multiple, time-consuming cycles of report generation, make manual adjustments, and calculations to ready the data for analysis.
In addition, system performance is degrading based on the continuous increase in the size of the database.
InfoMagnus’ solution improves extraction, reporting, and analysis of the necessary data to measure and improve lab performance. The iLab platform extracts, transforms, and loads data from Epic into a large Oracle database.
SAP Business Objects Tools are used to simplify and improve data access by creating a metadata structure. SAP’s Web Intelligence accesses the metadata to create actionable reports. This solution allows for more detailed data analysis than Discern, the reporting tool provided by Epic.
As the database size increases, the Oracle database will be transitioned to Hadoop for better performance. Tableau and PowerBI are also used for Dashboard applications.
iLab has more than 200 users accessing the reporting platform via a web link at 18 hospitals and 33 labs. The system accounts for thousands of patients and tens of thousands of lab tests.
Major users are the Regional Lab Director, Lab System Managers, and Lab Data personnel. This project includes general Lab, Blood Bank, and Microbiology labs. There are plans to add more by the end of the year.
The access to actionable information is helping to improve performance measurement and the efficiency of laboratory services. Reports that took hours to produce now take mere minutes. Specimen turn-around-time is being more accurately measured and reported.
Performance can now be measured at the lab location, technician, and device level. Measurement allows leaders to leverage areas of excellence and work on areas needing improvement.
This project has also improved the working conditions of lab personnel since broken equipment is found and fixed more rapidly. Since Epic is a leading application in the industry and this data reporting and analysis problem is common, this solution can be implemented for any department running similar health information and EHR technologies.