HR Analytics Guide: Key Metrics, 4-Step Process, and 3 Real-World Case Studies

Key HR Metrics Across Three Modules

Recruitment Module

The article defines seven core recruitment metrics:

Recruitment Entry Rate: (Successful hires ÷ Total applicants) × 100%

Monthly Average Headcount: (Month-start headcount + Month-end headcount) ÷ 2

Monthly Turnover Rate: (Total monthly leavers ÷ Monthly average headcount) × 100%

Monthly New Hire Rate: (Total monthly new hires ÷ Monthly average headcount) × 100%

Monthly Retention Rate: (Month-end retained employees ÷ Month-start employees) × 100%

Monthly Loss Rate: (Total monthly leavers ÷ Month-start employees) × 100%

Monthly In/Out Ratio: (Total monthly new hires ÷ Total monthly leavers) × 100%

Attendance Module

Individual Attendance Rate: (Days present ÷ Scheduled work days) × 100%

Overtime Intensity Ratio: (Monthly overtime hours ÷ Monthly total work hours) × 100%

Daily Staff Attendance Rate: (Daily present employees ÷ Total company employees) × 100%

Daily Staff Absence Rate: (Daily absent employees ÷ Total company employees) × 100%

Turnover Module

Overall Turnover Rate = (Leavers during period ÷ (Period-start headcount + New hires during period)) × 100%

New Hire Turnover Rate = (Leavers within first half-year ÷ Total leavers during period) × 100%

High-Performer Turnover Rate = (Leavers with average performance grade A ÷ Total leavers) × 100%

High-Tenure Turnover Rate = (Leavers with tenure >3 years ÷ Total leavers) × 100%

High-Grade Turnover Rate = (Leavers at grade P5+ ÷ Total leavers) × 100%

Turnover Health Index = (1 - Overall Turnover Rate × 0.2 + New Hire Turnover Rate × 0.2 + High-Performer Turnover Rate × 0.2 + High-Grade Turnover Rate × 0.2 + High-Tenure Turnover Rate × 0.2) × 100 (equal weighting; weights adjustable per company focus)

Four-Step HR Analytics Process

1. Define Analysis Goals

Before any analysis, clarify the purpose. Example: if HR notices high turnover, the goal becomes identifying causes and reducing attrition. Common goals include improving recruitment efficiency, optimizing talent allocation, boosting employee performance, enhancing satisfaction, reducing turnover, and shaping compensation strategy. Clear goals enable data-driven HR optimization.

2. Build Indicator System

Determine which metrics reflect workforce health: e.g., employee satisfaction, turnover rate, recruitment cycle time, employee performance. To raise satisfaction, collect data on work environment, compensation, and career development opportunities.

3. Data Collection and Analysis

Gather data via surveys, interviews, or existing HR records. Then use analytical tools to uncover trends and patterns.

4. Apply Results and Formulate Strategy

Translate findings into actions: improve working conditions, add training, adjust compensation. Continuously monitor outcomes and iterate to meet targets.

Case Study 1: Employee Turnover Analysis

Turnover analysis helps uncover why employees leave, enabling retention improvements. Key metrics: turnover by department, salary comparison (stayers vs. leavers), promotion opportunities, performance correlation, workload impact.

The chart revealed R&D and HR departments had turnover significantly above company average. Despite R&D's high performance, their turnover was also high, indicating non-performance drivers. Further analysis showed dissatisfaction with salary levels and promotion prospects in these departments. Recommended actions: raise salaries for R&D and HR, increase promotion opportunities, improve work environment, and reduce excessive workload to boost satisfaction and retention.

Case Study 2: Attendance Analysis

Attendance analysis reveals work patterns, absence causes, and policy effectiveness. Metrics: leave days, late-arrival rate, average daily work hours.

Data showed R&D had the longest average work hours but highest late-arrival rate, signaling heavy workload. Finance had the shortest average hours, suggesting possible overstaffing; the article recommends reviewing finance headcount saturation and pausing new hires.

Case Study 3: Training Analysis

Training analysis evaluates investment and optimizes programs. Metrics: training investment ratio (cost vs. total budget), employee participation rate, departmental feedback on courses.

Despite high training investment, participation was low and outcomes uneven. Feedback analysis identified low satisfaction with sales-skills and technical training. Actions: redesign those courses for relevance and practicality, increase program promotion to boost participation, and iteratively adjust content based on feedback to improve effectiveness and satisfaction.