Human Resource Dashboard

Table of Contents

• Project Overview
• Data Sources
• Tools
• Data Cleaning and Preparation
• Exploratory Data Analysis
• Data Cleaning and Preparation
• Results and Findings
• Limitations
• References

Project Overview

This project aims to analyse the efficiency of a company's turnover time by comparing factors such as gender, race and company branches to improve the company's productivity in the future.

Data Sources

Human Resource Data: The primary dataset used for this analysis is the "hr_data.csv" file, containing detailed information about the company.

Tools

• Excel - Data Cleaning
  • Download here
• SQL Server - Data Analysis
• Power BI - Creating reports

Data Cleaning and Preparation

In the initial data preparation phase, we performed the following tasks:

• Data loading and inspection.
• Handling missing values.
• Data cleaning and formatting.

Exploratory Data Analysis

EDA involved exploring the sales data to answer key questions, such as:

1. Show the gender distribution of employees in the company.
2. Show the race/ethnicity distribution of employees in the company.
3. What is the age distribution of employees in the company?
4. How is the distribution of employees at headquarters compared to remote employees?
5. How does the gender distribution vary across departments and job titles?
6. What is the distribution of job titles across the company?
7. Which department has the highest termination rate?
8. What is the distribution of employees across locations by city and state?
9. How has the company's employee count changed over time based on hire and term dates?

Results and Findings

The analysis results are summarised as follows:

• There are more male employees than female employees
• The company comprises more of the white race, while the Native Hawaiian and American Indian are the least represented races.
• The majority of the employees are between the ages of 25 and 54
• The number of employees at the headquarters is significantly more than the remote employees
• There are some female-dominated departments as well as male-dominated departments, and the distribution is fairly balanced.
• Engineering is the job title with the highest number of employees, while Auditing has the fewest employees in the company
• The Auditing, Marketing, Business Development and Research & Development departments have the highest termination rate, while the legal department has the least termination rate.
• The state with the highest number of employees is Ohio, while Wisconsin is the state with the least number of employees.
• The net change in employees has increased over the years.

Limitations

• Some Ages with negative values present in the dataset were excluded while carrying out the analysis
• Records with ages below 18 years were excluded as they are below working age

References

• SQL for Businesses by werty.
• Stack Overflow