HR Recruitment
A candidate pipeline, from source to joining date.
Seven Power BI pages on a recruitment pipeline. Where candidates come from and how far they get, their skills and experience, current against expected pay, where they are against where the jobs are, and how the pipeline splits by gender.
- report pages
- 7report pages
- slicers on every page
- 7slicers on every page
- KPI cards across the report
- 16KPI cards across the report
- current against expected, by mean and median
- CTCcurrent against expected, by mean and median
Pages
| Page | What it shows |
|---|---|
| Overview | Total candidates, how many joined, average expected CTC and the average increment asked for, with candidates by screening status and by source. |
| Industry Trends | Average current and expected CTC, the increment asked for and average experience, month by month. |
| Skillset Analysis | One row per skill set: candidate count, average and median current and expected CTC, experience and increment. |
| Experience Insights | Average and median experience, the increment asked for in each experience band, and the gender mix of each band. |
| Salary Trends | Average current and expected CTC and increment, broken down by experience band and by current CTC band. |
| Location Details | Where candidates are now, where the jobs are, and the increment asked for by location status. |
| Diversity | The pipeline by gender, median current and expected CTC for men and women, and gender against on-base and off-base location status. |
Slicing
Every page shares seven slicers: gender, hybrid preference, work from home, application status, notice period, experience band and date. Experience and current CTC are sorted into ordered categories so the bands read low to high instead of alphabetically.
Medians as well as means
Pay figures in hiring data are skewed by a few senior candidates, so the skill-set table and the diversity page show the median next to the average for current and expected CTC, and for experience. The gap between the two is often the more useful number.
Opening it
The repository holds HR Recruitment.pbix (about 1.3 MB). Open it in Power BI Desktop.