Tableau HR Dashboard

Dataset: DataCamp Challenge


View Dashboard on Tableau Public



Project Summary

This project was a part of a DataCamp challenge I took part of. In the project, I explore a dataset for a fictitious software company called Atlas Labs. Dataset collected was clean but I uploaded to SQL anyways to do some basic exploration to insure that data was in fact clean. The goal of this project is to create a clean, self-explanatory, and interactive dashboard for the HR team of Atlas Labs in order to dive deeper into what factors impact attrition. This will help the organization determine what action they will need to take to retain more employees.

The data consists of three files:

  • Employee table which consists of employee information such as EmployeeID, name, age, business travel, ethnicity, EducationLevelID (1-5), job, role and time in current role to name a few.
  • Performance Rating table which is surver data collected from employees that consists of EmployeeID, review date, environment satisfaction, job satisfaction, work-life balance, self rating and manager rating to name a few.
  • Education table which has EducationLevelID (1-5) and the corresponding education level.

Key findings from the analysis include:

1. Attrition

  • The overall attrition rate is 32.68%.
  • The highest attrition rate is observed in the Sales department (39.56%), followed by HR (36.74%) and then the Technology department (28.90%).
  • Employees with 0 to 2 years of tenure show the highest attrition rate.
  • Employees with "Some Travel" made up 65.90% of the total attrition.
  • Employees with salaries of $60,000 and below, regardless of gender, are more likely to quit.

2. Headcount

  • The total headcount in the organization is 6,919 employees.
  • The majority of employees (33.52%) are aged between 25 and 29 years old.
  • The gender distribution is almost equal, with 49.112% of employees being female and 50.888% being male.

4. Compensation

  • The average annual salary for employees is $110,793.
  • The Sales department has the highest average annual salary ($120,384), followed by HR ($107,630) and Technology ($106,157).
  • Male employees have a higher average annual salary ($110,938) than female employees ($107,528).
These findings provide valuable insights into the factors that contribute to a an employee quitting and can help the HR department liik into a specific popultion of employees in order to retain more employees.


Tableau Dashboard

Tableau Dashboard Embedding