Hiring Process Analytics

Excel-based analysis of a company's hiring process — gender distribution, salary benchmarking, departmental composition, and outlier detection.

Overview

This project analyzes a multinational company's hiring dataset to uncover trends in recruitment, diversity, and compensation. Findings inform HR strategy for more equitable and efficient hiring practices.

Key Analyses

• Gender Distribution: Breakdown of male vs. female hires across departments and roles
• Salary Benchmarking: Average compensation by department and experience level
• Departmental Composition: Headcount distribution across business units
• Outlier Detection: Identifying salary anomalies using statistical methods (IQR)
• Tier Representation: Distribution of hires across seniority levels
• Rejection Rate Analysis: Offer acceptance and rejection patterns by role type

Files

├── Statistics.xlsx   # Hiring dataset with offer details, salaries, and demographics
├── PPT.pdf           # Full analysis with charts and HR recommendations
└── README.md

Tools

• Microsoft Excel — Pivot tables, statistical functions, charts, outlier analysis

Academic Context

Undergraduate data analytics project, PDEU — AY 2024–2025.

Author: Sakhi Patel · sakhipatel20@gmail.com