Visualizing Hospital Management Data in R Shiny-A Case Study

There is a demand to make hospital management information beyond basic key performance indicators (KPIs) accessible for clinicians.

We developed an interactive application (IAPP) in R Shiny to visualize such information. We provided the IAPP source code online. As a use case, we recorded basic KPIs (numbers of patients (NPs), reimbursed valuation ratios (RVRs), mean length of stay (LOS)), main diagnoses (MDGNs), main procedures (MPRCs), and catchment area (CA) by district from April 2022 to March 2024 at the index department in central Germany, where a neurotrauma and spinal surgery service was resumed on 1 April 2022. Case mix indexes (CMIs) were calculated. We retrieved information about online-reported patient satisfaction (ORPS) from an online physician rating platform between January 2022 and March 2024. Information on longitudes and latitudes of the index department and neighbouring hospitals was collected. We calculated car travelling isochrones (CTIs) of the hospitals as a proxy variable for accessibility. Chi-square and Fisher's exact served as statistical tests.

During the observation period, the monthly NPs increased from 26 to 43, the RVR showed a 3.96-fold increase, the CMI showed a 2.41-fold increase, and the LOS reached a steady state in the 2nd year after service resumption. CA (p = 0.03), MDGNs, and MPRCs diversified. ORPS trended towards better overall evaluation after service resumption (p = 0.09). CTI mapping identified a unique market position of the index department.

The IAPP makes extended hospital management data accessible to clinicians, can inform other stakeholders in healthcare, and can be tailored to local conditions.