[go: up one dir, main page]

0% found this document useful (0 votes)
39 views12 pages

HR Analytics Assignment Data Set

The document provides a detailed list of active employees, including their Employee ID, Job Title, Employee Status, Gender, Age, Region, and Pay Grade. It also includes information about their annual salary, years of service, and training programs completed in 2022. The data reflects a diverse workforce across various regions and job roles.

Uploaded by

Kishan Panchal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
39 views12 pages

HR Analytics Assignment Data Set

The document provides a detailed list of active employees, including their Employee ID, Job Title, Employee Status, Gender, Age, Region, and Pay Grade. It also includes information about their annual salary, years of service, and training programs completed in 2022. The data reflects a diverse workforce across various regions and job roles.

Uploaded by

Kishan Panchal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

Employee ID Job Title Employee Status Gender Age Region Pay Grade

111 Service Specialist Active M 36 Middle East B


116 Manager Active Not specified 49 Europe Union
117 Service Specialist Active Not specified 38 USA B
127 Manager Active M 40 LATAM C
141 Manager Active M 34 LATAM C
145 Sales Associate Active F 44 Europe A
147 Sales Associate Active M 54 Canada A
152 Welder Active Not specified 30 LATAM B
153 Marketing Co-op Active F 45 Canada B
155 IT Active F 56 LATAM A
157 Service Specialist Active M 42 Canada Union
159 Service Specialist Active F 39 Middle East Union
169 Service Specialist Active F 43 Europe C
172 Senior Manager Active M 51 Europe C
175 Manager Active Not specified 34 LATAM C
187 Service Specialist Active M 41 Middle East A
188 HR Advisor Active M 55 Middle East A
193 Administrative AssistantActive F 49 Canada C
200 Programer Active F 51 LATAM Union
204 Service Specialist Active Not specified 55 Middle East B
205 Programer Active F 32 Middle East Union
216 Senior Engineer Active F 50 USA B
219 Service Specialist Active M 42 LATAM B
222 Welder Active M 54 LATAM A
223 Welder Active Not specified 30 USA A
230 Welder Active Not specified 48 LATAM B
232 Engineer Active F 34 LATAM Union
248 Accountant Active Not specified 41 Middle East C
251 Welder Active F 44 Canada A
252 Service Specialist Active Not specified 55 Europe Union
258 Sales Associate Active M 33 Canada Union
265 Sales Associate Active M 37 Europe Union
268 IT Active F 38 Europe B
269 Welder Active M 20 USA Union
272 Manager Active Not Specified 35 LATAM B
282 Engineer Active F 37 USA Union
288 Senior Engineer Active F 43 Canada Union
290 Administrative AssistantActive F 25 Canada D
292 Service Specialist Active M 22 Canada B
293 Programer Active M 30 Canada B
300 Lawyer Active F 28 Canada B
307 Welder Active F 50 Canada Union
310 Welder Active F 38 LATAM Union
318 Manager Active F 33 Middle East B
321 HR Manager Active F 38 USA B
322 Senior Engineer Active F 45 Canada B
323 Administrative AssistantActive F 38 Canada D
324 Engineer Active M 34 Europe Union
333 Sales Associate Active Not Specified 27 Canada B
334 Welder Active M 24 USA Union
336 Administrative AssistantActive F 38 Europe D
339 Sales Associate Active F 46 Europe C
340 Programer Active M 46 Canada B
346 COO Active M 53 Canada A
348 Engineer Active M 22 Canada Union
350 Service Specialist Active F 33 Canada B
353 Sales Associate Active Not Specified 27 Canada C
354 Service Specialist Active M 48 Canada B
368 Welder Active F 44 LATAM C
369 Sales Associate Active Not Specified 44 Canada Union
373 IT Active F 26 USA C
375 Service Specialist Active F 48 LATAM B
377 Manager Active M 33 LATAM Union
379 Sales Associate Active F 42 Europe C
394 Senior Manager Active F 39 Canada B
396 Service Specialist Active Not Specified 44 USA C
398 Service Specialist Active F 33 Middle East Union
400 Sales Associate Active M 34 Middle East C
401 Senior Manager Active F 39 Middle East B
420 Service Specialist Active M 33 Middle East Union
422 Programer Active M 26 Europe C
426 Programer Active M 35 USA C
433 Administrative AssistantActive F 33 Canada D
437 Service Specialist Active F 43 USA B
438 Manager Active F 44 USA Union
444 HR Advisor Active F 34 Canada Union
446 Welder Active F 52 LATAM B
454 Service Specialist Active M 33 Europe B
456 CFO Active F 43 Canada A
457 Senior Manager Active F 48 USA B
460 Service Specialist Active Not Specified 28 LATAM B
464 Welder Active Not Specified 33 Europe Union
466 Administrative AssistantActive M 50 Europe D
475 Welder Active F 33 USA Union
483 Senior Engineer Active M 35 Europe C
486 Service Specialist Active M 34 Canada B
495 Welder Active F 47 LATAM A
499 IT Active M 38 USA B
506 Sales Associate Active M 57 LATAM C
510 Welder Active F 25 Canada Union
511 Senior Engineer Active F 37 Middle East A
513 Welder Active Not Specified 35 Middle East Union
515 Welder Active M 61 USA Union
518 Sales Associate Active F 46 LATAM C
520 Welder Active F 33 USA Union
525 Senior Engineer Active F 44 Canada A
536 Sales Associate Active M 32 Europe C
545 Administrative AssistantActive F 29 Middle East D
546 Marketing Manager Active F 48 Middle East B
548 Service Specialist Active F 38 USA Union
555 Welder Active M 61 LATAM C
559 Service Specialist Active M 48 LATAM Union
560 Service Specialist Active F 27 Canada Union
562 Manager Active M 42 Canada C
565 Lawyer Active F 36 Canada B
568 Service Specialist Active F 39 USA B
570 Sales Associate Active Not Specified 29 Europe C
573 Senior Manager Active F 45 Canada A
575 Welder Active F 45 LATAM B
587 Manager Active Not Specified 46 Canada B
600 Manager Active F 33 Europe B
602 Welder Active F 27 USA Union
605 Service Specialist Active F 38 Middle East B
617 Vice President IT Active M 50 Canada A
633 Senior Manager Active F 52 Canada B
636 Welder Active M 38 LATAM Union
640 Service Specialist Active M 48 Canada B
651 Welder Active M 37 Canada Union
653 IT Active M 29 USA B
655 Welder Active F 43 USA Union
661 Welder Active F 36 USA Union
663 Welder Active M 26 Middle East Union
666 Administrative AssistantActive F 32 Middle East D
680 Welder Active F 28 Middle East Union
681 Senior Manager Active M 60 USA A
686 Engineer Active F 36 Canada Union
702 Engineer Active M 44 Middle East B
703 Welder Active F 63 Canada Union
713 Welder Active F 44 Middle East Union
716 Welder Active F 29 USA Union
718 Administrative AssistantActive Not Specified 36 Middle East D
720 Senior Manager Active F 37 Europe A
722 Engineer Active F 38 USA Union
723 Welder Active M 44 USA Union
730 Service Specialist Active M 28 USA B
739 HR Co-op Active F 48 LATAM Stu
741 Account Manager Active F 50 Middle East B
745 Programer Active M 33 Canada C
746 Manager Active Not Specified 29 Canada B
747 Welder Active F 55 LATAM Union
750 Service Specialist Active M 36 LATAM C
753 Sales Associate Active M 38 Canada C
755 Engineer Active F 33 Middle East B
756 Service Specialist Active F 45 Middle East B
758 Service Specialist Active Not Specified 46 Canada B
759 Manager Active M 46 USA B
767 Welder Active F 43 USA Union
768 Manager Active M 31 Canada C
769 Sales Associate Active F 24 LATAM C
771 Service Specialist Active M 37 LATAM B
772 Service Specialist Active M 27 Canada B
777 Administrative AssistantActive Not Specified 34 Middle East D
789 CEO Active M 52 Canada A
790 Engineer Active M 31 Middle East B
793 Service Specialist Active F 39 Canada B
800 Engineer Active M 24 Canada A
818 Welder Active M 27 USA Union
835 IT Active F 46 USA C
836 Manager Active Not Specified 47 Canada B
840 Service Specialist Active M 48 USA B
842 Sales Associate Active M 48 Canada C
847 Welder Active F 52 Middle East Union
852 Account Manager Active Not Specified 32 Middle East B
862 Accountant Active M 29 Canada C
865 IT Active F 46 LATAM B
871 Administrative AssistantActive Not Specified 28 Canada D
872 Sales Associate Active F 44 LATAM C
875 Welder Active F 40 USA Union
877 IT Active F 47 Canada C
880 Administrative AssistantActive F 26 USA D
886 Programer Active M 24 Europe D
887 Welder Active Not Specified 60 LATAM Union
888 Maintenance Active Not Specified 41 LATAM D
897 Lawyer Active M 51 Canada A
900 Service Specialist Active F 47 USA Union
902 Engineer Active F 44 USA Union
905 Service Specialist Active M 39 USA B
907 Marketing Co-op Active M 22 Middle East Stu
908 Sales Associate Active M 20 LATAM C
911 Welder Active Not Specified 23 Canada Union
914 IT Active F 37 LATAM B
920 Service Specialist Active F 29 LATAM B
922 Service Specialist Active F 33 Middle East B
927 Service Specialist Active M 49 USA B
935 IT Active F 37 Canada C
948 Service Specialist Active F 26 Middle East C
949 Engineer Active F 29 USA Union
951 Sales Associate Active F 45 Canada C
952 Sales Associate Active F 22 Canada C
961 Service Specialist Active F 49 Canada B
962 Sales Associate Active F 35 LATAM C
963 Account Manager Active M 28 USA B
966 Sales Associate Active F 42 LATAM C
967 Welder Active M 38 USA Union
969 Welder Active Not Specified 40 Canada Union
971 Sales Associate Active F 39 Canada C
975 IT Active M 36 Canada B
979 Maintenance Active F 42 LATAM D
989 Service Specialist Active F 39 LATAM B
999 IT Active Not Specified 48 Middle East D
Training Programs Completed in
Pay Group Annual Salary Years of Service 2022
Salary $ 63,000.00 7 Values-Based Decision-Making
Salary $ 78,000.00 11 Ethics
Hourly $ 70,000.00 2 Change Mgmt
Salary $ 65,000.00 5 Leadership
Salary $ 89,000.00 2 Ethics
Hourly $ 72,000.00 1 Change Mgmt
Hourly $ 77,000.00 11 Values-Based Decision-Making
Hourly $ 71,000.00 12 Change Mgmt
Hourly $ 92,000.00 8 Values-Based Decision-Making
Salary $ 65,000.00 9
Hourly $ 76,000.00 4 Values-Based Decision-Making
Hourly $ 70,000.00 9 Leadership
Hourly $ 80,000.00 4 Leadership
Salary $ 63,000.00 12 Equity, Diversity, and Inclusion
Salary $ 91,000.00 3 Equity, Diversity, and Inclusion
Hourly $ 59,000.00 12 Change Mgmt
Salary $ 79,000.00 12 Ethics
Salary $ 67,000.00 6 Leadership
Salary $ 64,000.00 11 Ethics
Hourly $ 76,000.00 2 Values-Based Decision-Making
Salary $ 56,000.00 8
Salary $ 72,000.00 6 Values-Based Decision-Making
Hourly $ 64,000.00 9 Values-Based Decision-Making
Hourly $ 90,000.00 3 Leadership
Hourly $ 61,000.00 3 Change Mgmt
Hourly $ 76,000.00 11 Equity, Diversity, and Inclusion
Salary $ 59,000.00 3 Leadership
Salary $ 71,000.00 4 Change Mgmt
Hourly $ 90,000.00 10 Change Mgmt
Hourly $ 79,000.00 3 Leadership
Hourly $ 60,000.00 4 Equity, Diversity, and Inclusion
Hourly $ 60,000.00 4 Change Mgmt
Salary $ 85,000.00 8 Equity, Diversity, and Inclusion
Hourly $ 55,000.00 1 Equity, Diversity, and Inclusion
Salary $ 85,000.00 4 Ethics
Salary $ 85,000.00 1
Salary $ 100,000.00 9 Ethics
Salary $ 50,000.00 1
Hourly $ 85,000.00 2
Salary $ 85,000.00 9
Hourly $ 85,000.00 4 Ethics
Hourly $ 55,000.00 36 Values-Based Decision-Making
Hourly $ 55,000.00 6 Values-Based Decision-Making
Salary $ 85,000.00 4 Values-Based Decision-Making
Salary $ 87,000.00 12 Ethics
Salary $ 85,000.00 6 Values-Based Decision-Making
Salary $ 50,000.00 6 Change Mgmt
Salary $ 85,000.00 3
Salary $ 85,000.00 6 Change Mgmt
Hourly $ 55,000.00 2
Salary $ 50,000.00 17 Values-Based Decision-Making
Hourly $ 60,000.00 5 Leadership
Salary $ 85,000.00 7 Equity, Diversity, and Inclusion
Salary $ 287,000.00 8 Equity, Diversity, and Inclusion
Salary $ 85,000.00 6 Change Mgmt
Hourly $ 85,000.00 3 Values-Based Decision-Making
Salary $ 60,000.00 4 Leadership
Hourly $ 85,000.00 4 Change Mgmt
Hourly $ 55,000.00 6 Equity, Diversity, and Inclusion
Hourly $ 60,000.00 19 Values-Based Decision-Making
Salary $ 60,000.00 1 Equity, Diversity, and Inclusion
Hourly $ 85,000.00 7 Ethics
Salary $ 85,000.00 1 Values-Based Decision-Making
Hourly $ 60,000.00 8 Ethics
Salary $ 95,000.00 5
Hourly $ 60,000.00 4
Hourly $ 85,000.00 7 Leadership
Hourly $ 60,000.00 7 Change Mgmt
Salary $ 95,000.00 5 Values-Based Decision-Making
Hourly $ 85,000.00 7 Change Mgmt
Salary $ 60,000.00 4 Values-Based Decision-Making
Salary $ 60,000.00 3 Ethics
Salary $ 50,000.00 4 Equity, Diversity, and Inclusion
Hourly $ 85,000.00 3 Leadership
Salary $ 87,000.00 8 Leadership
Salary $ 85,000.00 19 Ethics
Hourly $ 55,000.00 12 Equity, Diversity, and Inclusion
Hourly $ 85,000.00 8 Values-Based Decision-Making
Salary $ 300,000.00 15 Change Mgmt
Salary $ 95,000.00 2 Values-Based Decision-Making
Hourly $ 85,000.00 5 Values-Based Decision-Making
Hourly $ 55,000.00 9 Equity, Diversity, and Inclusion
Salary $ 50,000.00 8
Hourly $ 55,000.00 9 Equity, Diversity, and Inclusion
Salary $ 66,000.00 10 Values-Based Decision-Making
Hourly $ 85,000.00 3 Equity, Diversity, and Inclusion
Hourly $ 55,000.00 7 Leadership
Salary $ 87,000.00 6 Ethics
Salary $ 60,000.00 2
Hourly $ 55,000.00 1 Ethics
Salary $ 100,000.00 4 Change Mgmt
Hourly $ 55,000.00 3 Ethics
Hourly $ 55,000.00 4
Salary $ 66,000.00 8 Ethics
Hourly $ 55,000.00 4 Values-Based Decision-Making
Salary $ 87,000.00 9 Equity, Diversity, and Inclusion
Hourly $ 60,000.00 1 Change Mgmt
Salary $ 50,000.00 6 Values-Based Decision-Making
Salary $ 87,000.00 8 Ethics
Hourly $ 85,000.00 1 Leadership
Hourly $ 55,000.00 3
Hourly $ 85,000.00 6
Hourly $ 85,000.00 3 Leadership
Salary $ 60,000.00 2 Conflict Mgmt
Hourly $ 85,000.00 5 Equity, Diversity, and Inclusion
Hourly $ 85,000.00 1 Values-Based Decision-Making
Hourly $ 60,000.00 5
Salary $ 100,000.00 1
Hourly $ 55,000.00 5 Change Mgmt
Salary $ 85,000.00 9
Salary $ 85,000.00 8 Values-Based Decision-Making
Hourly $ 55,000.00 6 Leadership
Hourly $ 85,000.00 1 Values-Based Decision-Making
Salary $ 120,000.00 6
Salary $ 95,000.00 6 Change Mgmt
Hourly $ 55,000.00 8 Values-Based Decision-Making
Hourly $ 85,000.00 3 Conflict Mgmt
Hourly $ 55,000.00 9 Values-Based Decision-Making
Salary $ 85,000.00 2 Change Mgmt
Hourly $ 66,000.00 3 Ethics
Hourly $ 66,000.00 8 Ethics
Hourly $ 55,000.00 4 Ethics
Salary $ 50,000.00 8
Hourly $ 55,000.00 4
Salary $ 100,000.00 5 Leadership
Salary $ 85,000.00 1 Conflict Mgmt
Salary $ 85,000.00 6
Hourly $ 55,000.00 23
Hourly $ 55,000.00 5 Leadership
Hourly $ 55,000.00 2 Change Mgmt
Salary $ 50,000.00 6 Values-Based Decision-Making
Salary $ 100,000.00 4 Conflict Mgmt
Salary $ 85,000.00 9
Hourly $ 55,000.00 5 Equity, Diversity, and Inclusion
Hourly $ 85,000.00 3 Ethics
Hourly $ 40,000.00 1
Salary $ 85,000.00 34
Salary $ 60,000.00 2 Change Mgmt
Salary $ 85,000.00 2 Leadership
Hourly $ 55,000.00 1 Equity, Diversity, and Inclusion
Hourly $ 60,000.00 1 Values-Based Decision-Making
Hourly $ 60,000.00 7
Salary $ 85,000.00 1
Hourly $ 85,000.00 8 Equity, Diversity, and Inclusion
Hourly $ 85,000.00 1 Ethics
Salary $ 85,000.00 2 Conflict Mgmt
Hourly $ 55,000.00 2
Salary $ 60,000.00 4 Ethics
Salary $ 60,000.00 2
Hourly $ 85,000.00 3 Values-Based Decision-Making
Hourly $ 85,000.00 1 Change Mgmt
Salary $ 50,000.00 9 Conflict Mgmt
Salary $ 400,000.00 30
Salary $ 85,000.00 2 Ethics
Hourly $ 85,000.00 8 Ethics
Salary $ 85,000.00 1
Hourly $ 55,000.00 1 Leadership
Salary $ 60,000.00 4
Salary $ 85,000.00 1 Change Mgmt
Hourly $ 85,000.00 5
Hourly $ 60,000.00 1 Conflict Mgmt
Hourly $ 55,000.00 9 Change Mgmt
Salary $ 85,000.00 4 Conflict Mgmt
Salary $ 60,000.00 1 Ethics
Salary $ 85,000.00 8 Ethics
Salary $ 50,000.00 3
Salary $ 60,000.00 7
Hourly $ 55,000.00 7 Change Mgmt
Salary $ 60,000.00 7
Salary $ 50,000.00 3 Leadership
Salary $ 50,000.00 1 Change Mgmt
Hourly $ 55,000.00 9 Values-Based Decision-Making
Hourly $ 50,000.00 16
Salary $ 150,000.00 24
Salary $ 85,000.00 6
Salary $ 85,000.00 9
Hourly $ 85,000.00 9 Equity, Diversity, and Inclusion
Hourly $ 40,000.00 1 Equity, Diversity, and Inclusion
Salary $ 60,000.00 1
Hourly $ 55,000.00 1 Equity, Diversity, and Inclusion
Salary $ 85,000.00 9
Hourly $ 85,000.00 4 Conflict Mgmt
Hourly $ 85,000.00 3 Ethics
Hourly $ 85,000.00 9
Salary $ 60,000.00 8 Equity, Diversity, and Inclusion
Hourly $ 60,000.00 3
Salary $ 85,000.00 2
Hourly $ 60,000.00 2 Equity, Diversity, and Inclusion
Hourly $ 60,000.00 3 Leadership
Hourly $ 85,000.00 5 Ethics
Salary $ 60,000.00 2 Conflict Mgmt
Salary $ 85,000.00 6 Leadership
Salary $ 60,000.00 8
Hourly $ 55,000.00 1 Equity, Diversity, and Inclusion
Hourly $ 55,000.00 10 Conflict Mgmt
Hourly $ 60,000.00 8 Conflict Mgmt
Salary $ 85,000.00 2
Hourly $ 50,000.00 18
Hourly $ 85,000.00 1 Ethics
Salary $ 50,000.00 3 Conflict Mgmt
2014 2015 2016
Total employee head count (as of Jan. 1 in each year) 170 211 188
Turnover per year (# of employees that left) 7 12 8
Benefits costs per year 9,321,000 15,169,000 14,532,000
2017 2018 2019 2020 2021
200 196 198 179 202
13 16 16 16 20
11,843,000 13,467,000 14,009,000 10,113,000 13,207,000

You might also like