Practice First: Employee Turnover Analysis Excel Dashboard Dataset
The main purpose of this blog is to give you the dataset for hands-on practice with the Employee Turnover Analysis Excel Dashboard. Use this practice Spreadsheet Template to follow each step and build the same interactive HR analytics experience.
How this fits your Dashboard Templates workflow
You can apply the same structure across Dashboard Templates, adapt it into a Google sheets dashboard or a Power BI Dashboard, and present results as a PowerPoint Dashboard using your existing Power Point templates.
Dashboard Overview
The top section highlights total headcount (2018–2024: 100 employees) with slicers to filter departments such as Customer Support, Finance, HR, Marketing, and Sales. Key cards show Active employees, Exited employees, and Turnover rate (35%).
Department & Reasons Analysis
Read the bar chart for turnover by department, then review a reasons pie chart (Retirement, Health Issues, Termination, Personal Reasons, Better Opportunities, Relocation) to pinpoint where and why exits occur.
Trends & Tenure
Use quarterly trend lines (2020–2024) comparing new hires vs. exits, a tenure column chart (average 1.7 years), and a stacked view for active vs. exited by gender to identify patterns.
Customize & Calculate
Edit the data table
All fields are editable (Employee ID, Department, Join/Exit Dates, Exit Reason, Status, Gender, Age). The file starts with 100 records and scales to large datasets.
Headcount & Turnover steps
- Create a PivotTable from the data; place Employee ID in Values and change to Count.
- Link the result to a helper cell (e.g., B3), then to a dashboard text box (
=B3
). - Build two PivotTables for counts of active and exited; compute
Turnover Rate = Exited / Total Headcount
.
Department slicer with icons
- Insert a Slicer for the Department field and arrange it horizontally.
- Style it, then add circular icons or photos beside each department for a modern, interactive look.
Watch the Tutorial
Download the Dataset
Click below to get the practice data and follow the steps above to recreate the complete Excel Dashboard experience.
Share:
Customer Engagement & Sales Metrics Report