HR Analytics
Workforce intelligence, planning, and operational insights for <Company Name>.
Workforce
Leave
Assets
Compensation
Performance
Glossary
Number of employees
342
↑ 12 vs last month
Share of employees working Full-Time (%)
78%
268 Full-Time · 74 part-time
Number of active contracts
318
24 expiring in 90d
Average tenure (years)
3.2 yrs
Number of hires in 2026
47
+9 vs prior YTD
Number of leavers in 2026
23
Net headcount +24 · 47 hires − 23 leavers
Median employee age (years)
34
Most employees: 28 – 42 years old
Share of new hires retained at 90 days (%)
92%
↑ 3pp vs last year · new hires YTD
Workforce overview Employees by department, role, contract, and schedule
Number of employees by department
Number of employees by role
Number of employees by contract type
Number of employees by work schedule
Demographics Age, gender, and background
Number of employees by gender
Number of employees by age group
Number of employees by marital status
Number of employees by age
Number of employees by nationality
Education Qualifications across the company
Number of employees by education level
Share of employees meeting role requirements (%)
Meet requirement
305 · 89%
Below requirement
37 · 11%
Required qualification by role level
Junior levelHigh School or higher
Mid levelDiploma or higher
Senior levelBachelor's degree or higher
Lead levelBachelor's degree or higher
Manager levelMaster's degree or higher
Director levelMaster's degree or higher
Number of employees by education and department
| Education | Engineering | Sales | Operations | Finance | HR | Logistics |
|---|---|---|---|---|---|---|
| Doctorate | 3 | 0 | 0 | 1 | 0 | 0 |
| Master's degree | 28 | 8 | 12 | 18 | 6 | 5 |
| Bachelor's degree | 34 | 36 | 22 | 14 | 14 | 19 |
| Diploma | 7 | 12 | 22 | 7 | 6 | 38 |
| High School | 0 | 2 | 8 | 1 | 2 | 17 |
Contracts Expiring agreements and tenure
Number of contracts ending soon
Contracts within 30 days
6 employeesContracts within 60 days
10 employeesContracts within 90 days
24 employeesWork permits within 30 days
3 employeesWork permits within 60 days
5 employeesWork permits within 90 days
9 employeesNumber of employees by tenure band
< 1 year
58
1 – 5 years
194
5+ years
90
Hiring How you recruit and who stays
Number of hires by recruitment channel
Applications vs hires per channel
Quality leaderboard · Quality = (avg tenure / 6 yrs) × (avg perf / 5) × 100
| Channel | Avg tenure | Avg perf | Quality |
|---|---|---|---|
| Internal recruitment | 5.8 yr | 4.5 | 87 |
| Employee referrals | 4.6 yr | 4.3 | 66 |
| Universities & colleges | 3.9 yr | 4.0 | 52 |
| Company career page | 3.5 yr | 4.0 | 47 |
| Job portals/websites | 2.8 yr | 3.8 | 35 |
| Networking events | 2.5 yr | 3.7 | 31 |
| Social media | 2.1 yr | 3.6 | 25 |
| Recruitment agencies | 1.7 yr | 3.6 | 20 |
Average days to fill open roles
Average
42 d
Median (P50)
38 d
Trend
↓ 4 d
Share of new hires retained (%)
How to readOf every 100 new hires, 92 are still here after 90 days
Attendance & timesheets Check-ins and monthly submissions
Share of scheduled days attended (%)
Percentage of scheduled work days where employees checked in
Share of timesheets submitted on time (%)
Share of leave used (%)
65%
658 days taken · 1,013 days available
Sick leave rate (%)
2.7%
Around 3 out of every 100 workdays were missed due to sickness
Share of unplanned leave (%)
18%
Of all leave taken
Sick, emergency, or requested less than 48h before start
Total unused leave (days)
1,840 days
Estimated $214,000 if all balances were paid out
Leave usage How much time off people used
Share of leave used by department (%)
Share of leave used each month (%)
Leave breakdown What kind of leave people take
Total leave days taken by type (days)
Average leave days taken per person (days)
Average days taken per employee, shown by gender
Unplanned leave Which departments have more last-minute leave
Share of last-minute leave by department (%)
Logistics
21%
21%
Finance
18%
18%
Operations
14%
14%
Sales
12%
12%
Engineering
7%
7%
HR
5%
5%
What this meansSick, emergency, or leave requested less than 2 days before it starts
Sick leave Time off because of illness
Sick leave rate over time (%)
Percent of workdays missed because of sickness
Unapproved absence Days missed without approval
Absence rate over time (%)
Remaining leave Days people still have available
Total unused leave and estimated cost (days and $)
Total balance days
1,840 days
Estimated cost
$214 thousand
| Leave type | Balance days | Estimated cost |
|---|---|---|
| Annual leave | 1,420 | $165 thousand |
| Sick leave carryover | 280 | $32 thousand |
| Other balances | 140 | $17 thousand |
Number of employees by remaining leave balance
How many leave days each person still has
Peak leave periods Months when most people take leave
Total leave days taken each month (days)
Employee leave register Leave usage by person
Employee leave status (list)
| Employee | Department | Entitled (days) | Used (days) | Remaining (days) | Sick used (days) | Share used (%) | Status |
|---|
All departments · 342 employees in scope
Total gross payroll
RWF 171M
June · ↑ 2.1% vs May
Total net payroll
RWF 137M
June · ↑ 2.0% vs May
Share of employees with benefits (%)
74%
253 of 342 · at least one allowance
Median net salary
RWF 400k
Middle 50%: RWF 280k – RWF 580k
Salaries Pay ranges and benefits
Salary range by role
Number of employees by benefit type
NoteEach allowance is counted separately
Payroll cost Gross spend and take-home pay
Total gross and net payroll by month
Overtime Extra hours and cost
Total overtime hours
Total overtime cost
Bonuses & deductions Year-end payments and payroll
Share of employees receiving bonuses (%)
Total deductions by type (RWF)
All departments · 342 employees in scope
Share of reviews completed (%)
71%
243 of 342 employees · goal 90%
Share of goals completed (%)
58%
Of active employee goals
Share of reviews on time (%)
83%
Finished before the deadline
Engagement score (out of 100)
72
Latest survey
Reviews Are reviews getting done?
Share of reviews completed by department (%)
Share of reviews completed over time (%)
Completed performance reviews
| Employee | Department | Role | Review period | Manager | Rating | Completed | On time? |
|---|
Showing8 completed reviews
Goals & ratings Progress and how people are scored
Share of goals completed by month (%)
Number of employees by latest rating
BreakdownExceeds 18%Meets 54%Below 20%On plan 8%
Review cycles When reviews run and whether they finish on time
Number of review cycles by status
Summary2 running now1 scheduled4 finished this year
Reviews finished on time (yes/no)
| Review period | Due date | Finished | On time? |
|---|
Improvement plans Employees getting extra support
Number of employees on a plan
| Employee | Department | Started | Review period | Status |
|---|
Engagement How employees feel and who is leaving
Engagement score over time (out of 100)
Voluntary turnover rate (%)
Share of survey responses (%)
Latest survey78% responded267 of 342 employees
Share of assets assigned (%)
87%
428 assigned · 64 available
Asset return rate (%)
91%
99 of 109 returned when employees left
Lost asset rate (%)
3.0%
14 lost of 492
Share of assets under warranty (%)
61%
300 of 492 under active warranty
34 assets expiring within 90 days
Assignment What is assigned to employees
Share of assets assigned by department (%)
Share of assets assigned over time (%)
Inventory What you own and current status
Number of assets by category
Number of assets by status
Returns Departments that return assets late
Asset return rate by department (%)
Logistics
85%
85%
Sales
88%
88%
Operations
90%
90%
HR
92%
92%
Finance
94%
94%
Engineering
96%
96%
Alerts14 overdue assignments5 damaged under warranty34 warranty expiring 90d
Loss Missing or written-off assets
Lost asset rate over time (%)
Condition State when assets are returned
Number of returns by condition
Warranty Coverage and expiry
Share of assets under warranty by category (%)
Under warranty
300
Expiring 90 days
34
| Category | Total | Covered | Rate |
|---|---|---|---|
| Laptops | 142 | 98 | 69% |
| Monitors | 98 | 54 | 55% |
| Phones | 76 | 48 | 63% |
| Tablets | 24 | 18 | 75% |
| Vehicles | 12 | 4 | 33% |
Number of assets with warranty expiring soon
Status300 active192 expired
Register Find any asset
Asset register (list)
| Asset | Serial No. | Category | Type | Status | Assigned to | Department | Warranty |
|---|---|---|---|---|---|---|---|
| MacBook Pro 14 | HZ-LTP-24-0012 | Electronics | Laptop | Assigned | J. Mukamana | Engineering | Active |
| Dell Monitor 27 | HZ-MON-23-0147 | Electronics | Monitor | Assigned | P. Niyonzima | Engineering | Active |
| iPhone 14 | HZ-PHN-24-0331 | Electronics | Phone | Assigned | A. Uwimana | Sales | Active |
| MacBook Air M2 | HZ-LTP-23-0284 | Electronics | Laptop | Assigned | C. Habimana | Finance | Expiring |
| iPad Air | HZ-TAB-24-0068 | Electronics | Tablet | Available | — | — | Active |
| Logitech MX Keys | HZ-ACC-22-0916 | Electronics | Accessory | Assigned | M. Keza | HR | Expired |
| Standing desk 160 | HZ-DSK-21-0442 | Furniture | Desk | Assigned | F. Nsengimana | Operations | — |
| Ergonomic chair Pro | HZ-CHR-21-0387 | Furniture | Chair | Assigned | J. Mukamana | Engineering | — |
| Filing cabinet 4-drawer | HZ-CAB-20-0179 | Furniture | Cabinet | Available | — | — | — |
| HP LaserJet Pro | HZ-PRN-23-0105 | Office equip. | Printer | Assigned | Shared · Finance | Finance | Active |
| Epson EB-X49 | HZ-PRJ-22-0033 | Office equip. | Projector | Assigned | Shared · HR | HR | Expiring |
| Canon imageRUNNER | HZ-PRN-22-0274 | Office equip. | Printer | In repair | Shared · Logistics | Logistics | Active |
| Toyota Corolla · RAB 412A | HZ-VEH-19-0011 | Vehicles | Vehicle | Assigned | Sales pool | Sales | — |
| Isuzu D-Max · RAB 887C | HZ-VEH-18-0007 | Vehicles | Vehicle | Assigned | Logistics pool | Logistics | — |
| Lenovo ThinkPad T14 | HZ-LTP-23-0419 | Electronics | Laptop | In repair | — | Operations | Active |
| Samsung Monitor 24 | HZ-MON-17-0062 | Electronics | Monitor | Retired | — | — | Expired |
| iPhone 13 | HZ-PHN-23-0290 | Electronics | Phone | Assigned | A. Uwimana | Logistics | Expiring |
| Conference chair (set of 8) | HZ-CHR-20-0525 | Furniture | Chair | Available | — | — | — |
Number of employees
Workforce
Definition
A headcount - the number of people currently employed and active in the selected filters (year, branch, contract type, etc.).
Formula
Count of employees with active employment statusCopyShare of employees working Full-Time (%)
Workforce
Definition
The share of your workforce on Full-Time schedules, shown as a percentage.
Formula
Full-Time employees / Total employees x 100CopyNumber of active contracts
Workforce
Definition
How many employment contracts are currently valid and in force. One employee may have one active contract.
Formula
Count of contracts where status is activeCopyNotes
The card subtitle also shows how many of those contracts end within the next 90 days.
Average tenure (years)
Workforce
Definition
How long employees typically stay with the company, measured in years.
Formula
Sum of tenure years for active employees / Number of active employeesCopyNumber of hires
Workforce
Definition
How many people started working in the selected year. A simple count of new hires.
Formula
Count of employees whose start date falls in the selected yearCopyNumber of leavers
Workforce
Definition
How many people left the company in the selected year. A simple count of exits.
Formula
Count of employees whose exit date falls in the selected yearCopyMedian employee age (years)
Workforce
Definition
The middle age of your workforce - not the average, but the age where half your employees are younger and half are older.
Formula
Middle value (median) of employee agesCopyShare of new hires retained at 90 days (%)
Workforce
Definition
Of everyone hired recently, what share is still employed 90 days after joining. A measure of early retention.
Formula
New hires still active at 90 days / New hires in period x 100CopyNumber of employees by department
Workforce
Definition
How many employees work in each department. This is a headcount (number of people).
Formula
Count of employees grouped by departmentCopyNumber of employees by role
Workforce
Definition
Headcount split across job roles.
Formula
Count of employees grouped by roleCopyNumber of employees by contract type
Workforce
Definition
How employees are distributed by contract type (e.g. permanent, fixed-term).
Formula
Count of employees grouped by contract typeCopyNumber of employees by work schedule
Workforce
Definition
Split between full-time and part-time schedules.
Formula
Count of employees grouped by schedule typeCopyNumber of employees by gender
Workforce
Definition
Gender breakdown of the workforce.
Formula
Count of employees grouped by genderCopyNumber of employees by age group
Workforce
Definition
Headcount in each age band.
Formula
Count of employees grouped by age bandCopyNumber of employees by marital status
Workforce
Definition
Distribution of employees by marital status.
Formula
Count of employees grouped by marital status (example: Single, Married, Divorced)CopyNumber of employees by age
Workforce
Definition
Shape of employee ages across the organisation.
Formula
Employee count per age value or narrow bandCopyNumber of employees by nationality
Workforce
Definition
Nationality mix of the workforce.
Formula
Count of employees grouped by nationalityCopyNumber of employees by education level
Workforce
Definition
Highest education level held by employees.
Formula
Count of employees grouped by education levelCopyShare of employees meeting role requirements (%)
Workforce
Definition
Whether employees have the minimum education level required for their job.
Formula
Employees meeting role requirement / Employees in role x 100CopyNumber of employees by education and department
Workforce
Definition
Education levels within each department.
Formula
Count of employees by department and education levelCopyNumber of contracts ending soon
Workforce
Definition
Contracts approaching their end date.
Formula
Count of contracts with end date within the alert windowCopyNumber of employees by tenure band
Workforce
Definition
How long employees have been with the company, grouped into bands.
Formula
Count of employees grouped by tenure band (years)CopyNumber of hires by recruitment channel
Workforce
Definition
Where new hires came from (referral, job board, agency, etc.).
Formula
Count of hires grouped by recruitment sourceCopyAverage days to fill open roles
Workforce
Definition
Average time from job opening to accepted offer.
Formula
Average(Offer accepted date − Role opened date)CopyShare of new hires retained (%)
Workforce
Definition
Over time, how many new hires remain with the company after joining.
Formula
New hires still active / New hires in cohort x 100CopyShare of scheduled days attended (%)
Workforce
Definition
What share of expected workdays employees actually showed up for.
Formula
Days present / Scheduled workdays x 100CopyShare of timesheets submitted on time (%)
Workforce
Definition
What share of timesheets were submitted before the deadline.
Formula
Timesheets submitted on time / Timesheets due x 100CopyShare of leave used (%)
Leave
Definition
What percentage of the leave allowance has already been taken.
Formula
Leave days taken / Leave days entitled x 100CopySick leave rate (%)
Leave
Definition
What share of scheduled workdays were missed because of sickness.
Formula
Sick leave days / Scheduled workdays x 100CopyShare of unplanned leave (%)
Leave
Definition
What share of all leave taken was not planned in advance - includes sick leave, emergencies, and requests made less than 48 hours before the leave starts.
Formula
Unplanned leave days / Total leave days taken x 100CopyTotal unused leave (days)
Leave
Definition
Total leave days employees have not yet taken - their remaining balance across the workforce.
Formula
Add up each employee's remaining leave balanceCopyNotes
The cost estimate shows what it would cost if all unused days were paid out: unused days x average daily pay per employee.
Share of leave used by department (%)
Leave
Definition
For each department, what percentage of entitled leave has been used so far.
Formula
Leave days taken by dept / Leave days entitled by dept x 100CopyShare of leave used each month (%)
Leave
Definition
Month by month, what percentage of entitled leave was consumed.
Formula
Leave days taken in month / Leave days entitled in month x 100CopyTotal leave days taken by type (days)
Leave
Definition
Total leave days taken, split by type (annual, sick, maternity, etc.).
Formula
Add up leave days grouped by leave typeCopyAverage leave days taken per person (days)
Leave
Definition
On average, how many leave days each employee has taken. Helps compare usage across teams or periods.
Formula
Total leave days taken / number of employeesCopyShare of last-minute leave by department (%)
Leave
Definition
Per department, what share of leave was requested less than 48 hours before it started.
Formula
Last-minute leave days by dept / Total leave days by dept x 100CopySick leave rate over time (%)
Leave
Definition
How the sick leave rate changes month by month or year by year.
Formula
Sick leave days in period / Scheduled workdays in period x 100CopyAbsence rate over time (%)
Leave
Definition
How overall absence (any unplanned time off) changes over time.
Formula
Absent days in period / Scheduled workdays in period x 100CopyTotal unused leave and estimated cost (days)
Leave
Definition
Shows remaining leave balances (in days) alongside the estimated payroll cost if those days were all paid out.
Formula
Unused days per employee; cost = unused days x average daily payCopyNumber of employees by remaining leave balance
Leave
Definition
Distribution of employees by remaining leave balance band.
Formula
Count of employees grouped by remaining leave balanceCopyTotal leave days taken each month (days)
Leave
Definition
Total leave days consumed per month.
Formula
Sum of leave days taken per calendar monthCopyEmployee leave status (list)
Leave
Definition
A person-by-person list showing each employee's leave allowance, days used, days remaining, sick leave taken, and overall leave status.
Formula
Per employee: remaining days = entitled days − used days; share used (%) = used days / entitled days × 100CopyTotal gross payroll
Compensation
Definition
Gross pay for all employees before deductions (tax, pension, etc.) in the selected period.
Formula
Sum of gross pay per employee in periodCopyTotal net payroll
Compensation
Definition
Take-home pay for all employees after deductions in the selected period.
Formula
Sum of net pay per employee in periodCopyShare of employees with benefits (%)
Compensation
Definition
Percentage of employees with at least one benefit (transport, housing, lunch, etc.).
Formula
Employees with ≥1 benefit / Total employees × 100CopyMedian net salary
Compensation
Definition
Middle value of net salary per employee after deductions.
Formula
Median of each employee's net salaryCopySalary range by role
Compensation
Definition
Low, median, and high salary spread within each job role.
Formula
Min, median, and max salary per roleCopyNumber of employees by benefit type
Compensation
Definition
Headcount receiving each benefit type, with share of workforce.
Total gross and net payroll by month
Compensation
Definition
Monthly comparison of gross vs net payroll totals.
Formula
Sum of gross pay and net pay per monthCopyTotal overtime hours
Compensation
Definition
Approved overtime hours worked beyond the regular schedule.
Formula
Sum of approved overtime hours in periodCopyTotal overtime cost
Compensation
Definition
Payroll cost of overtime: hours × overtime rate.
Formula
Overtime hours × applicable overtime rateCopyShare of employees receiving bonuses (%)
Compensation
Definition
Percentage of employees who received a bonus in the period.
Formula
Employees with bonus / Total employees × 100CopyTotal deductions by type
Compensation
Definition
Deduction amounts grouped by type (PAYE, pension, loans, other).
Formula
Sum of deductions grouped by typeCopyShare of reviews completed (%)
Performance
Definition
Percentage of employees due for a review who have completed it.
Formula
Completed reviews / Reviews due × 100CopyShare of goals completed (%)
Performance
Definition
Percentage of active employee goals marked complete.
Formula
Completed goals / Active goals × 100CopyShare of reviews on time (%)
Performance
Definition
Percentage of completed reviews finished before the due date.
Formula
On-time reviews / Reviews due × 100CopyEngagement score (out of 100)
Performance
Definition
Average employee engagement score from the latest survey (0–100).
Formula
Average survey score on a 0–100 scaleCopyShare of reviews completed by department (%)
Performance
Definition
Review completion rate for each department.
Formula
Completed reviews by dept / Reviews due by dept × 100CopyShare of reviews completed over time (%)
Performance
Definition
Review completion rate across review periods.
Formula
Completed reviews in period / Reviews due in period × 100CopyShare of goals completed by month (%)
Performance
Definition
Share of active goals completed each month.
Formula
Completed goals in month / Active goals in month × 100CopyNumber of employees by latest rating
Performance
Definition
Distribution of latest performance ratings (Exceeds, Meets, Below, On plan).
Formula
Count of employees grouped by rating bandCopyNumber of review cycles by status
Performance
Definition
Review cycles grouped by status: scheduled, running, or finished.
Formula
Count of review cycles by statusCopyReviews finished on time (yes/no)
Performance
Definition
Whether each review period was completed by its due date.
Formula
Finish date ≤ due date → on timeCopyNumber of employees on a plan
Performance
Definition
Employees currently on a performance improvement plan.
Formula
Count of employees with active improvement planCopyEngagement score over time (out of 100)
Performance
Definition
Engagement score trend across survey periods.
Formula
Average survey score by periodCopyVoluntary turnover rate (%)
Performance
Definition
Monthly rate of employees who chose to leave voluntarily.
Formula
Voluntary exits in month / Average headcount × 100CopyShare of survey responses (%)
Performance
Definition
Percentage of invited employees who completed the engagement survey.
Formula
Survey responses / Employees invited × 100CopyShare of assets assigned (%)
Assets
Definition
What share of all company assets are currently allocated to an employee (not sitting in storage).
Formula
Assigned assets / Total assets x 100CopyAsset return rate (%)
Assets
Definition
When assets must be returned (e.g. employee leaving), what share were successfully handed back.
Formula
Returned assets / Assets due for return x 100CopyNotes
Only counts returns that were expected - typically when someone leaves or changes role.
Lost asset rate (%)
Assets
Definition
What share of all assets have been marked as lost, stolen, or written off.
Formula
Lost or written-off assets / Total assets x 100CopyShare of assets under warranty (%)
Assets
Definition
What share of assets still have an active manufacturer or supplier warranty.
Formula
Assets with active warranty / Total assets x 100CopyNotes
The card subtitle highlights how many warranties expire within the next 90 days.
Share of assets assigned by department (%)
Assets
Definition
What share of each department's assets are currently assigned to employees.
Formula
Assigned assets in department / Total assets in department x 100CopyShare of assets assigned over time (%)
Assets
Definition
Month by month, what percentage of assets were assigned to employees vs sitting available.
Formula
Assigned assets in period / Total assets in period x 100CopyNumber of assets by category
Assets
Definition
Asset count split by category (electronics, furniture, etc.).
Formula
Count of assets grouped by categoryCopyNumber of assets by status
Assets
Definition
How assets are distributed by status (assigned, available, lost, etc.).
Formula
Count of assets grouped by statusCopyAsset return rate by department (%)
Assets
Definition
Per department, what share of assets due for return were actually returned.
Formula
Returned assets by dept / Assets due for return by dept x 100CopyLost asset rate over time (%)
Assets
Definition
How the lost asset rate changes over time.
Formula
Lost assets in period / Total assets in period x 100CopyNumber of returns by condition
Assets
Definition
Condition of assets when returned (good, fair, damaged).
Formula
Count of returned assets grouped by conditionCopyShare of assets under warranty by category (%)
Assets
Definition
For each asset type (laptops, monitors, phones, etc.), what percentage still have an active warranty. Shown as a rate per category, not a total count.
Formula
Assets with active warranty in category / Total assets in category x 100CopyNotes
Example: 69% for laptops means 69 out of every 100 laptops are still covered. Compare categories to see where warranty gaps are highest.
Number of assets with warranty expiring soon
Assets
Definition
Assets whose warranty ends within the alert window.
Formula
Count of assets with warranty end date within 90 daysCopy