Project 2 - Supply and Demand Gap Analysis

Table Of Contents

• Aim
• Introduction
• Problem Statement
• Methodology
• Analysis (Data sheets pertaining to it)
• Insights
• Recommendations
• Conclusion

Aim:

                The aim of this project is to analysis data in detail on employees details to improve the management of the company.

Introduction:

                The main objective of this project is to analyze the data to find the employees full details to get a better understanding to all employees working nature.

Problem Statement:

                We can find out how many male/female, different type of education background, Total working years, Job satisfaction and roles etc. With this we get the information of total employees details to perform analysis.

Methodology:

Step 1: Data Cleaning

                 In data cleaning I cleaned the data with the transform data option present in Power BI because the dataset was not cleaned and included some missing values, so with the help of the duplicates function in Power BI, I cleaned the data and replace the null values with 0 and then started working on it.

Step 2: Data Interpretation

                 In this data interpretation step, I found out some important information about the data set.

• The data set was almost clear and completed.
• To correct the columns data formats clearly.
• There is total of 1470 rows and 35 columns.

Step 3: Visualization

                 In visualization, I took the help of Power BI Desktop software to make graphs and charts here some relevant graphs and charts to create a interactive dashboard.

Analysis (Data sheets pertaining to it):-

In observation found some interesting points that are mentioned below.

• The dataset contains 1470 employee details to analysis.
• Create new measures for male and female to visualize with cards.
• Create pie chart for total employees by business travel, Top one is Travel_Rarely.
• For filter the entire dashboard get department slicer to easily visualize the three departments.
• There are 5 Education background for an employees, So we create a column chart for descending order to easy purpose.
• Range of 18 – 60 ages of employees, 43 different age groups, So we create tree map age by employee number for clear understanding.
• There are six education field in organization to analysis the values, We create waterfall chart using total employee number by education field.
• For quick analysis create a four slicer for Distance from home, Attrition, Martial status and Job role in organization.

Insights:-

• We can take a look at the final Report for further analysis.
• We analysis the full employees details properly to improve the strategic management decision tools.
• To focus on employees who have low job satisfaction and bad work life balance.

Recommendations:-

• We can collect good datasets for analysis.
• We can update the employees details constantly to increase the growth of the organization.
• Like this dataset we can perform operations with various categories, month wise and year wise to increase growth.
• We can work on different datasets and analyze them with the proper format of the chart and improve accuracy to predict the upcoming periods.

Conclusion:-
                                In conclusion, we can analysis the data as very productive manner and modify every week to improve the environment as well as culture for all the employees.