Welcome to Other Levels!
Today, we're going to walk you through how to build a powerful and interactive Employee Turnover Analysis Dashboard in Excel.
This Excel dashboard template includes dynamic visuals, slicers, and PivotTables, allowing HR professionals to monitor turnover trends and improve retention strategies.
Dashboard Overview
In the first section, we introduce the HR department, which is responsible for the dashboard. We then present the dashboard title and a short description. The top section shows the total headcount from 2018 to 2024: 100 employees.
Using creative slicers, you can filter data by department—such as Customer Support, Finance, and more—and watch the dashboard update instantly. You’ll also see:
-
Active employees count
-
Exited employees count
-
Turnover rate (35%)
Department Turnover Analysis
A bar chart illustrates turnover by department—including Sales, Info Section, Finance, HR, Marketing, and Customer Support—highlighting areas with the highest turnover rates.
A pie chart follows, breaking down the top six reasons for exits:
-
Retirement
-
Health Issues
-
Termination
-
Personal Reasons
-
Better Opportunities
-
Relocation
Trend & Tenure Analysis
A line chart shows quarterly turnover trends from 2020 to 2024. Another dual-line chart compares new hires vs. exits, where green represents hires and red indicates exits.
A column chart analyzes tenure before exit, showing the average service length of 1.7 years.
A stacked bar chart presents active vs. exited employees by gender with clear color coding: green for active, red for exited.
Customizing the Dashboard
All data is fully editable in a table at the bottom of the file. It contains fields for:
-
Employee ID
-
Department
-
Join Date
-
Exit Date
-
Exit Reason
-
Status
-
Gender
-
Age
The dashboard currently includes data for 100 employees, but it’s built to handle up to 100,000.
Calculating Headcount Using PivotTable
To calculate total headcount:
-
Click on the dashboard icon to jump to the PivotTable sheet.
-
Insert a PivotTable based on the data table.
-
Use Employee ID in the Values field.
-
Change "Sum" to "Count" to get the headcount.
-
Link this count to a helper cell (e.g., B3), then link your dashboard text box to
=B3
.
Note: You can't link a text box directly to a PivotTable value, so always use a helper cell.
Calculating Turnover Rate and Status Breakdown
Use two PivotTables:
-
One to count active employees
-
One to count exited employees
Then use a formula:
Turnover Rate = Exited / Total Headcount
Link the result to a text box just like the total count.
Creating a Department Slicer with Icons
To add a dynamic filter for departments:
-
Select any PivotTable.
-
Go to Insert > Slicer.
-
Choose the Department field.
-
Arrange the slicer in a horizontal layout (6 columns).
-
Format the slicer with matching colors and fonts.
To enhance the design:
-
Add circular icons or photos for each department.
-
Position them beside the slicer items.
This makes your slicer modern, interactive, and visually impressive.
Download the Dataset
Click below to download the full dataset used in this tutorial and start building your own version of the Employee Turnover Analysis Dashboard.
Share:
Customer Engagement & Sales Metrics Report