← Back to Portfolio

Staff Rota & Scheduling Dashboard

Workforce Analytics

Intelligent staff scheduling system with visual rota builder, shift pattern management, leave requests, and coverage monitoring for care organizations.

Staff Rota & Scheduling Dashboard screenshot 1
Staff Rota & Scheduling Dashboard screenshot 2
Staff Rota & Scheduling Dashboard screenshot 3

Overview

💡 Challenge

Care organizations manage complex schedules with multiple shift patterns, varying staff availability, part-time and relief workers, and frequent last-minute changes. Manual rota creation is time-consuming and error-prone, risking understaffed shifts.

⚡ Solution

Developed a visual scheduling dashboard with weekly rota grid, configurable shift patterns (Early, Day, Late, Night, Long Day), staff profiles with contract details, leave request workflow, and real-time coverage alerts. Supports full-time, part-time, relief, and bank staff management.

🎯 Impact

Reduces rota creation time from hours to minutes. Coverage alerts prevent understaffed shifts. Leave management workflow ensures proper approval process. Analytics track hours worked against contracted hours.

Technical Details

🛠️ Tech Stack

PythonStreamlitSQLitePlotlyPandasWorkforce ManagementCare Sector

✨ Key Features

  • Visual weekly rota grid showing all staff and shifts
  • Staff directory with contract type and hours management
  • 5 configurable shift patterns with custom colors
  • Quick-add feature for scheduling entire week at once
  • Leave request submission and approval workflow
  • Coverage monitoring with minimum staff requirements
  • Hours tracking against contracted hours
  • Support for full-time, part-time, relief, and bank staff
  • Week navigation with date range display
  • Analytics dashboard with scheduling statistics

Key Learnings

  • Care sector scheduling requires support for multiple contract types
  • Visual rota grids are more intuitive than list-based schedules
  • Shift pattern templates dramatically speed up schedule creation
  • Leave management needs proper approval workflows for compliance
  • Coverage alerts are essential for maintaining safe staffing levels

📊 Data Notes

This project uses synthetic/open data to demonstrate capabilities while maintaining privacy and confidentiality. All methods and approaches are applicable to real-world scenarios.

Portfolio | Ayoolumi Oluwafemi Melehon