Smart Healthcare Operations Dashboard

This Excel-based project is designed to improve decision-making in hospital management by focusing on three critical pillars:

-Hospital Resource Optimization

-Seasonal Patient Inflow Forecasting

-Staff Performance Monitoring

Using tools like Pivot Tables, Slicers, KPIs, and HLOOKUP, the dashboard provides clear, interactive insights into real-time hospital operations. It helps administrators track and analyze data such as:

-Bed and ICU Occupancy Rates

-Monthly Patient Admission Trends

-Surgical Equipment Usage

-Staff Attendance, Overtime, and Satisfaction Scores

The dashboard includes:
✅ Interactive filters to analyze specific departments or time periods
✅ KPIs that reflect current resource availability and utilization
✅ Visual charts to predict seasonal patient spikes
✅ Staff performance metrics to identify efficiency gaps

🔧 Tools & Functions Used:

-Microsoft Excel

-Pivot Tables & Charts

-HLOOKUP for dynamic student-style reports

-Data Validation & Slicers

-Conditional Formatting

-KPI Indicators

📈 Outcome:
This project demonstrates how Excel can go beyond basic spreadsheets to become a powerful tool for data-driven hospital management.