This is a plug and play Recuitment Dashboard template created in Power BI, wherein which you input your data into a simple excel file and you’ll get sleek, sophisticated and insightful Dashboard ready in minutes.
Dashboard Video Tour
The Dashboard comprises of 3 key analysis segments.
- Positions Overview – Broad insights about the position details and the ability to drill into Interviews and Cost.
- Candidate Interviews – Detailed interview analysis for each candidate including the interview stages.
- Recruitment Cost Analysis – Detailed cost analysis + performance of hiring channels and the cost of subscription services.
Screen 1 – Position Analysis
The Objective of this screen is to give you a “30,000 feet” view of most important Recruitment Metrics in one snapshot, including the ability to filter and deep dive into the key elements of the Dashboard.
Key Metrics – Positions, Hires Completed, Balance Hires, % Completion, Offered but not joined, Hiring Cost, Applications, Hire Days v/s Target Hire Days, Backed and Rejected
Key Features
- Filter all the metrics by – Level, Recruiter, Business, Department and Location.
- Positions and Hiring Trend till date.
- Drill down to see all the interviews/applications for a particular position.
- KPIs- Hiring Completed, Under or Over Hired.
- Segregation of Open Positions in Bands – 0-30 Days, 31-60 days and so on.
Screen 2 – Interview / Application Analysis
The Objective of this screen is to deep dive into candidate level interview metrics + analyse the recruitment stage funnel.
Key Metrics – Some Metrics are carried forward from the Overview Sheet, the additional ones are – Last CTC and CTC Offered, CTC Growth, Delta from the Average CTC, Cost of each hire
Key Features and Visuals
- Applications and Hires from different sources.
- Trend for Applications and Hires till date.
- Applications at each stage of the Interview Process.
- Candidates joined until the current period.
Screen 3 – Recruitment Cost Analysis
The Objective of this screen is provide an in depth cost analysis for direct recruitment cost (consultants, employee referrals etc..) and indirect cost (cost of portal subscriptions)
Key Metrics – Candidate Hire Cost, Indirect Portal / Service Cost, Hire Cost / Candidate, Hire to Application Ratio.
Key Features and Visuals
- Breakdown of Hiring Cost by Business, Hiring Source etc..
- Analysis of Portal / Service Cost (Subscription Value, Utilized and Balance Value, Hiring Efficiency etc..)
- Analysis of Direct Hiring Cost by each Requisition.
More on this Dashboard
I have written everything about the Recruitment Dashboard on my blog and this template can be purhcased from the same like.
