Power BI Dashboard for Hospital Management System (Surgeons, Surgeries, Staff & OT Utilization)

Job ID: 39861076

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)