HR Analytics Dashboard

A complete HR analytics report built from a single employee spreadsheet — no Power BI, no data warehouse, no IT ticket. Every number below is live and responds to the filters at the top of the dashboard.

What it covers

• Workforce snapshot — headcount, average salary, average tenure and average overtime hours as KPI cards that recalculate on every filter change.
• Department analysis — headcount by department, plus average salary by department against a company-wide average reference line, so you can see instantly which teams sit above or below the mean.
• Hiring trend — new hires by year, with a year-over-year comparison card for 2023 vs 2024.
• Attrition — exit reasons as a Pareto chart, ranking causes by frequency alongside the cumulative percentage, so the vital few reasons driving most departures are obvious.
• Pay equity — average manager pay compared directly against average employee pay, with the gap shown as a difference.
• Workforce composition — headcount by office location, gender breakdown, and average overtime hours by department.

How to read it

Use the slicers to filter by hire year, department or employment status. Selections apply to every chart at once — filter to a single department and the KPIs, trends and exit reasons all recalculate for that team only.

Build one from your own data

This dashboard started as one Excel file. Upload your own employee export to Mizantiq, pick your columns, and build the same kind of report in minutes — free, from your browser or your phone.