Download PDF
Qlik > Case Studies > QlikView puts important key data permanently in view for Marienhospital
Qlik Logo

QlikView puts important key data permanently in view for Marienhospital

Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Healthcare & Hospitals
Applicable Functions
  • Quality Assurance
Use Cases
  • Predictive Quality Analytics
  • Process Control & Optimization
Services
  • Data Science Services
The Challenge
Marienhospital Gelsenkirchen, a leading academic training hospital in Germany, was facing challenges in amplifying transparency within the clinic to achieve greater efficiency and prepare for the statutory demands of Diagnosis Related Groups (DRG). The hospital was struggling with the efficient evaluation of patient data from diverse information systems. The introduction of the DRG-System for service related accounting in 2003 made it clear to the hospital that they needed to create more transparency within the clinic to achieve greater efficiency in the administration of internal services and to be prepared for the DRGs during annual budget negotiations with the Health Insurance Funds. The limitations of the existing system were reached extremely quickly. The standard evaluation software (Excel) was not capable of effectively analyzing the extensive amounts of data created from 27,000 patients per year.
About The Customer
Marienhospital Gelsenkirchen is a leading academic training hospital located in Germany. The hospital has over 500 beds and ten specialized divisions. The hospital is among the pioneers of IT supported hospital management. The intelligent linking and analysis of diverse information sources not only helps to implement the statutory demands required since the introduction of the DRG-System (Diagnosis Related Groups), but also allows process optimization at every hospital level thanks to the newly created transparency. The hospital serves around 27,000 patients per year.
The Solution
Marienhospital deployed QlikView to 30 employees across 4 functional areas, with the first version of the DRG Analysis application up and running in 3 weeks. Marienhospital now analyzes diagnoses and treatments, materials, bed occupancy planning, IT systems, and BQS quality assurance data – all focused on driving quality improvements in patient care. With QlikView Server and Connector, Marienhospital now easily handles the large data volume associated with 27,000 patient records previously locked in SAP, DRG System and KIS. The team developed the first “DRG View” version themselves, based on the Swedish developed analysis tool, in three weeks. After a couple of mouse clicks, it was clearly apparent that the solution could extract a great deal of additional information from the data pool that proved to be interesting. Selections, for example, can now be made with ease, such as identifying how seasonal factors affect material, budget and bed occupancy planning over time.
Operational Impact
  • Enabled KPI-based management to optimize internal clinical processes.
  • Improved patient care through more efficient control and transparency.
  • Increased productivity during annual audits and budget negotiations.
Quantitative Benefit
  • The accountants previously required approximately 3 weeks for an audit – and now it is finished within 2–3 days.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.