Qlik Case Studies QlikView puts important key data permanently in view for Marienhospital

Edit This Case Study Record

	QlikView puts important key data permanently in view for Marienhospital Qlik

QlikView puts important key data permanently in view for Marienhospital

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Healthcare & Hospitals
Applicable Functions	Quality Assurance
Use Cases	Process Control & Optimization Predictive Quality Analytics
Services	Data Science Services
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Healthcare & Hospitals

Applicable Functions

Quality Assurance

Use Cases

Process Control & Optimization

Predictive Quality Analytics

Services

Data Science Services

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 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.

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.

Impact #1	Enabled KPI-based management to optimize internal clinical processes.
Impact #2	Improved patient care through more efficient control and transparency.
Impact #3	Increased productivity during annual audits and budget negotiations.

Impact #1

Enabled KPI-based management to optimize internal clinical processes.

Impact #2

Improved patient care through more efficient control and transparency.

Impact #3

Increased productivity during annual audits and budget negotiations.

Benefit #1	The accountants previously required approximately 3 weeks for an audit – and now it is finished within 2–3 days.

Benefit #1

The accountants previously required approximately 3 weeks for an audit – and now it is finished within 2–3 days.

Download PDF Version

Overview

QlikView puts important key data permanently in view for Marienhospital

Operational Impact

Quantitative Benefit