Hiring process is the fundamental and the most important function of a company. Here, the MNCs get to know about the major underlying trends about the hiring process. Trends such as- number of rejections, number of interviews, types of jobs, vacancies etc. are important for a company to analysis before hiring freshers or any other individual. Thus, making an opportunity for a Data Analyst job here too!
Provided Dataset of an MNC company.
Data is about people who registered for a particular post in a department of this company.
As a Data Analyst, I required to use my knowledge in statistics and use different formulas in excel and draw necessary conclusions about the company.
Draw insights out of it for hiring department to work upon.
Attributes of data
Application_id
Interview taken on
Status, Gender, Department, Post Name, Offered Salary.
�
3 of 10
Approach
Get the dataset from the given description.
Open dataset in Excel.
Try to understand the problem and given questions.
Approach to familiar with the attributes and validate given data.
Create table format and use count, min, max, avg, sum and other statistical formulas.
Analyzed data by using pivot table and pivot chart.
Solve the given questions step by step and create interactive graphs.
Create excel file in csv format and create report for presentation.
Finally, I attached to my answers to the file.
4 of 10
Tech-Stack Used
Paint Application Software
5 of 10
Insights and Results
How many males and females are Hired ?
�
6 of 10
What is the average salary offered in this company ?��
7 of 10
Draw the class intervals for salary in the company ?��
8 of 10
Draw Pie Chart / Bar Graph ( or any other graph ) to show proportion of people working different department ?��
9 of 10
Represent different post tiers using chart/graph?��