This project is an HR Analytics Dashboard built to track and analyze candidate data collected through Google Forms. The dashboard provides insights into recruitment performance, candidate distribution, and hiring trends.
- Data is collected using Google Forms
- Candidates fill their details directly
- Data is automatically stored in Google Sheets
- Dashboard is connected for real-time updates
- Microsoft Excel / Power BI
- Google Forms
- Google Sheets
- Data Cleaning & Transformation
- 📌 Total Vacancy & Current Vacancy Tracking
- 👨💼 Candidate Interview Data Analysis
- 📊 Week-wise Continue vs Discontinue Analysis
- 👥 Gender Distribution
- 🎓 Qualification Analysis
- 🧠 Experience Breakdown
- 📍 Position-wise Application Count
- 📋 Candidate Details Table
📄 Download Full Dashboard (PDF): Click Here
- Majority candidates are from specific job roles
- Gender ratio analysis for hiring decisions
- Experience distribution helps in role planning
- Hiring vs vacancy gap tracking
- HR Teams for recruitment tracking
- Data-driven hiring decisions
- Candidate pipeline management
This project uses dummy/modified data for portfolio purposes. No confidential company data is shared.
- Name: Ashish Ranjan
- 📧 Email: ashishranjan11211@gmail.com
- 🔗 LinkedIn: linkedin.com/in/ashishranjanji09
⭐ If you like this project, give it a star!