Skip to content

Latest commit

 

History

History
31 lines (22 loc) · 1.36 KB

README.md

File metadata and controls

31 lines (22 loc) · 1.36 KB

Hiring_process_analytics

Overview

This project focuses on analyzing the hiring process within our company to gain insights into various aspects of our recruitment efforts. By utilizing Excel and data visualization techniques, I aim to provide a comprehensive understanding of our hiring practices and identify areas for improvement.

Steps for EDA

  • Understanding data columns and data
  • Checking for missing data
  • Aggregating columns with multiple categories
  • Checking for outliers
  • Removing outliers
  • Drawing Data Summary

Task

  • How many males and females are hired ?
  • What is the average salary offered by this company ?
  • Draw the class intervals for salaries in the company ?
  • Draw Pie Chart / Bar Graph ( or any other graph ) to show the proportion of people working in different departments ?
  • Represent different post tiers using a chart/graph?

Major Insights Observed

  • In the provided dataset, we observed that number of males being hired was more than number of females being hired.
  • Most of the people are working with salary ranging between 25000 to 50000.
  • And Least number of people are working with salary rangning between 0 to 25000.

Contributions

Contributions to this project are welcome! If you have suggestions for improvements, data enhancements, or new analyses, please feel free to open an issue or submit a pull request.