Hiring Process Analysis
Project Description : This project aims to examine and
improve the efficiency and effectiveness of an organization’s
hiring process. It involves analysing the current procedures,
identifying loopholes and areas for improvement and
implementing changes to enhance overall recruitment
experience.
Improve candidate satisfaction and experience.
Enhance the quality of hiring.
Align the hiring process with organizational goals and
objectives.
Approach :
Documented existing hiring processes.
Gather data on time-to-hire, cost-per-hire, source of hire.
Create visual representation of the current hiring process to
identify faults.
Identified ongoing causes of issues and bottlenecks.
Tech-Stack Used : Software : Microsoft Excel 2022 . Excel was
chosen for its extensive data analysis functionalities. Including pivot
tables, charts and statistical functions.
A. Hiring Analysis:
Formula: Men: =countifs(D:D, j38, C:C, K38)
Women: =countifs(D:D, j39, C:C, k39)
no_of_male_and_female
Female
Hired
Male
Hired
0 500 1000 1500 2000 2500 3000
Insights:
Gather data on all new hires over a specific period, including their gender.
This can be sourced from HR records or onboarding forms.
Calculate the percentage of each gender in relation to the total hires to
understand the distribution.
Assess trends or patterns, such as any significant imbalances that might
indicate a need for more inclusive hiring practices or targeted recruitment
efforts.
B. Salary Analysis:
Formula: =average(G:G)
Insights:
The average salary helps gauge the overall compensation level within the
organization or specific departments.
It allows for comparison against industry standards, helping identify whether
salaries are competitive.
Average salary figures can assist in budgeting for future hiring and salary
adjustments.
C. Salary Distribution:
Salary ranged for hired and rejected (After removing out-
liners)
450
400
350
300
250
200
150
100
50
0
99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99 99
- 49 -99 149 199 249 299 349 399 449 499 549 599 649 699 749 799 849 899 949 999
0 00 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0-
50 000 500 000 500 000 500 000 500 000 500 000 500 000 500 000 500 000 500
1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9
Salary range for hired (After removing outliners)
300
250
200
150
100
50
0
99 999 999 999 999 999 999 999 999 999 999 999 999 999 999 999 999 999 999 999
49 9 4 9 4 9 4 9 4 9 4 9 4 9 4 9 4 9 4 9
0- 00- 0-1 0-1 0-2 0-2 0-3 0-3 0-4 0-4 0-5 0-5 0-6 0-6 0-7 0-7 0-8 0-8 0-9 0-9
50 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95
Insights:
Class intervals simplify complex salary data by categorizing it into
manageable ranges. This makes it easier to visualize and interpret salary
distributions.
By examining class intervals, companies can identify outliers or salary ranges
that may require further investigation, such as unusually high or low
salaries.
Class intervals provide a clear framework for reporting salary data to
stakeholders, facilitating discussions about pay equity and budget planning.
D.Departmental Analysis:
no_of_people
Service Department
Sales Department
Purchase Department
Production Department
Operations Department
Marketing Department
Human Resource Department
General Department
Finance Department
0 200 400 600 800 1000 1200 1400 1600 1800 2000
Insights:
Visualizations help transform complex data sets into intuitive graphics,
making it easier to identify trends, patterns, and outliers.
Well-designed visuals can capture attention and engage audiences, making
presentations more impactful and memorable.
Graphs can illustrate relationships between variables ( salary vs experience),
helping analysts draw meaningful conclusions.
Charts and plots convey information quickly and clearly, allowing
stakeholders to grasp key insights.
E. Position Tier Analysis:
No_of_people_hired
1400
1200
1000
800
600
400
200
0
b9 c-10 c5 c8 c9 i1 i4 i5 i6 i7 m6 n6
Insights:
Different tiers often correlate with varying salary ranges and benefits,
reflecting the responsibilities and expertise required at each level.
Understanding the tiers helps employees navigate their career paths, setting
clear expectations for skills and experiences
Each level usually comes with specific skill sets and competencies, allowing
for specialization in roles, which can enhance productivity and efficiency.
