DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

Cover image for Data Analysis With Microsoft Excel: People Analytics.
Oluwafunmilola Obisesan
Oluwafunmilola Obisesan

Posted on

Data Analysis With Microsoft Excel: People Analytics.

Hey!
Another project here! This was done using one of my favorite tools for Data Analysis, Microsoft Excel! I still feel there’s nothing you can’t do with Excel, it’s literally one of the most powerful tools out there.

                *****
Enter fullscreen mode Exit fullscreen mode

In this project, data cleaning, exploration and visualization was done using only Microsoft excel.
Analysis was done to provide an end of the year summary of the company’s employment structure based on department, performance score, and current status.

Data structure: This dataset originates from the HR department of the company. The dataset contains records of employees ranging from name, gender, marital status, salary, country, state, department, recruitment source, performance score, etc.

Data cleaning and preparation:
The data cleaning and preparation phase was done to ensure the dataset is free from errors, outliers and duplicates.
Here is a picture of the dataset prior to cleaning:

Image description

Some of the steps taken to clean the data include:

  1. Removal of duplicates

  2. The marital status column and gender column were edited to aid better understanding of the values in the rows. The find and replace function in Microsoft excel was used to replace the M and F in the gender column to male and female.

The marital status column was also edited; 0, 1, 2, 3, 4 was replaced with single, married, divorced and separated, respectively.

Here is a picture showing how the find and replace function was used to replace the values in the marital status column.

Image description

3.An additional column was also created, Employees count column. It was necessary to create this column as it would be pivotal in all the analysis carried out.
Here is a picture of the dataset after the data cleaning process.

Image description

Analysis and insights:

Analysis was done using pivot table and charts.
Slicers were also added for easy access to various niche of the dashboard.

The dashboard provides answers to the following :

1.Employees count by gender
2.Employees count by department
3.Employees count by performance score
4.Employees count by current status.

Here is a picture of the dashboard:
Image description

Thank you for reading!

Top comments (1)

Collapse
ayodeleaa profile image
Akinyemi Ayodele

Beautiful project. Well done boss πŸ‘

🌚 Life is too short to browse without dark mode