HR Analytics Dashboard
A workforce analytics report built on the IBM HR Analytics dataset (1,470 employees), enriched with synthetic hire and termination dates to enable time-based analysis. The focus is on understanding who is leaving, who is performing, and why — through composite predictive scoring and internal pay equity analysis.
The report covers five pages: workforce overview with KPI sparklines, a filterable employee detail table, an attrition analysis page, a performance analysis page, and a self-documenting data dictionary.
Key Features
- Internal Pay Equity (Compa-Ratio) — measures each employee's salary relative to the peer median for their role and level, surfaced in scatter charts and the detail table
- Attrition by Performance Segment — separates high performer and bottom performer attrition rates to identify whether the company is losing critical talent or experiencing natural turnover
- Composite Predictive Scores — an Attrition Risk Score and a Performance Predictor Score (both 0–1), built using AVERAGEX to score each employee individually across multiple weighted factors derived from the data
- Active Filter Counter — a "hidden" filter badge that tracks how many slicers are currently applied and lists them by name in a tooltip, keeping context visible across all pages
- Dynamic Data Dictionary — all measures and columns are documented via /// TMDL descriptions and surfaced live through INFO.VIEW.* functions into a searchable model documentation page — no manual maintenance required
1 Reply
can you please share this pbix file for reference?
