Skip to content

README.md

Latest commit

 

History

History
38 lines (27 loc) · 1.74 KB

README.md

File metadata and controls

38 lines (27 loc) · 1.74 KB

Hiring Process Analytics - Data Analysis using SQL,Advanced Excel Analytics by Raj Rathod

Overview

Welcome to the "Hiring Process Analytics" project! In this project, we delve into the hiring process data of a multinational company to draw meaningful insights that can aid in improving the hiring process and making better hiring decisions.

Project Details

  • Difficulty Level: Statistics

  • Description: As a data analyst at a multinational company, your task is to analyze the hiring process data. You'll handle missing data, club columns, detect and handle outliers, and summarize your findings. By using your knowledge of statistics and Excel, you'll draw meaningful conclusions about the company's hiring process.

  • Original Dataset: Link to Original Dataset

  • Project Report: Link to PDF Report

Data Analytics Tasks

  1. Hiring Analysis:

    • Determine the gender distribution of hires.

  2. Salary Analysis:

    • Calculate the average salary offered by the company.

  3. Salary Distribution:

    • Create class intervals for salary distribution.

  4. Departmental Analysis:

    • Visualize the proportion of people working in different departments.

  5. Position Tier Analysis:

    • Represent the distribution of positions across different tiers.

Project Contributors

Feedback

Your feedback and suggestions are highly valued! Feel free to reach out for discussions or inquiries.