HR Analytics
An attrition report that lets the reader choose the question.
Eight Power BI pages on employee attrition and retention. Dynamic tables and charts built on field parameters, an A/B comparison with decomposition trees, a Python correlation heatmap and a page for plain-language questions.
- report pages
- 8report pages
- slicers on every page, plus a text search
- 11slicers on every page, plus a text search
- decomposition trees side by side for A/B comparison
- 2decomposition trees side by side for A/B comparison
- Python visual for the correlation heatmap
- 1Python visual for the correlation heatmap
Pages
| Page | What it shows |
|---|---|
| Overview | Headcount, employees retained and lost, and average job, environment and relationship satisfaction and work-life balance. Attrition and retention by years worked, leavers by age group and by gender, and a matrix of attrition by job role and department. |
| Dynamic Table | A matrix where the reader picks the rows, the columns and the measure from slicers. |
| Dynamic Graph | The same three choices, drawn as a clustered column chart. |
| A/B Comparison | Two decomposition trees next to each other, so two groups can be broken down the same way and compared. |
| Key Influencers | The share of leavers and stayers across experience bands, as 100% stacked columns, with the same row, column and measure controls. |
| Correlation Heatmap | A Python visual showing how the numeric attributes move together. |
| Custom NLP Prompt | A Q&A visual for questions in plain language. |
| Raw Data | The employee table, filtered by the same slicers as everything else. |
Slicing
Every page carries the same panel: department, job role, age group, gender, salary slab, marital status, education field, business travel, overtime, distance from home and years since the last promotion, plus a free-text search. Experience, hourly rate and distance are pre-grouped into bands so the slicers stay readable.
Why field parameters
Most HR reports answer a fixed set of questions, and each new question becomes a request for a new chart. Here the reader chooses the rows, columns and measure, so “attrition by job role and overtime” and “satisfaction by department and travel” come from the same page.
Opening it
The repository holds HR Analytics.pbix (about 1 MB). It uses the Sunburst, Text Filter and Text Search Slicer custom visuals, which are packaged inside the file, and the correlation page needs Python visuals enabled in Power BI Desktop.