Skip to content
ZYNXTECH

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.

OverviewIndustry TrendsSkillset AnalysisExperience InsightsSalary TrendsLocation DetailsDiversity
Candidates
Joined
Exp. CTC
Incr. %
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.