Monthly HR Attrition Analysis Report

Track and analyze employee attrition patterns, identifying key trends, risk factors, and opportunities for retention improvement across departments, tenure groups, and performance levels. This report supports strategic workforce planning and retention initiatives.

Report Objective

Monitor and analyze monthly employee attrition trends, focusing on voluntary and involuntary departures, departmental patterns, and key risk indicators to support proactive retention strategies and workforce planning initiatives.

Overall Attrition Trends

Line chart showing monthly attrition rates with department breakdowns

Questions to Consider:

Feb 2024Mar 2024Apr 2024month2.0%2.5%3.0%sum(attrition_rate) vs. departmentHow is Monthly Attrition Trending Across Departments?Engineering and Sales showing highest attrition rates in recent months
  • Which departments show consistent vs. volatile attrition patterns?

  • Are there any seasonal trends in department-specific attrition?

  • How do department attrition rates compare to company average?

  • Is there a correlation between department size and attrition?

  • Which departments maintain healthy retention despite their size?

  • Are smaller departments at higher risk of talent loss?

140160180200220240sum(headcount)2.0%2.5%3.0%sum(attrition_rate)Department Size vs Attrition Rate AnalysisLarger departments showing lower attrition rates overall

High-Risk Employee Segments

Bar charts examining attrition by tenure and performance ratings

Questions to Consider:

0-1 years1-3 years3-5 years5-10 years10+ yearstenure_band0.0%20.0%40.0%60.0%sum(attrition_rate)Attrition Risk by Tenure BandEmployees with 1-3 years tenure showing highest attrition rates
  • Which tenure bands are most at risk for attrition?

  • How does early-career attrition compare to experienced employee retention?

  • Are there specific retention strategies needed for different tenure groups?

  • How does attrition vary across performance levels?

  • Are we retaining our high performers effectively?

  • What is the impact of performance management on retention?

Below ExpectationsMeets ExpectationsExceeds ExpectationsExceptionalperformance_rating0.0%20.0%40.0%60.0%80.0%100.0%sum(attrition_rate)Performance Rating Distribution of Departing EmployeesHigh performers showing lower attrition rates than average

Exit Interview Insights

Table showing primary departure reasons and satisfaction metrics

Questions to Consider:

departure_reasoncountavg_satisfaction_score
Better Opportunity53.4
Career Growth233.6
Compensation422.5
Work-Life Balance234.2
Management343.6
Company Culture453.3
Relocation353.0
Personal Reasons273.7
Better Opportunity53.3
Career Growth53.8
  • What are the most common reasons for employee departures?

  • How do satisfaction scores correlate with departure reasons?

  • Which areas require immediate attention for retention improvement?