Healthcare Agency Management Dashboard
An interactive Power BI dashboard designed to track shift management, staff performance, and client service efficiency for a healthcare staffing agency. The dashboard provides real-time insights into shift completion rates, staff workload, and hours worked, optimizing workforce management.
Live Dashbaord
The Healthcare Agency Management Dashboard was developed to help healthcare staffing agencies efficiently manage their workforce. The dashboard aggregates staff shift data, working hours, and client service allocation, ensuring optimal scheduling and performance tracking.
Key features include:
Shift Completion Rate Analysis – Tracks the percentage of successfully completed shifts, helping agencies identify scheduling inefficiencies.
Staff Performance Metrics – Provides insights into total shifts worked, completion rates, and hours logged per staff member.
Shift Type & Ward Analysis – Categorizes shifts into day, night, and half-day and visualizes their distribution across different wards.
Workload Trends – Displays hours worked over time to highlight staffing shortages and overutilization.
Key Technologies & Business Impact:
Data Engineering: Used SQL and Python for data cleaning and processing.
Data Visualization: Built in Power BI, allowing dynamic filtering by year, month, and day range.
Operational Efficiency: Helped improve shift allocation and reduce understaffing risks, enhancing workforce planning.
Predictive Insights: Integrated trend analysis for forecasting staffing demands, reducing last-minute scheduling issues.