Description:-

Imagine you're a data analyst at a multinational company. Your task is to analyze the company's hiring process data and draw meaningful insights from it. The hiring process is a crucial function of any company, and understanding trends such as the number of rejections, interviews, job types, and vacancies can provide valuable insights for the hiring department.

As a data analyst, you'll be given a dataset containing records of previous hires. Your job is to analyze this data and answer certain questions that can help the company improve its hiring process.

Here's what you'll be doing:

1. Handling Missing Data: Check if there are any missing values in the dataset. If there are, decide on the best strategy to handle them.
2. Clubbing Columns: If there are columns with multiple categories that can be combined, do so to simplify your analysis.
3. Outlier Detection: Check for outliers in the dataset that may skew your analysis.
4. Removing Outliers: Decide on the best strategy to handle outliers. This could be removing them, replacing them, or leaving them as is, depending on the situation.
5. Data Summary: After cleaning and preparing your data, summarize your findings. This could involve calculating averages, medians, or other statistical measures. It could also involve creating visualizations to better understand the data.

The goal of this project is to use your knowledge of statistics and Excel to draw meaningful conclusions about the company's hiring process. Your insights could potentially help the company improve its hiring process and make better hiring decisions in the future.

Data Analytics Tasks:

A. Hiring Analysis: The hiring process involves bringing new individuals into the organization for various roles.

Your Task: Determine the gender distribution of hires. How many males and females have been hired by the company?

B. Salary Analysis: The average salary is calculated by adding up the salaries of a group of employees and then dividing the total by the number of employees.

Your Task: What is the average salary offered by this company? Use Excel functions to calculate this.

C. Salary Distribution: Class intervals represent ranges of values, in this case, salary ranges. The class interval is the difference between the upper and lower limits of a class.

Your Task: Create class intervals for the salaries in the company. This will help you understand the salary distribution.

D. Departmental Analysis: Visualizing data through charts and plots is a crucial part of data analysis.

Your Task: Use a pie chart, bar graph, or any other suitable visualization to show the proportion of people working in different departments.

E. Position Tier Analysis: Different positions within a company often have different tiers or levels.

Your Task: Use a chart or graph to represent the different position tiers within the company. This will help you understand the distribution of positions across different tiers.

Dataset:-

A. Hiring Analysis:- How many males and females are hired by the company?

Here we have counted the number of event_name according to the conditions given i.e. Hired-Male, Hired-Female. I have simply used the count-ifs function.

Basically, here we got an analysis that the total number of males hired is 2563 and the total number of females hired is 1856.

B. Salary Analysis:- What is the average salary offered in this company?

Here we have counted the number of employees (hired + rejected) and then took out a summation of all the salaries of the employees and divide it by the total number of employees. Using the average function we can do this very easily.

After this calculation, it was found that the average salary offered to the employees in the company is Rs. 49983.03.

C. Salary Distribution:- Create class intervals for salary distribution in the company.

D. Departmental Analysis:- Use a pie chart, bar graph, or any other suitable visualization to show the proportion of people working in different departments.

Here, we have created a pivot table showing the different departments and the count of people in different departments. Then we basically focused on making a chart that visualized the scattered proportion of the people.

Here we can see that the biggest proprtion of the people are there in the Operations Department and Service Departments.

E. Position Tier Analysis:- Different positions within a company often have different tiers or levels.

Here, we have created a pivot table related to all the post names and counted how many are there in that posts, and eventually created a pie chart for the same. And can now clearly see the chart/graph which we can distinguish accordingly.

After the visualization, we can see C5 and N9 posts are occupying the majority section of the pie chart.

Exploratory Data Analysis:-