HR Attrition Analytics Interactive Dashboard

https://public.tableau.com/app/profile/the.gideon/vis/HRAttritionAnalyticsDashboard/HRAnalyticsDashboard

Overview

This interective analytics Dashboard provides comprehensive insights into employee attrition patterns within an organisation. Built using Tableau, this dashboard delivers actionable intelligence to help HR professionals and business leaders understand and address talent retention challenges.

Key Metrics

• Total Employees: 1,470
• Current Employees: 1,233
• Attrition Count: 237
• Attrition Rate: 16.1%
• Average Employee Age: 37

Dashboard Components

1. Attrition by Department

A pie chart visualising attrition distribution across different departments (HR, R&D, Sales), highlighting that Sales has the highest attrition rate at 38.8%.

2. Job Satisfaction Analysis

A detailed breakdown of job satisfaction levels (1-4 scale) across different job roles, revealing satisfaction patterns that correlate with attrition risk.

3. Employee Demographics

• Age Distribution: Bar chart showing employee count by age group, with peak representation in the 30-34 age bracket
• Gender Distribution: Visual comparison of attrition rates by gender across different age groups

4. Education Field Analysis

Bar chart displaying attrition rates by educational background, with Life Sciences showing the highest attrition (89 cases).

Business Value

This dashboard enables HR teams to:

• Identify high-risk departments and roles for targeted retention strategies
• Understand demographic factors influencing attrition
• Develop data-driven talent management initiatives
• Reduce turnover costs through proactive interventions
• Support strategic workforce planning with predictive insights

Technical Implementation

• Primary Tool: Tableau Public
• Data Source: HRIS (Human Resource Information System) database
• Data Processing: SQL queries for data transformation and aggregation
• Visualisation Types:
  • Pie charts for proportional analysis
  • Bar charts for comparative analysis
  • Heat maps for multi-dimensional insights
  • Interactive filters for dynamic exploration

Key Insights

• Sales department shows the highest attrition rate (38.8%)
• Employees in Life Sciences and Medical fields have the highest attrition counts
• Gender-based attrition varies significantly by age group
• Job satisfaction levels strongly correlate with attrition risk
• Most attrition occurs in the 25-34 age bracket

Next Steps

For implementation in your organisation:

1. Integrate with your HRIS system for real-time data
2. Establish threshold alerts for high-risk segments
3. Develop targeted retention programs for high-risk departments
4. Monitor the impact of retention initiatives through dashboard metrics

---

Created by: Paul Gideon Wabwire(Guided Project)