HR Turnover Analysis Dashboard

Project Overview

This interactive HR Turnover Dashboard provides a dynamic, data-driven overview of employee attrition across various demographics, departments, education levels, and job roles. Built entirely in Excel using advanced charting techniques, it enables HR leaders to monitor workforce stability, identify high-risk groups, and develop strategic retention initiatives.

The Excel dashboard offers an intuitive way to explore employee turnover trends. Through interactive filters (slicers), users can segment the data by department, gender, and education field. This interactivity helps HR professionals and decision-makers drill down into patterns of employee departures and gain actionable workforce insights.

This project demonstrates end-to-end HR analytics in Excel, from raw data structuring and cleaning to pivot-based analysis and visual storytelling. It highlights how Excel can be effectively used for people analytics and HR decision support.

Key Features

Workforce Overview

  • Workforce Insights: The organization has a total of 1,470 employees, out of which 1,233 are currently active. Over the reporting period, 237 employees left the company, resulting in a turnover rate of 16.12%. The average age of employees is 36.9 years, and the overall job satisfaction score across the workforce stands at 2.6 out of 4.

Turnover Demographics

  • By Gender: Males represent 63% of attrition, Females 37%.
  • By Age Group: The 25–34 group shows the highest turnover (112 employees), followed by 35–44 and under 25.
  • By Marital Status: Single employees accounted for 120 turnovers, married 84, and divorced 33—indicating lifestyle and stability may impact attrition.

Education & Job Role Analysis

  • By Education: Bachelor's Degree holders have the highest turnover (99), followed by Master’s (58) and Associate’s (44).
  • By Job Role: Laboratory Technicians (62) and Sales Executives (57) lead turnover counts, with roles like Research Scientists, HR, and Managers contributing smaller but significant portions.

Department-Wise Insights

The analysis shows that R&D experienced the highest number of turnovers with 133 employees, accounting for 56% of total attrition. This is followed by the Sales department, which had 92 turnovers (39%), while the HR department had the lowest attrition with only 12 employees (5%) leaving.

Interactive Filtering

Filters by Department, Education Field, and Gender enable easy segmentation and deeper exploration of trends.

Technical Implementation

  • Excel Dashboarding: Built using interactive charts including pictograms, clustered columns, 3D columns, doughnuts, horizontal bars, and stacked visuals.
  • Pivot Tables & Slicers: Enable dynamic filtering and fast analysis across multiple employee attributes.
  • Formulas & Data Prep: Utilized CONCAT, IFERROR, TEXT, GETPIVOTDATA, TEXT, and basic logical functions for metric calculations and formatting.

Business Impact

  • Attrition Risk Identification: Helps HR teams pinpoint high-turnover segments such as R&D employees, younger workforce (25–34), and Bachelor’s degree holders. Enables proactive retention strategies.
  • Workforce Planning: Supports evidence-based planning around hiring needs, succession planning, and employee engagement policies.
  • Inclusion & Retention Strategy: Highlights gender and marital status trends that can inform diversity, equity, and inclusion efforts, as well as personalized retention programs.
  • HR Reporting Efficiency: Accelerates the creation of monthly or quarterly HR reports for executive teams by providing a ready-to-use dashboard with key attrition metrics.

Interactive HR Turnover Analysis Dashboard