People Analytics & Workforce Dashboard | HR KPI Excel + Google Sheets

Description
📊 PEOPLE ANALYTICS & WORKFORCE DASHBOARD

Turn scattered HR data into a clear, structured and management-ready workforce reporting system.


The People Analytics & Workforce Dashboard combines workforce KPIs, recruiting, attrition, absence, compensation, performance and engagement tracking in one professional Excel solution.


It is designed for recurring HR reviews, People Operations reporting and leadership discussions — without macros, add-ins or complicated HR software.


💎 PROFESSIONAL HR ANALYTICS SYSTEM
✅ 12 Executive KPI Cards
✅ 6 Workforce Dashboard Charts
✅ 7 Structured HR Data Modules
✅ Reporting Controls for Year, Month, Region, Department, Location & Date
✅ Automated Calculations
✅ INPUT / AUTO Guidance
✅ Dropdowns & Data Validation
✅ 15 Sample Records in Every Operational Module
✅ Bonus Pulse Survey & eNPS Tracker
✅ 5-Page How-to Guide
✅ Fully Editable
✅ No Macros / VBA
✅ No PowerQuery
✅ No External Workbook Connections


📈 EXECUTIVE WORKFORCE DASHBOARD
Monitor important workforce indicators including:
– Active Headcount
– FTE
– Hires
– Open Requisitions
– Average Time-to-Fill
– Offer Acceptance
– Leavers
– Retention Rate
– Absence Days
– Average Engagement
– Women in Workforce
– Pay Equity Flags


Six visual charts provide additional workforce and HR trend analysis.


Reporting controls allow management views to be filtered according to the available source data.


👥 COMPLETE HR DATA WORKFLOW
The main workbook contains:
🧭 Start & Navigation
📊 Executive Dashboard
👥 Employee Roster
📈 Headcount Snapshots
🎯 Hiring Pipeline
📉 Attrition Log
🌿 Absence & Wellbeing
💰 Compensation & Equity
⭐ Performance & Engagement
⚙️ Settings & Lists


Each operational module includes 15 realistic demonstration records to show how the system works before you replace the examples with your own data.


🎯 RECRUITING & ATTRITION
The Hiring Pipeline tracks:
– Open roles
– Recruiting stages
– Candidates
– Offers
– Hires
– Days Open
– Time-to-Fill
– Cost-per-Hire


The Attrition Log supports:
– Voluntary and involuntary exits
– Termination reasons
– Regrettable losses
– Tenure at exit
– Exit interview information


🌿 ABSENCE, COMPENSATION & TALENT
Track absence and wellbeing information including leave types, wellbeing check-ins and return-to-work follow-up.


The Compensation & Equity module includes:
– Salary information
– Salary benchmarks
– Compa-Ratio
– Bonus targets
– Pay Equity Flags
– Equity eligibility
– Total Reward Value


Performance & Engagement supports:
– Performance ratings
– Goal achievement
– Engagement scores
– eNPS responses
– Training hours
– Promotion readiness
– High-potential indicators
– Talent risk signals


🎁 BONUS PULSE SURVEY & eNPS MINI TRACKER
A separate Excel workbook is included for lightweight employee listening.
It contains:
– Start
– Pulse Responses
– Executive Summary


The bonus workbook provides:
✅ 15 Sample Survey Responses
✅ 8 KPI Cards
✅ 2 Charts
✅ Automatic eNPS Classification
✅ Promoter / Passive / Detractor Analysis
✅ Response Rate
✅ Average Engagement
✅ Stay Risk Signals
✅ High Workload Signals


👥 IDEAL FOR
🏢 HR Managers & People Operations
📊 HR Analysts
👔 Managers & Leadership Teams
🚀 Startups & Scale-Ups
🏭 Small & Mid-Sized Businesses
💼 HR Consultants
🎯 Founders & Operations Teams
📈 Organizations with recurring workforce reporting


🌐 EXCEL & GOOGLE SHEETS
Microsoft Excel Desktop is recommended for the intended formatting and dashboard experience.
The XLSX files can also be imported into Google Sheets.
After conversion, chart positioning, fonts, dropdown behavior, row heights or other Excel-specific formatting may vary slightly.


⚖️ IMPORTANT DISCLAIMERThis toolkit is designed for organization, workforce reporting, analysis and planning purposes.
It does not constitute legal, employment, HR, financial, medical, privacy or other professional advice.
All calculations and outputs depend on the accuracy and completeness of the information entered.
Users remain responsible for validating results, protecting sensitive employee information and complying with applicable privacy, employment and internal company requirements.