HR Analytics

	A	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		HR Analytics Report
3
4	Enter Data	Headcount
5
6	Dashboard	ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
7		H0001	Total Headcount	100	105	107	111	114.5	118	121.5	125	128.5	132	135.5	139
8
10		Employee Turnover Rate
11
12		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
13		H0002	Total Headcount	100	105	107	111	114.5	118	121.5	125	128.5	132	135.5	139
14		H0003	Voluntary Turnover (# of employee )	30	22	19	7	8	9	12	14	5	8	9	21
15		H0004	Voluntary Turnover Rate	30.00%	20.95%	17.76%	6.31%	6.99%	7.63%	9.88%	11.20%	3.89%	6.06%	6.64%	15.11%
16		H0005	Involuntary Turnover (# of employee )	3	7	9	6	7	8	1	3	1	2	4	5
17		H0006	Involuntary Turnover Rate	3%	7%	8%	5%	6%	7%	1%	2%	1%	2%	3%	4%
18		H0007	Retirement ( # of Employee )	9	7	2	5	4	3	9	2	3	3	4	10
19		H0008	Retirement Rate	9%	7%	2%	5%	3%	3%	7%	2%	2%	2%	3%	7%
20		H0009	Total Turnover	42	36	30	18	19	20	22	19	9	13	17	36
21		H0010	Overall Turnover Rate	33%	28%	26%	12%	13%	14%	11%	14%	5%	8%	10%	19%
22
25		Employee Diversity
26
27		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
28		H00011	Saudi	40	42	44	46	48	50	52	54	56	58	60	62
29		H00012	Bahrain	10	10	12	10	10	10	10	10	10	10	10	10
30		H00013	Germany	3	3	5	3	3	3	3	3	3	3	3	3
31		H00014	Egypt	15	15	21	15	15	15	15	15	15	15	15	15
32		H00015	India	44	45	46	47	48	49	50	51	52	53	54	55
33		H00016	Lebanon	10	10	12	10	10	10	10	10	10	10	10	10
34				122	125	140	131	134	137	140	143	146	149	152	155
35
36
37		Employee Diversity
38
39		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
40		H00017	Saudi	40	42	44	46	48	50	52	54	56	58	60	62
41		H00018	Non-Saudi	82	83	96	85	86	87	88	89	90	91	92	93
42
43		Sudization %
44
45		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
46		H00019	Sudization %	49%	51%	46%	54%	56%	57%	59%	61%	62%	64%	65%	67%
47
48		Training & Development
49
50		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
51		H00020	Hours of Training	129	174	170	110	114	112	123	141	144	132	120	109
52		H00021	Number of Participate	30	39	37	21	19	17	31	43	33	54	20	27
53
55		Promotion Rate
56
57		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
58		H00022	Sales	12%	13%	10%	14%	13%	13%	14%	19%	17%	23%	15%	27%
59		H00023	Finance	19%	17%	23%	15%	27%	13%	14%	19%	17%	23%	15%	27%
60		H00024	HR & Admin	12%	13%	10%	14%	13%	13%	19%	17%	23%	15%	27%	27%
61		H00025	Operation	12%	13%	10%	14%	19%	17%	23%	15%	27%	23%	15%	27%
62		H00026	IT	12%	13%	19%	17%	23%	15%	27%	19%	17%	23%	15%	27%
63		H00027	Marketing	12%	13%	10%	14%	13%	13%	14%	19%	17%	23%	15%	27%
64
68		Overtime Costs
69
70		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
71		H00028	Sales	SAR 1,200	SAR 1,201	SAR 1,202	SAR 1,203	SAR 1,204	SAR 1,205	SAR 1,206	SAR 1,207	SAR 1,208	SAR 1,209	SAR 1,210	SAR 1,211
72		H00029	Finance	SAR 1,000	SAR 1,001	SAR 1,002	SAR 1,003	SAR 1,004	SAR 1,005	SAR 1,006	SAR 1,007	SAR 1,008	SAR 1,009	SAR 1,010	SAR 1,011
73		H00030	HR & Admin	SAR 800	SAR 801	SAR 802	SAR 803	SAR 804	SAR 805	SAR 806	SAR 807	SAR 808	SAR 809	SAR 810	SAR 811
74		H00031	Operation	SAR 600	SAR 601	SAR 602	SAR 603	SAR 604	SAR 605	SAR 606	SAR 607	SAR 608	SAR 609	SAR 610	SAR 611
75		H00032	IT	SAR 400	SAR 401	SAR 402	SAR 403	SAR 404	SAR 405	SAR 406	SAR 407	SAR 408	SAR 409	SAR 410	SAR 411
76		H00033	Marketing	SAR 200	SAR 201	SAR 202	SAR 203	SAR 204	SAR 205	SAR 206	SAR 207	SAR 208	SAR 209	SAR 210	SAR 211
77		H00034	Total	SAR 4,200	SAR 4,206	SAR 4,212	SAR 4,218	SAR 4,224	SAR 4,230	SAR 4,236	SAR 4,242	SAR 4,248	SAR 4,254	SAR 4,260	SAR 4,266
78
79
80
81		Average Benefits Costs per Employee
82
83		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
84		H00035	Benefits Costs per Employee	SAR 450,000	SAR 390,913	SAR 500,000	SAR 496,971	SAR 521,971	SAR 546,971	SAR 571,971	SAR 596,971	SAR 621,971	SAR 646,971	SAR 671,971	SAR 696,971
85		H00036	Average Benefits Costs per Employee	SAR 4,500.00	SAR 3,722.98	SAR 4,672.90	SAR 4,477.22	SAR 4,558.70	SAR 4,635.35	SAR 4,707.58	SAR 4,775.77	SAR 4,840.24	SAR 4,901.30	SAR 4,959.20	SAR 5,014.18
86
88		HR Budget
89
90		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
91		H00037	HR Budget	SAR 10,000	SAR 9,800	SAR 11,000	SAR 11,267	SAR 11,767	SAR 12,267	SAR 12,767	SAR 13,267	SAR 13,767	SAR 14,267	SAR 14,767	SAR 15,267
92
95		Exit Interview questionnair
96
97		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
98		H00038	Lack of growth opportunities	4	4	4	5	3	0	2	3	5	6	3	0	39
99		H00039	Direct Manager	5	7	5	4	5	7	4	6	7	4	3	2	59
100		H00040	Work Environment	4	5	3	1	3	0	2	3	5	6	3	0	35
101		H00041	Poor Management	5	7	2	4	5	7	4	6	7	4	3	2	56
102		H00042	Work-life balance	4	8	7	6	3	0	2	3	5	6	3	7	54
103		H00043	Salary	5	7	4	4	9	7	11	9	12	4	8	6	86
104
105		Avg Tenue
106
107		ID	Indicator Name	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
108		H00044	Less than Year	40	45	50	55	60	65	70	75	80	85	90	95
109		H00045	1-2	47	48	49	50	51	52	53	54	55	56	57	58
110		H00046	2-3	54	51	54	53	53	53	53	53	53	53	53	53