📥 Data Source
⬇ Download HR Analytics Dataset (.csv)
500 employee records with Department, Team, Job Level, Location, Age, Education, Salary, Performance Rating, Job Satisfaction, Training Hours, Overtime status, and Attrition (Yes/No). Investigate what drives employee attrition.
📋 Assignment Instructions
Build a Tableau Story (3–5 story points) that presents a data-driven narrative about employee attrition. Imagine you're presenting to the company's leadership team.
Story Point 1: The Big Picture
- Overview Dashboard — build a dashboard showing:
- KPI cards: Total Employees, Attrition Rate, Avg Satisfaction, Avg Salary
- Attrition Rate by Department (bar chart)
- Employee count by Location (map or bar chart)
- Department filter that updates all views
- Caption: Write a story point caption summarizing the overall attrition rate and which departments are most affected.
Story Point 2: Who's Leaving?
- Attrition Profile Dashboard — build views showing:
- Attrition Rate by Job Level (bar chart)
- Attrition Rate by Years at Company (line chart — do new hires leave more?)
- Age distribution of attrited vs retained employees (histogram or box plot)
- Add highlight actions — hovering over "Yes" or "No" in one chart highlights the same group in other charts.
- Caption: Summarize the profile of employees who leave (e.g., "Junior employees in their first 2 years are 3x more likely to leave").
Story Point 3: Root Causes
- Drivers Dashboard — investigate correlations:
- Satisfaction vs Attrition (what satisfaction score is the tipping point?)
- Performance Rating vs Attrition (are low performers leaving, or high performers?)
- Overtime vs Attrition (scatter or bar chart)
- Training Hours vs Attrition (does training help retain?)
- Caption: Present your findings about what drives attrition.
Story Point 4: Salary Deep-Dive (Optional but Recommended)
- Compensation Analysis — show salary distribution by Department, Job Level, and Attrition status. Are employees who leave paid less than those who stay?
- Use a reference line or band — show the median salary and highlight employees below it.
Story Point 5: Recommendations
- Summary Dashboard — create a clean final view with:
- Top 3 risk factors for attrition (from your analysis)
- Departments/teams to prioritize
- Suggested actions (e.g., "Focus retention programs on Junior employees in their first year")
- Caption: Write a concluding recommendation.
📐 Story Formatting Requirements
- Use Dashboard Actions: at least 1 filter action and 1 highlight action
- Write captions for each story point explaining the narrative
- Use a consistent color scheme — e.g., red for attrited employees, blue for retained
- All charts must have titles and clean formatting (remove unnecessary gridlines, format numbers)
✅ Submission Checklist
- 3–5 story points with captions
- Overview dashboard with KPIs and department filter
- Attrition profile analysis (Job Level, Tenure, Age)
- Root cause analysis (Satisfaction, Performance, Overtime, Training)
- At least 1 filter action and 1 highlight action
- Consistent color scheme and clean formatting
- Concluding recommendations story point
Export your workbook as a .twbx (packaged workbook) and upload using the form below.