HR Analytics Dashboard.xlsx

	B	D	F	H	I	J	K	L	M
1	HR Analytics Dashboard
2	HR Analytics Dashboard
3	Period: 1 Jan 2026 to 30 Sep 2026 \| Currency: USD \| 470 employee records
4	ACTIVE HEADCOUNT	OPEN VACANCIES	HIRES (PERIOD)	EXITS (PERIOD)		ATTRITION (ANNUALISED)		AVG TENURE (YRS)
5	422	35	58	48		15.4%		4.4
6
7	ANNUAL PAYROLL	AVG SALARY	FEMALE %	AVG PERFORMANCE		AVG ENGAGEMENT		HIGH FLIGHT RISK
8	$27,785,200	$65,842	39.3%	3.36		3.51		29
9
10	Employee Lookup (choose an Emp ID from the dropdown)				Flight Risk Summary (active employees)
11	Select Emp ID	E1003	<- change me		Risk Level	Employees	% of Active	Avg Salary	Avg Engagement
12	Name	Dennis Njeri			High	29	6.9%	$58,538	3.29
13	Department	Operations			Medium	68	16.1%	$59,166	2.80
14	Job Title	Senior Operations Analyst			Low	325	77.0%	$67,890	3.68
15	Grade	G3			Total	422	100.0%	$65,842	3.51
16	Location	Remote
17	Annual Salary	$75,600			Exit Mix (period)
18	Compa-Ratio	1.15			Exit Type	Exits	% of Exits
19	Performance Rating	4			Voluntary	41	85.4%
20	Engagement Score	2.9			Involuntary	7	14.6%
21	Tenure (yrs)	14.6			Total	48	100.0%
22	Status	Active
23	Flight Risk	High			Flight_Risk lists who to talk to first; Attrition shows where people leave.
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100