1 of 11

Hiring Process Analytics

BY

UTTKARSH MATHUR

2 of 11

Description

  • The Presentation contains the results about the queries of departments carried out from previous year’s hiring records.

​

  • Records of Hired males and females are generated

​

  • Average Salary is discussed

​

  • Distribution of workforce on the bases of sales slab is projected

​

  • Departmental Workforce count is communicated

3 of 11

Approach

  • Data set of previous year’s hiring are used to bring out the necessary

and asked questions results in an understanding visualization of data.

​

  • Conversion of scattered data into a sorted and cleaned manner to extract the valuable information using advanced excel techniques.

​

  • Problem solving and to the point approach is followed in the provided project.

4 of 11

Tech Stack

Microsoft Excel: Advance Excel functions such as pivot table , COUNTIF statements grouping , sorting is used in deriving the information needed by the organization , also visualizing data in form of bar charts , pie charts and other graphs are achieved using data visualization tools of MS-Excel.

5 of 11

Insights

  • Males & Females Hired: The graph displays the ratio of Males and Females hired in form of Pie Chart, the pivot table for the same is provided below.

​

​

​

Sections

Count

Hired

4419

Female

1856

Male

2563

Grand Total

4419

6 of 11

Insights

  • Average Salary: The average salary paid by the organization is calculated through the arithmetic mean procedure which turned out to be “49,983”.

​

  • Class Intervals : The following table displays the class intervals based on salary slabs and the respective data is in the table:

Average Salary Offered

49983.02902

Salary offered

Count of Department

<100 or (blank)

1

100-40099

2838

40100-80099

2961

80100-120099

1365

160100-200099

1

280100-320099

1

360100-400099

1

Grand Total

7168

7 of 11

Insights

  • Charts and Plots : The following chart displays the proportion of people working in different departments:

​

Row Labels

Hired

Finance Department

176

General Management

113

Human Resource Department

70

Marketing Department

202

Operations Department

1843

Production Department

246

Purchase Department

230

Sales Department

485

Service Department

1332

Grand Total

4697

8 of 11

Insights

  • Charts : The following chart displays different post tiers and employees working at that post :

Post Name

Count of Post Name

UnNamed

1

n9

1

n6

1

n10

1

m7

1

m6

3

i7

982

i6

527

i5

787

i4

88

i1

222

c9

1792

c8

320

c5

1747

c-10

232

b9

463

Grand Total

7168

9 of 11

Conclusion

  • The data found will help us to make the upcoming hiring process according to the requirements and budget as we have all the relevant information for the same.
  • The organization can use the provided data for filling up more employees for the posts that have less number of employees so that the workload can be distributed .
  • The data can be used to calculate the budget for the salaries and increments and bonuses for upcoming time period.

10 of 11

Result

  • Learned about Advance Excel tools and skills

​

  • The hands on experience on a real life project using Excel helped to understand that what kind of projects I can get in future as a data analyst

​

  • The clarity and confidence is gained through working on this project.

​

11 of 11

Thank You !