INTRODUCTION
In this project I carried out an exploratory analysis on the Human Resource dataset of an organization.
DATA PREPARATION AND CLEANING
The data was first loaded into Microsoft excel in order to clean the dataset, remove outliers and checked for consistency in the dataset.
Here is a picture of the dataset
A database was created in MYSQL workbench in order to begin analysis. Picture of the dataset after being imported into the SQL workbench.
ANALYSIS
Analysis was done to answer some necessary questions and get an understanding of the dataset.
1) Total Number of Employee
In the dataset the total number of employees is 1009.
2)Number of Employee Promoted in the last 5 years;
There were only 3 employees promoted in the last 5 years.
3)Average Monthly Hourly worked by Employees
The average monthly hourly worked by employee is 203.2131.
4) Employees with the Highest Number of Projects
Top 5 employees with highest number of projects.
5)Number of Employees with Work Accident;
Employees with work accidents are 87
6)Number of Employee at each Salary Level;
Employees at low salary level were 622, while Employees at Medium Salary level were 367 and lastly which is the least the employee at high salary level were 20.
