Human Resources Data Visualization

In this HR data analysis case study, I undertook the task of exploring a dataset for a fictitious software company. The goal of the study was to import, analyze, and visualize Human Resources data in Tableau. The dataset was downloaded from kaggle and cleaned in pgadmin prior to analysis.

Skills : Tableau, SQL, Visulization, Data Exlporation, Data Cleaning

This data analysis and visualization will help leadership team to have visibility on high level metrics about the state of its employees.

Data exploration, cleaning and manipulation is performed on the downloaded data before using data for visualization inside tableau.

The HR data visualization provide insights into following areas:

• Hiring trend of the company.
• Recruitment source used by employees to get the job.
• Diversity and inclusion for the company.
• Department wise job positions and employee count.

Each sheet of dashboard gives us the following insights:

1.Salary Range Per Position: This visualization gives the salary range for each position in the company. Visualization states that companies highest paying job is production technician 1.

2.Diversity and Inclusion: Count of female and male employees, US citizen employees, diversity and inclusion-race these 3 visualizations gives us an overall overview of Diversity and inclusion of the company. It shows that company have more female employees than male. Also, there are more US citizen employees. For race company have 187 white employees which is max and 1 hispanic employee out of total 311 employees.

3.Hiring Trend: The Hiring trend graph gives us the overview of number of employees hired over the years. The maximum employees hired was 83 in year 2011 and minimum was in year 2006 and 2018. Line graph is used to show that trend.

4.Recruitment Source Used by employee: This pie chart gives an exact idea which sources are mainly used to recruit the employees. We can say that Linkedin and Indeed are the most popular platforms used.

5.Departmentwise Jobs and Employess: This bar graph gives us an idea about how many position are there in each department and how many employees works for that positio.