Hiring Data Analysis using Excel

Goal : To analyse the hiring pattern of the ABC company to understand following things :

1. Gender distribution
2. Salary distribution
3. No. of posts opening analysis
4. Department-wise analysis

Analysis Steps :

1. Data Cleaning - Removing missing values, checking for data accurancy, removing outliers, checking for data distribution

2. Analysis: Calculated salary distribution between salary intervals. average salary per post. over-all gender distribution. post-wise and department-wise gender distribution and their salary.

3. Functions Used: COUNTIF,AVERAGEIFS,Data Consildation, Pivot tables,Different types of charts.

4. Visualization: Created graphs and plots for the above findings.

5. Insights below

   

   

   

   

   

   

   Please have a look at the attached excel file for detailed analysis.