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.
- Understanding data columns and data
- Checking for missing data
- Aggregating columns with multiple categories
- Checking for outliers
- Removing outliers
- Drawing Data Summary
- 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?
- 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 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.