Hiring Process
Analysis Project
Project Description
This project focuses on analyzing hiring process data to gain valuable insights that can help optimize
the company’s recruitment strategies. The primary objective was to identify trends in hiring patterns,
including gender distribution, salary analysis, and departmental proportions. The approach involved
handling data systematically, using statistical methods and visualization techniques to derive
actionable insights.
Approach
1. Data Cleaning:
o Identified and handled missing or invalid data such as 'Don't Want to Say' and '-' in
the Gender column.
o Standardized the dataset to ensure consistency and accuracy.
2. Analysis:
o Gender Distribution: Used Excel functions to determine the count of male and
female hires.
o Salary Analysis: Calculated the average salary, grouped salary ranges into class
intervals, and computed their frequencies.
o Departmental Analysis: Visualized the proportion of employees in various
departments.
o Position Tier Analysis: Created visualizations to explore the distribution of positions
across different levels.
3. Visualization:
o Generated bar charts, pie charts, and line graphs for easy interpretation of trends
and patterns.
o Created cumulative frequency graphs for salary analysis.
4. Insights & Reporting:
o Summarized insights with clear data visualizations.
o Used SQL for advanced queries and included snapshots of the query outputs in the
report.
Tech-Stack Used
1. Microsoft Excel 2022:
o Used for data cleaning, calculations (e.g., averages, percentages, frequencies), and
visualizations (bar charts, pie charts, etc.).
2. MySQL Workbench 8.0:
o Used for running SQL queries to explore advanced analytics. Snapshots of queries
and results are included in the report.
3. Google Drive:
o Used to store the final report and the linked Excel sheet for easy sharing.
Insights
1. Gender Distribution:
o A higher percentage of males were hired compared to females, indicating potential
room for diversity initiatives.
2. Salary Analysis:
o The average salary offered was approximately ₹75,000, with a significant proportion
of employees falling in the ₹60,001–₹90,000 range.
o A cumulative frequency chart showed that most employees earned below ₹90,000.
3. Departmental Analysis:
o Certain departments (e.g., Sales and IT) had a higher concentration of employees,
suggesting a need for balancing resource allocation across departments.
4. Position Tier Analysis:
o Entry-level positions dominated the hiring process, indicating a focus on building
foundational teams.
Results
Successfully analyzed hiring trends and identified critical areas for improvement, such as increasing
gender diversity and addressing salary imbalances. Developed a scalable template for future hiring
process analytics and improved understanding of how to use Excel and SQL to analyze large datasets.
Drive Link
Access the project report and associated Excel file here:
Hiring Process Analysis - Google Drive
(https://docs.google.com/spreadsheets/d/1_l4clDW6eezZuv0wo3PBxRqBTyZKU9x3/edit?
usp=drive_link&ouid=101371966282785241371&rtpof=true&sd=true)
SQL Queries and Outputs
Query 1: Count of Hires by Gender
sql
Copy code
SELECT Gender, COUNT(*) AS Count_of_Hires
FROM HiringData
GROUP BY Gender;
Output:
Gender Count_of_Hires
Male 7,621
Female 5,341
Query 2: Salary Range Distribution
sql
Copy code
SELECT
CASE
WHEN Salary BETWEEN 0 AND 30000 THEN '0-30,000'
WHEN Salary BETWEEN 30001 AND 60000 THEN '30,001-60,000'
WHEN Salary BETWEEN 60001 AND 90000 THEN '60,001-90,000'
WHEN Salary > 90000 THEN '90,001+'
END AS Salary_Range,
COUNT(*) AS Frequency
FROM HiringData
GROUP BY Salary_Range;
Output:
Salary Range Frequency
0-30,000 2,121
Salary Range Frequency
30,001-60,000 4,362
60,001-90,000 6,504
90,001+ 7,164
