Power BI Dashboard for Hospital Management System (Surgeons, Surgeries, Staff & OT Utilization)
Budget: $750 – $1,500 USD
I need a Power BI dashboard that provides a comprehensive overview of hospital operations, focusing on the following key areas:
Surgeons and Surgeries:
List of surgeons with total surgeries performed
Type of surgeries and outcomes
Monthly/weekly performance metrics
Supporting Staff:
Details of nurses and other OT staff assigned per surgery
Staff availability and workload
Operation Theatres (OT):
OT occupancy and utilization rate
Scheduling and downtime analysis
Data Insights & Visuals:
KPIs such as average surgery duration, success rate, and staff-to-surgery ratio
Interactive filters (by date, surgeon, department, etc.)
Drill-down capability for detailed views
I will provide sample data in Excel or CSV format.
The final dashboard should be clean, interactive, and visually appealing, with dynamic charts, slicers, and KPIs for decision-making.
Deliverables:
Power BI (.pbix) dashboard file
Underlying data model with relationships and measures
Basic documentation on how to update/refresh the dashboard
Preferred Skills:
Proficiency in Power BI and DAX
Experience with healthcare or operations analytics (preferred but not mandatory)
Surgeons and Surgeries:
List of surgeons with total surgeries performed
Type of surgeries and outcomes
Monthly/weekly performance metrics
Supporting Staff:
Details of nurses and other OT staff assigned per surgery
Staff availability and workload
Operation Theatres (OT):
OT occupancy and utilization rate
Scheduling and downtime analysis
Data Insights & Visuals:
KPIs such as average surgery duration, success rate, and staff-to-surgery ratio
Interactive filters (by date, surgeon, department, etc.)
Drill-down capability for detailed views
I will provide sample data in Excel or CSV format.
The final dashboard should be clean, interactive, and visually appealing, with dynamic charts, slicers, and KPIs for decision-making.
Deliverables:
Power BI (.pbix) dashboard file
Underlying data model with relationships and measures
Basic documentation on how to update/refresh the dashboard
Preferred Skills:
Proficiency in Power BI and DAX
Experience with healthcare or operations analytics (preferred but not mandatory)