18-07-2022. Project 9	- HR Analytics. Magnifying glass showing decling performance. 

Scene 1

Magnifying glass showing decling performance

[Audio] Chart has been created using the pivot table ( MS Excel). The ratio between female and male department wise has been shown clearly.. 

Scene 2

Calculate the attrition of female employees in every department. Compare this with the female-to-male ratio in each department?

Ratio between Female & Male Department wise:  Human Resources: Female  2.53%  : Male  2.53%  Research & Development: Female  18.14%  : Male  37.97%  Sales: Female  16.03%  : Male  22.78%

Attrition
Count of Attrition
ttrition
2.53%
Count Gender wise
40.
300%
200%
100%
0.00%
Department
2.53%
Human Resources
37.97%
18.14%
Research &
Development
22.78%
16.03%
Gender
Female
Male
Sales

Scene 3

Regarding the employees who left the  organisation , how are they divided between frequent and rare business  travellers ? Regarding the ones who did not leave the  organisation , how are they divided between frequent and occasional business  travellers ?

Employees who left the  organisation  divided amongst frequent and rare business  travellers : Non  Travellers : 12 (percentage: 5.06%) Frequent  Travellers : 69 (percentage: 29.11%) Rare  Travellers : 156 (percentage: 65.82%) Employees who did not leave the  organisation  divided amongst frequent and occasional business  travellers : Non  Travellers : 138 (percentage: 11.19%) Frequent   Travellers : 208 (percentage: 16.87%) Rare  Travellers : 887 (percentage: 71.94%) Note: Chart in Next slide

[Audio] Chart shows the attrition level of frequent non-travellers, frequent travellers and rare travellers. 

Scene 4

[Audio] Here the on an average the percentage of salary hikes that employees received who has left the organisation was 15.10%.. 

Scene 5

Among the employees who left the  organisation , what was the spread of the percentage of salary hikes they received? Please attach a screenshot of your analysis here

On an average the percentage of salary hikes the employees who left the  organisation  received was:  15.10%

[Audio] On an average the attrition percentage is 16.12[break]%. 

Scene 6

Divide the monthly income into subcategories of 2,000 (1,001 - 3,000, 3,001 - 5,000 …) and compare this with the respective average attrition percentage.

Count of Attrition
25.00%
20.00%
15.00%
10.00%
5.00%
0.00%
30
Average Attrition Percentage
Attrition
• Yes
No
90
.00
.00
MonthlyIncome2
Monthlylncome

Countof Attrition Column Labels
71.39% 28.61%
85.88% 14.12%
87.25% 12.75%
81.36% 18.64%
10.00%
83.88% 16.12%
Row Labels
30
3m1-50
5001-mo
15m1-170m
17001-19000
'J 19001-21000
Grand Total
90.56%
92.31%
1m.w,6
97.87%
92.w0/0
Yes
9.44%
7.69%
2.13%

Project 9	- HR Analytics

Chart has been created using the pivot table (MS Excel).

The ratio between female and male department wise has been shown clearly.

avatar

Chart shows the attrition level of frequent non-travellers, frequent travellers and rare travellers

Here the on an average the percentage of salary hikes that employees received who has left the organisation was 15.10%.

On an average the attrition percentage is 16.12[break]%

Project 9 - HR Analytics

Scene 1 (0s)

Scene 2 (23s)

Scene 3 (46s)

Scene 4 (1m 17s)

Scene 5 (1m 26s)

Scene 6 (1m 41s)