Visualizing Hospital Management Data in R Shiny-A Case Study.

Area of Science:

• Health Informatics
• Hospital Management
• Data Visualization

Background:

• Clinicians require access to comprehensive hospital management data beyond basic Key Performance Indicators (KPIs).
• Existing systems often lack the accessibility and detail needed for informed clinical decision-making.

Purpose of the Study:

• To develop and present an interactive application (IAPP) for visualizing extended hospital management information.
• To demonstrate the IAPP's utility using a neurotrauma and spinal surgery department as a case study.

Main Methods:

• Developed an R Shiny-based interactive application (IAPP) for data visualization.
• Collected data on patient numbers, reimbursement ratios, length of stay, diagnoses, procedures, catchment area, and online patient satisfaction.
• Calculated Case Mix Indexes (CMIs) and Car Travelling Isochrones (CTIs) to assess accessibility and market position.

Main Results:

• Observed increases in monthly patient numbers (26 to 43) and Case Mix Indexes (2.41-fold).
• Reimbursed Valuation Ratios (RVRs) showed a 3.96-fold increase; Length of Stay (LOS) stabilized.
• Diversification in catchment area, main diagnoses, and main procedures noted; online patient satisfaction trended positively.

Conclusions:

• The IAPP effectively makes extended hospital management data accessible to clinicians.
• The application can inform various healthcare stakeholders and be customized for specific institutional contexts.
• The case study highlights the IAPP's potential to support strategic decisions in specialized surgical departments.