← 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