The HR Recruitment Analysis Dashboard provides a comprehensive overview of recruitment performance, helping HR teams and decision-makers track key hiring metrics, identify bottlenecks, and optimize the overall recruitment process.
This project was built using Power BI with a structured dataset to generate actionable insights for talent acquisition and workforce planning.
#Insights Recruitment Funnel Analysis – Tracks candidate flow from applications to final selection. Hiring Trends – Visualizes recruitment trends across departments, job roles, and time. Source Effectiveness – Evaluates which job portals or hiring channels bring the most successful candidates. Diversity Insights – Analyzes candidate demographics such as gender distribution. Recruitment KPIs – Includes Time-to-Hire, Offer Acceptance Rate, and Attrition in hiring stages.
Source: HR Recruitment Data (CSV/Excel imported into Power BI).
Data Includes:
1.) Candidate Details (ID, Name, Gender, Qualification, Experience)
2.) Application Source (Referral, Job Portal, Walk-in, etc.)
3.) Recruitment Stage (Applied, Shortlisted, Interviewed, Hired)
4.) Hiring Department & Job Role
5.) Timeline of Applications
#Tools & Technologies
1.) Power BI Desktop – Dashboard creation & visualization
2.) DAX (Data Analysis Expressions) – For calculated measures and KPIs
3.) CSV/Excel Dataset – Recruitment data source
#How to Use
1.) Clone the repository:
git clone https://github.com/your-username/hr-recruitment-analysis.git
2.) Open Rec DB.pbix in Power BI Desktop.
3.) Connect/refresh dataset if needed.
4.) Explore interactive visualizations and insights.
#This project demonstrates how Power BI can turn HR recruitment data into actionable insights, helping businesses make informed hiring decisions.