Optimising Hospital Bed and Operation Theatre Utilisation with Interactive Analytics Da...

Objective: To develop a data-driven dashboard that optimises hospital bed and operation theatre utilisation, reducing patient wait times and resource idle periods in Indian healthcare facilities.

Problem & Context: Indian hospitals, both public and private, frequently face challenges in managing hospital bed and operation theatre (OT) utilisation due to unpredictable patient inflow, manual scheduling, and lack of real-time visibility. This results in under- or over-utilisation, increased patient waiting times, and suboptimal resource allocation, especially in urban tertiary care centres and government hospitals.

Approach & Methodology: The student team will analyse historical hospital admission, discharge, and OT scheduling data, identify utilisation patterns, and apply operations research and data visualisation techniques. The team will design and develop an interactive dashboard using real or anonymised datasets (e.g., from National Digital Health Mission demo data or open hospital datasets) to support dynamic scheduling and resource planning.

Deliverables & Analysis: Key deliverables include a requirements document, data model, ETL pipeline, and a user-friendly dashboard (e.g., built with Tableau/Power BI or Python Dash). The dashboard will present real-time and historical bed/OT occupancy, bottleneck analysis, and predictive insights for administrators. The team will validate their solution with scenario-based testing and expert feedback.

Business Impact & Decision: The solution will help hospital administrators and operations teams make informed decisions on patient admissions, elective surgery scheduling, and emergency triage, directly improving patient flow, increasing hospital revenue, and enhancing healthcare delivery efficiency.