🎯 Project Overview
An interactive HR Analytics dashboard developed in Tableau to analyze employee attrition, satisfaction, and workforce demographics across departments and age groups. This dashboard enables HR managers and business leaders to identify attrition patterns and take data-driven action to improve employee retention.
The dashboard provides a comprehensive view of 1,480 employees across key metrics including attrition rate, job satisfaction ratings, department-wise breakdown, and gender-based attrition by age group — all filterable by education field.
✨ Key Features
KPI Summary Strip
- Employee Count: Total headcount of 1,480 employees across all departments
- Attrition Count: 238 employees departed with a 16.08% overall attrition rate
- Active Employees: 1,242 currently employed staff tracked in real time
- Average Age: Workforce average age of 37 years across all roles
Interactive Dashboard Components
- Attrition by Gender: Donut chart breaking down attrition between male (151) and female (87) employees
- Employees by Age Group: Histogram showing workforce distribution across age bins with adjustable bin size
- Job Satisfaction Rating: Heatmap table rating satisfaction levels 1–4 across all nine job roles
- Department Wise Attrition: Pie chart showing Sales (55.88%), R&D (39.08%), and HR (5.04%) attrition share
- Attrition Rate by Gender & Age Group: Five donut charts segmented by age range (18–25, 26–35, 36–45, 46–55, 55+)
📊 Key Findings
Attrition Insights
- Highest Attrition Age Group: Employees aged 26–35 show the highest attrition with 29.41% female and 19.33% male rates
- Department Risk: Sales department accounts for over half of all attrition at 55.88%
- Gender Gap: Male attrition (151) is significantly higher than female (87) across all age groups
- Retention Strength: Employees aged 55+ show the lowest attrition at under 2% for both genders
Satisfaction Insights
- Sales Executive: Largest group with 329 total, showing strong rating 4 scores (113 employees)
- Research Scientist: 293 employees with high satisfaction concentration at levels 3 and 4
- Human Resources: Smallest group at 52 total, with relatively balanced satisfaction spread
🔧 Technical Implementation
Tools & Technologies
- Tableau Public: Primary dashboard development, visualization, and publishing platform
- Excel / Google Sheets: Data source with employee records, attrition flags, and satisfaction scores
- Calculated Fields: Custom Tableau calculations for attrition rate, age binning, and satisfaction aggregations
- Parameter Controls: Dynamic bin size control for the age group histogram
Data Processing
- Data Cleaning: Handled missing values, standardized job role names, and validated attrition flags
- Age Grouping: Binned continuous age into five meaningful workforce segments
- Education Filter: Slicer covering Human Resources, Life Sciences, Marketing, Medical, and Other fields
- Cross-filtering: All charts respond dynamically to education field and gender selections
💡 Business Impact
- Retention Strategy: Identifies high-risk age groups and departments for targeted retention programs
- HR Decision Making: Enables data-driven hiring and engagement policies based on attrition patterns
- Satisfaction Monitoring: Tracks job satisfaction across roles to flag disengagement early
- Workforce Planning: Age distribution insights support long-term succession planning
- Cost Reduction: Proactive attrition management reduces recruitment and onboarding costs
- Diversity Insights: Gender-based breakdowns inform equitable HR policy development
🎓 Skills Demonstrated
- Tableau: Advanced dashboard design including calculated fields, parameters, and cross-filtering
- Data Visualization: Selecting the right chart types for demographic and categorical HR data
- HR Domain Knowledge: Understanding attrition metrics, satisfaction scoring, and workforce KPIs
- Analytical Thinking: Deriving actionable insights from complex multi-dimensional employee data
- Data Storytelling: Structuring a dashboard narrative from KPIs down to granular age and gender breakdowns
- Excel Integration: Connecting and transforming raw HR data for Tableau consumption