Inoctus AI 25/08/2023
HIRING
PROCESS
ANALYSIS
By Mahendra Singh Tekam
Data analyst
Analysis presentation 7574
Agenda
Hiring Analysis:
The hiring process involves
bringing new individuals into the
organization for various roles..
2022
Salary Analysis:
The average salary is calculated by
adding up the salaries of a group of
2023 employees and then dividing the total
by the number of employees Data
.Salary Distribution:
Analytics
Class intervals represent ranges of
values, in this case, salary ranges.
The class interval is the difference
Tasks
2024 between the upper and lower limits
Introduction to the importance of
data analysis for improving the
of a class.
hiring process.
Agenda
Departmental Analysis:
Visualizing data through charts
and plots is a crucial part of data
analysis.
2022
Position Tier Analysis:
Data
2025
Different positions within a
company often have different
tiers or levels.
Analytics
Tasks
Introduction to the importance of
data analysis for improving the
hiring process.
Approach The hiring process involves
bringing new individuals into
Hiring
the organization for various
roles
Analysis
Inoctus AI
TASK Determine the gender
distribution of hires. How
many males and females
have been hired by the
company?
Agenda
Our Dataset Agenda
"Gender Distribution of Hires“
Hiring Analysis:
Gender Distribution In this section, we'll explore the gender distribution of
hires at Inoctus AI.
Insights
Gender Distribution Most hires are male, with 57% of total hires.
Female hires account for 37% of the total hires.
Total Hires: 4698 Other/unspecified hires contribute to 6% of the total
Male Hires: hires.
2564
Female Hires: 1857 Gender Distributi on
Don’t want to say
Other: 5%
279
Female
37%
Male
57%
Male Female Don’t want to say
The company's hiring process has seen a slightly
Hiring Analysis: higher number of male hires compared to female
Gender Distribution hires.
Consider exploring strategies to promote diversity and
inclusivity in the hiring process.
Gender Distribution
Total Hires: 4698
Male Hires:
2564
Female Hires: 1857
Other:
279
Approach The average salary is
calculated by adding up the
salaries of a group of
employees and then
Salary
Analysis
dividing the total by the
number of employees.
is.
Inoctus AI
TASK What is the average salary
offered by this company?
Use Excel functions to
calculate th
Agenda
In this section, we'll delve into the average salary
Salary Analysis offered at Inoctus AI and explore the highest and
lowest salary offerings.
Salary Distribution
Average Salary Analysis
Highest Salary: $400,000
Average Salary: $49,984 • Department: Operations
• Employee: Female
Method Used:
Calculated using the
Excel AVERAGE formula
on the salary dataset. •Lowest Salary: $100
• Department: Service
• Employee: Male
Salary Analysis
Insights
• The company's average salary is significantly influenced by
the distribution of salaries.
• The highest salary offered is $400,000 in the Operations
Average Salary Analysis
department to a female employee.
• The lowest salary offered is $100 in the Service department
Average Salary: $49,984
to a male employee.
Method Used:
Calculated using the Method for Average Calculation
Excel AVERAGE formula
on the salary dataset. • Use the AVERAGE formula in Excel:
=AVERAGE(salary_range)
• Excel will calculate the average salary based on the
provided salary range.
Conclusion:
• The company's average salary reflects the range and
distribution of salaries across different departments.
• Identifying the factors contributing to the highest and lowest
salaries can aid in salary structuring and decision-making
Approach Class intervals represent
ranges of values, in this
case, salary ranges. The
class interval is the
Salary
Distribution
difference between the
upper and lower limits of a
class.
Inoctus AI
TASK Create class intervals for the
salaries in the company.
This will help you
understand the salary
distribution
Agenda
In this section, we'll explore the distribution of salaries at
Salary Inoctus AI using class intervals and highlight the class with the
Distribution: Class highest number of employees.
Intervals Concept of Class Intervals:
• Class Intervals are ranges used to group data for analysis.
• They help in visualizing the distribution of data across
different ranges.
Identified Class Interval:
• Class Interval: $40,000 - $45,000
• Highest Number of Employees 414
Insights:
• The histogram illustrates the spread of salaries across
various class intervals.
• The class interval with the highest number of employees is
$40,000 - $45,000
Conclusion:
• Understanding the distribution of salaries using class
intervals can provide insights into salary ranges that are
more common among employees.
Histogram
Salary
Distribution: Class
Intervals
414
382 388 386
372 379
360 363 367 362 358 356 355
348 348
340 334
331 325
296
Frequency
Histogram
3
5000 10000 15000 20000 25000 30000 35000 40000 45000 50000 55000 60000 65000 70000 75000 80000 85000 90000 95000 10000 More
0
Frequency 296 382 360 372 348 363 331 379 414 Bin_range
367 388 362 340 358 348 386 356 355 325 334 3
Approach Visualizing data through
charts and plots is a crucial
part of data analysis.
Department
al Analysis
Inoctus AI
TASK Use a pie chart, bar graph,
or any other suitable
visualization to show the
proportion of people working
in different departments.
Agenda
Departmental Analysis
Departmental In this section, we'll examine the distribution of
Analysis employees across different departments at Inoctus AI.
A pie chart will show this distribution
Total
Finance Department General Management
4% 2% Human Resource Department
1%
Service Department Marketing Department
29% 5% Finance Department
General Management
Human Resource Department
Marketing Department
Operations Department
Production Department
Purchase Department
Sales Department
Sales Department Service Department
10% (blank)
Operations Department
Purchase Department 39%
5%
Production Department
5%
Departmental Insights:
Analysis
• The pie chart provides a visual representation of the
distribution of employees across various
departments.
• The Operations Department has the highest
Highest Employee number of employees, comprising 2771 of the total.
Count: Operations
Department - 2771 • The Human Resources Department has the lowest
employees
number of employees, constituting 97 of the total.
Lowest Employee Significant Departmental Imbalances:
Count: Human
Resource Department • The significant difference between the highest and
- 97 employees
lowest employee counts indicates a potential
imbalance in workforce distribution.
Departmental Conclusion:
Analysis
• Understanding the departmental distribution helps
in identifying areas that might require attention in
terms of employee allocation and resource
planning.
Highest Employee • Addressing any departmental imbalances can
Count: Operations contribute to a more well-rounded and efficient
Department - 2771
organization.
employees
Lowest Employee
Count: Human
Resource Department
- 97 employees
Approach Different positions within a
company often have
different tiers or levels.
Position
Tier
TASK Use a chart or graph to
Analysis
Inoctus AI
represent the different
position tiers within the
company. This will help you
understand the distribution
of positions across different
tiers..
Agenda
Position Tier Position Hierarchy Insights
Analysis • The distribution of employees across position
tiers reveals the hierarchical structure of the
• Tier b9: 463 employees company.
• Tier i6: 527 employees • Different tiers represent varying levels of
• Tier c5: 1747 employees responsibility, specialization, or leadership.
• Tier c9: 1792 employees
• Tier i5: 787 employees
• Tier i7: 982 employees Discussion:
• Tier c8: 320 employees
• Tier c-10: 232 employees • The highest representation is in Tier c9,
• Tier i1: 222 employees indicating a significant number of employees
• Tier n6: 1 employee in that role.
• Tier n9: 1 employee • Tiers n6, n9, m7, and n10 have very low
• Tier i4: 88 employees
representation, suggesting they may be
• Tier m6: 3 employees
• Tier m7: 1 employee unique or specialized positions.
• Tier n10: 1 employe
In this section, we'll explore the distribution of position
Position Tier tiers within the Inoctus AI bar chart and will provide a
Analysis visual representation of this distribution.
Conclusion:
Position Tier
Analysis • Analyzing the distribution of position tiers is crucial
for understanding the hierarchical framework of the
company Invoctus AI .
• This data informs decisions regarding workforce
Important Facts
management, career progression, and
organizational structure.
Total company
revenue spend in
• Addressing any potential disparities in position tiers
salary distribution
can lead to more balanced career progression and
is
organizational efficiency.
$358228369 dollars
Highest salary
offers in Operations
department .
Invoctus AI
Connect with us.
Mahendra Singh Tekam
Data analyst
As we continue to navigate the dynamic landscape of AI and
data-driven solutions, your expertise will undoubtedly be a
guiding light. Your dedication to excellence is an inspiration to
us all, and we're grateful to have you as an integral part of our
Invoctus AI family.
EMAIL infomahit@[Link]
SOCIAL MEDIA @oyemaahi
CALL US 123-456-7890
Thank you
Presentation • In this presentation, I imagine that i am a data analyst
at a multinational company Invoctos AI my task is to
Overview analyze the company's hiring process data.
• This presentation is for the Trainity project.
• All datasets provided by the Trainity.
