TelNova Communications · Workforce Intelligence
Every figure below is generated from HR_Analytics_Workbook.xlsx — the same workbook HR business partners use for reporting. This page opens instantly from a build-time snapshot; use Reload live from Excel to re-read the workbook directly when serving this project over a web server.
KPI_DashboardActual reconstructed monthly headcount, blended trend/growth-target forecast.
Holt's linear exponential smoothing, α=0.35, β=0.25.
Salary ÷ market benchmark
Female avg. salary as % of male avg., same level
Terminated ÷ (active + terminated), all-time
Share of all departures, by tenure cohort when they left
Applicants → interviewed → offered → accepted
Hires produced per channel and average cost-per-hire
Hours completed, trailing 12 months
Each point is one employee — highlighted points are flagged high-potential
Share of active employees with ≥1 promotion
Workforce_Forecast, Hiring_Plan and Attrition_Risk sheets for full methodologyReplacement hires (covering forecast attrition) + growth hires, by month
Top 15 active employees by risk score, with the leading contributing factors
| Employee | Department | Job Title | Tenure (yrs) | Risk Score | Band | Top Drivers |
|---|