KennOres Healthcare Recruitment Dashboard is a comprehensive workforce analytics solution designed to monitor recruitment performance, compliance, and staff retention across multiple healthcare departments.

The project was built entirely in Microsoft Excel, integrating advanced data modelling, dynamic pivot systems, and interactive dashboards to help healthcare recruiters track key operational KPIs such as attrition, job satisfaction, training compliance, and vaccination rates.

At its core, the dashboard provides a real-time view of workforce health — translating complex HR datasets into clear, actionable visual insights for senior management. The system consolidates over 1,200 employee records covering five core job groups (Support Workers, Nursing, Live-In Care, Healthcare Assistants, and Domiciliary Care).

Each visual component was designed for practical decision-making:

• Attrition Analysis: segmented by age, department, and visa status to highlight high-risk retention zones.

• Recruitment Funnel: visual tracking of every stage — from applications to onboarding — enabling precise conversion analysis.

• Training Compliance Tracker: measuring completion percentages and automatically correlating them with attrition rates using regression analysis.

• Vaccination and DBS Monitoring: highlighting workforce readiness and compliance alignment with CQC and NHS recruitment standards.

• Overtime and Departmental Breakdown: identifying resource imbalance and productivity gaps across care segments.

The dashboard’s user interface follows Keneneros-inspired design principles — using clear typography, healthcare tones (#009999), and structured layout to promote clarity, accessibility, and trust. It features dynamic slicers for filters (year, visa type, gender, employment type) allowing non-technical users to interact fluidly with data.

Built for operational leaders and HR analysts, the system empowers healthcare recruiters to make evidence-based staffing decisions, improve compliance, and enhance service delivery through measurable insights.