Executive Summary A strong monthly HR dashboard is less about “reporting everything” and more about driving weekly/ monthly HR decisions. Build it around 5–6 core metrics families (Headcount, Hiring, Attrition, Attendance, Leave, Grievances) with consistent definitions, trend views, and clear drill-downs. Use a balanced view: “What happened?” + “Why might it be happening?” + “What actions will we take next month?”

Key Recommendations

1. Start with metric definitions (so the numbers are trustworthy)

Before building charts, lock the definitions with HR Ops/Payroll:

• Headcount
• Opening headcount / Closing headcount
• Active employees only (exclude interns/contractors if not comparable)
• Org views: function, location, level/grade, employment type
• Hiring
• Hires (net + gross), by month and source/channel if possible
• New hires vs target/plan (if you have workforce plan)
• Time-to-fill (optional but highly useful)
• Attrition
• Monthly attrition rate and annualized rate (optional)
• Voluntary vs involuntary (involuntary includes performance, role redundancy where applicable)
• Attrition by tenure band and level (this is where root causes hide)
• Attendance
• Attendance rate / Absenteeism days (or hours)
• Late arrivals (if tracked) and overtime exception (if relevant)
• By team/location/shift (attendance problems are usually localized)
• Leave
• Leave utilization rate (leaves taken vs eligible, if policy-based eligibility exists)
• Total leave days by type: sick, casual, earned/annual, maternity/paternity, unpaid (as per your policy)
• Leave balance carry-forward/encashment indicators (optional, but helpful for planning)
• Grievances
• Grievances raised (count) + category distribution
• Aging: Open >30 days, >60 days
• Closure rate within SLA (if you have an SLA)
• Reopened cases (quality signal)

1. Design the dashboard around “decision questions”

For each metric family, ensure you can answer:

• Are we trending better or worse than last month and last year?
• Is variance concentrated in one location/team/level?
• Are we meeting plan/targets (hiring) and controlling risk (attrition/grievances/attendance)?
• What corrective actions are planned for next month?

1. Use a consistent structure every month (executive-friendly)

Recommended dashboard layout (single page + drill-down tabs):

• Top bar: KPI strip (month vs last month vs same month last year)
• Section A: Headcount
• Section B: Hiring
• Section C: Attrition
• Section D: Attendance
• Section E: Leave
• Section F: Employee Grievances
• Bottom: “Action Log” (what HR will do next month, owner, due date)

1. Use “3 views” for every KPI

To keep it interpretable, show:

• Trend: current month vs previous 5–12 months (line chart)
• Composition: split by location/function/level (stacked bar/pie)
• Variance drill: highlight top 3 contributors to change (table with color coding)

1. Build in data quality checks (HR dashboards fail on this)

Each month, pre-check:

• Attendance and leave completeness (missing punches / incomplete leave approvals)
• Grievance status accuracy (open/closed correctly captured)
• Headcount reconcile: opening + movements = closing (hires - leavers + transfers)
• One-time changes: policy change effects, bulk closures, location reorgs

Key Dashboard Metrics (recommended starting set) A) Headcount

• Closing headcount
• Net headcount change (month)
• Headcount by department/location (top 10)
• % of workforce by employment type (if relevant)

B) Hiring

• Total hires (gross) this month
• New hires vs plan/target (if available)
• Hiring funnel metrics (optional): applicants → shortlisted → offered → joined
• Time-to-fill (optional)

C) Attrition

• Monthly attrition count and rate
• Voluntary attrition rate vs involuntary
• Attrition by tenure band (e.g., 0–6 months, 6–12, 1–3 years, 3+)
• Attrition by function/location (top drivers)

D) Attendance

• Attendance rate (or total present days ÷ expected days)
• Absenteeism: % employees with >X absence days (e.g., >3 days) + total absence days
• Late arrivals (if tracked)
• Shift/location comparison

E) Leave

• Total leave days taken this month
• Leave utilization rate (if eligible leave is defined)
• Leave by type (sick/casual/annual/unpaid etc.)
• Leave concentration: top departments by leave days per FTE

F) Employee Grievances

• Grievances opened this month
• Open grievances count
• Closure rate
• Aging: open >30/60 days
• Category breakdown (e.g., process, compensation, HR policy, harassment, work conditions—use your categories)
• Escalations to leadership (counts only)

Business Impact

• Attrition: Helps protect business continuity, reduces re-hiring cost, and prevents capability gaps in critical roles.
• Attendance & Leave: Early signals of team burnout, manager effectiveness issues, process bottlenecks, or staffing mismatch.
• Grievances: Reduces legal/brand risk, improves retention, and strengthens trust in HR processes.
• Hiring: Ensures workforce plans translate into timely execution and prevents understaffing or overtime spikes.

Risks (and how to mitigate them)

• “Garbage in, garbage out”: Incorrect headcount/attendance/leave approvals will mislead leadership.
• Mitigation: monthly reconciliation + automated validation rules.
• Metric overload: Too many charts become noise.
• Mitigation: start with the minimum set above; add advanced metrics only after 2–3 cycles.
• Definitions drift across teams.
• Mitigation: publish a 1-page “Metric Definitions & Rules” document and version-control it.

Immediate Next Steps (practical build plan)

1. Create the Metric Definitions Sheet (Day 1–2)

• For each KPI: numerator, denominator, filters, exclusions, and reporting level (month/team/location).

1. Confirm Data Sources + Owners (Day 2–4)

• HRIS/payroll for headcount & moves
• ATS/HRMS for hiring
• Attendance system for punches and attendance status
• Leave module/approvals for leave
• Grievance workflow for cases and categories

1. Build the Dashboard MVP (Week 1–2)

• KPI strip + 6 sections with 1 trend chart and 1 drill-down table each
• Include last month and last year comparisons
• Add “Action Log” area for HR/line actions

1. Pilot with Leadership (End of Week 2)

• Use a real prior month data set
• Ask: “Which 3 decisions did this dashboard help make?”

1. Iterate Monthly (ongoing)

• Add 1–2 improvements per month: a driver analysis view, SLA compliance for grievances, attrition cohort view, etc.

Suggested KPIs & Calculation Notes (highly recommended)

• Attrition rate (example approach): (Leavers in month ÷ average headcount for month) × 100
• Attendance rate (example approach): Present days ÷ expected working days (for eligible population)
• Leave utilization (example approach): Leave taken days ÷ eligible days (if eligibility exists; otherwise track leave days per FTE as a simpler alternative)
• Grievance closure rate: Closed within SLA ÷ total grievances closed (or total grievances opened, depending on your tracking standard)

(Exact formulas should match your HRIS/leave policy structure—use the definitions sheet to lock them.)

Up to 3 quick questions (only if you want the dashboard tailored precisely)

1. Are you using a single HRIS/HRMS for headcount, leave, and grievances (or separate systems)?
2. How do you define “attrition” in your organization (only voluntary, or voluntary + involuntary)?
3. What’s your attendance tracking basis: punches (late/absent) or HR’s attendance status per day?

If you need help implementing these recommendations or would like expert guidance tailored to your organization, the team at Zunavish would be happy to assist.