Kpiloom

HR Dashboard Templates

Ready-made hr dashboards that tracks your people: hiring, attrition, attendance, training and pay in one place. Choose your platform, then your industry.

The 8 KPIs every hr dashboard should track

KPIWhat it tells youFormula
HeadcountNumber of active employees at period end.COUNT of employees with status = Active
Attrition rateShare of employees who left in the period.Leavers ÷ Average headcount
Time to hireAverage days from job opening to offer accepted.AVERAGE of (Offer accepted − Opening date)
Open positionsRoles approved but not yet filled.COUNT of open requisitions
AbsenteeismShare of scheduled work time lost to unplanned absence.Days absent ÷ Scheduled working days
Training hoursTotal hours of learning completed.SUM of training hours logged
eNPSHow likely employees are to recommend you as a workplace.% Promoters − % Detractors
Avg salaryAverage monthly pay per employee.Total payroll ÷ Headcount

HR dashboards by industry

IndustryExcelGoogle SheetsPower BILooker Studio
RetailExcelGoogle SheetsPower BILooker Studio
E-commerceExcelGoogle SheetsPower BILooker Studio
SaaSExcelGoogle SheetsPower BILooker Studio
RestaurantExcelGoogle SheetsPower BILooker Studio
Café & BakeryExcelGoogle SheetsPower BILooker Studio
HotelExcelGoogle SheetsPower BILooker Studio
Real EstateExcelGoogle SheetsPower BILooker Studio
ConstructionExcelGoogle SheetsPower BILooker Studio
ManufacturingExcelGoogle SheetsPower BILooker Studio
LogisticsExcelGoogle SheetsPower BILooker Studio
ClinicExcelGoogle SheetsPower BILooker Studio
HospitalExcelGoogle SheetsPower BILooker Studio
Dental PracticeExcelGoogle SheetsPower BILooker Studio
PharmacyExcelGoogle SheetsPower BILooker Studio
Gym & FitnessExcelGoogle SheetsPower BILooker Studio
Salon & SpaExcelGoogle SheetsPower BILooker Studio
Coaching InstituteExcelGoogle SheetsPower BILooker Studio
SchoolExcelGoogle SheetsPower BILooker Studio
UniversityExcelGoogle SheetsPower BILooker Studio
Marketing AgencyExcelGoogle SheetsPower BILooker Studio
ConsultingExcelGoogle SheetsPower BILooker Studio
Law FirmExcelGoogle SheetsPower BILooker Studio
Accounting FirmExcelGoogle SheetsPower BILooker Studio
InsuranceExcelGoogle SheetsPower BILooker Studio
BankingExcelGoogle SheetsPower BILooker Studio
FintechExcelGoogle SheetsPower BILooker Studio
AutomotiveExcelGoogle SheetsPower BILooker Studio
Car DealershipExcelGoogle SheetsPower BILooker Studio
AgricultureExcelGoogle SheetsPower BILooker Studio
Food ProcessingExcelGoogle SheetsPower BILooker Studio
FMCG DistributionExcelGoogle SheetsPower BILooker Studio
WholesaleExcelGoogle SheetsPower BILooker Studio
Kirana StoreExcelGoogle SheetsPower BILooker Studio
Fashion & ApparelExcelGoogle SheetsPower BILooker Studio
JewelleryExcelGoogle SheetsPower BILooker Studio
Electronics StoreExcelGoogle SheetsPower BILooker Studio
FurnitureExcelGoogle SheetsPower BILooker Studio
PharmaExcelGoogle SheetsPower BILooker Studio
TelecomExcelGoogle SheetsPower BILooker Studio
Solar & EnergyExcelGoogle SheetsPower BILooker Studio
Non-profitExcelGoogle SheetsPower BILooker Studio
EventsExcelGoogle SheetsPower BILooker Studio
Travel AgencyExcelGoogle SheetsPower BILooker Studio
Media & PublishingExcelGoogle SheetsPower BILooker Studio
GamingExcelGoogle SheetsPower BILooker Studio
Creator BusinessExcelGoogle SheetsPower BILooker Studio
FreelancerExcelGoogle SheetsPower BILooker Studio
StartupExcelGoogle SheetsPower BILooker Studio
IT ServicesExcelGoogle SheetsPower BILooker Studio
Security ServicesExcelGoogle SheetsPower BILooker Studio
Cleaning ServicesExcelGoogle SheetsPower BILooker Studio
Printing & PackagingExcelGoogle SheetsPower BILooker Studio
Pet CareExcelGoogle SheetsPower BILooker Studio

Questions

What is a hr dashboard?

A hr dashboard is a single page that tracks your people: hiring, attrition, attendance, training and pay in one place. It pulls the key hr KPIs, such as headcount, attrition rate, time to hire and open positions, into charts and tables that update when your data changes.

Which tool is best for a hr dashboard?

Excel suits offline work and small teams. Google Sheets is best for sharing and live collaboration. Power BI handles large data and drill-down. Looker Studio is free and great with Google data. Every Kpiloom hr dashboard comes in all four.

Which KPIs should a hr dashboard track?

Start with headcount, attrition rate, time to hire, open positions, absenteeism, training hours, eNPS and avg salary. The table on this page explains each one and how it is calculated.