Diakonie-Klinikum Stuttgart uses DeltaMaster for analyzing and reporting medical key figures from the phoebus data warehouse.

Diakonie-Klinikum Stuttgart was looking for a business intelligence solution to improve the evaluation of medical data, and PHOEBUS IT Consulting had just the right prescription. PHOEBUS has specialized in data warehouse solutions for the healthcare industry for over ten years. Its product range includes phoebus  portal, an end-toend controlling solution for hospitals  and clinics with integrated cost unit accounting. The modular controlling platform enables ad hoc analyses and standardized reporting using data from all departments.

The concept: Data from the operating systems – e.g.  the hospital information system, the laboratory  system, or financial accounting – is processed in a data warehouse and made available as a multidimensional data pool. Microsoft SQL Server is used as the  database system. The front-end for analysis and reporting is provided by the DeltaMaster BI solution from Bissantz.

“A data warehouse can only develop its full potential if the figures it contains are prepared in such a way as to be usable by a broad audience,” explains Arne Schnabel, Managing Director of PHOEBUS IT Consulting. “The figures must be visualized clearly and in a way that meets the needs of the individual users.  This is precisely what DeltaMaster does so well.”  DeltaMaster’s Hyper Browser sheds light on even complex structures quickly and reliably. Users drag and drop to color the data model according to the key figure transferred. This also has the effect of directly  highlighting hidden compensation effects. Graphical  Tables – pivot tables whose numerical values are supplemented by bars, columns, circles or sparklines – make even number-heavy reports intuitive to  understand. Interactive cell graphics such as the  zoomable sparklines provide more details on a case-by-case basis with each magnification level. Simple color coding makes it clear at first glance whether a key figure has a positive or negative effect on earnings.

Diakonie-Klinikum Stuttgart was immediately won over by the combination of the phoebus data  warehouse and DeltaMaster.

The hospital’s medical key figures are based on data from the hospital information system Nexus and subsystems, including an endoscopy/gastroscopy IT solution and software that records the results from heart catheter measuring stations. Typical key figures include the case mix index, bed utilization, the proportion of private patients, and the average length of stay. In reports, sparklines and diagrams are used to present the development of these values over time.

“Surgery utilization is particularly important for us,” adds Katrin Malisi, responsible for Controlling at Diakonie-Klinikum Stuttgart: “One of our main aims is to optimize surgery planning, i.e. the occupancy of operating rooms. Together with beds, this is one of the most notorious bottlenecks at our hospital. We use DeltaMaster to prepare various reports that give doctors the transparency they need for better planning.” The reports give answers to questions such  as: How many operations are performed per department and in which rooms? At what time in the morning is the first incision made on average? When is the first patient wheeled in in the morning? When is the last suture tied off at night? What is the average turnaround time (incision–suture time)? This is one of  the most important figures, as it provides information on how long the operating room is unavailable between two operations while it is cleaned and made ready for the next operation.

When it comes to staff planning, nursing management can consult standard reports showing the duration of nursing care according to the nursing staff regulation (PPR minutes), which enables a comparison of utilization in the individual wards. The complex care measures score (PKMS) is also shown.

To improve the case success rate with the Health  Insurance Medical Service (MDK), the proportion of MDK queries, the number of disputed cases won and lost, and the department. “The MDK often raises doubts as to the operation and procedure codes used,” explains Malisi. “Among other things, the information from the analyses helps us to understand where we need to improve our documentation in order to respond to these doubts. For example, we can tell the outpatient department to include diagnostic measures such as radiographs directly in the outpatient treatment report.”

Sixteen different reports are currently in use. Recipients including senior consultants and nursing  management can use their web browsers to access the  reports, which are tailored to their information requirements.

“The Controlling team at Diakonie-Klinikum Stuttgart is largely independent when it comes to developing  reports and analyses,” Malisi says. “We were trained in PHOEBUS in ten two-hour training sessions. Role management is also handled internally. PHOEBUS is available to provide support when things get more complex.”

• Data warehouse as single point of truth
• Ad hoc analysis and standardized reporting using a single tool
• Recipient-specific reports
• Fast implementation thanks to predefined key figures and analyses
• Web-based access to reports
• Report and analysis development and role management even without external support

• Hospital in Stuttgart and academic teaching hospital of the University of Tübingen
• Seven main departments, one inpatient ward, psychosomatics unit and psychosomatics outpatient clinic
• 400 beds, including 18 in the psychosomatics unit and 12 places in the psychosomatics outpatient clinic
• Number of patients treated in 2016: 17,000 inpatients, 70,000 outpatients