Patient Flow Analytics Dashboard

Designed a comprehensive patient flow monitoring system for a 500-bed hospital. The solution tracks patient journeys from admission to discharge, identifies bottlenecks in care delivery, and optimizes resource allocation. Integrated with hospital information systems to provide real-time bed occupancy, wait times, and staff utilization metrics. Questions to answer: Q1. How many patients were admitted per day? Q2. What is the average length of stay (ALOS)? Q3. Which departments have the longest patient stays? Q4. How many patients are currently admitted vs discharged? Q5. What is the bed occupancy rate? Q6. Which wards have the highest bed utilization? Q7. Which bed types are most in demand? Q8. How many patients does each doctor handle? Q9. Which doctors have the highest average patient stay? Q11. Nurse-to-patient ratio by shift Q12. Which nurse shifts handle maximum patients?