ready to build the future?

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Projects In Healthcare: Improving extraction, reporting and analysis for better lab performance.

Go Back To Case Studies
The Client
Project Category
Data Analytics
Business Intelligence
Metadata Structure
Reporting
Analysis
Industry Vertical
Healthcare | Laboratory Sciences | Lab Director | Lab Personnel
Timeline
Since April 2015

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.

What We Did
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.
Delivered object storage services via Amazon S3
Integration with Epic for a single direction data extract.

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.

Project Scope

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.

From The Client
"InfoMagnus’ solution improves extraction, reporting, and analysis of the necessary data to measure and improve lab performance."
Project Goals

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 Outcome

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.

share the future
want to learn more about how InfoMagnus is changing the technology landscape? reach out!
By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Cookies Policy for more information.