Data Analysis Presentation: HR Department Employee Insights

This presentation provides a comprehensive analysis of HR data, focusing on employee distribution across departments, performance metrics, and sick leave trends. The analysis reveals the proportion of employees in each department, highlighting the dominance of the Sales department and the relatively smaller presence of ICT and Finance. The presentation further explores salary distributions, identifying high-earning employees and the departments they belong to, with a notable emphasis on the R&D department. Additionally, it examines recent hires, long-term employees, and patterns of sick leave, pointing out departments with higher absenteeism. Finally, the presentation considers employee performance, linking poor performance appraisals with sick day occurrences across different departments. The findings offer valuable insights into workforce dynamics, providing a foundation for informed decision-making in HR management.

A
PRESENTATION
ON
DATA ANALYSIS

NUMBER OF EMPLOYEES IN EACH DEPARTMENT

DISCUSSION
• From the given pivot table, it is observed that in the Marketing department there are
11employees out of total 96. Marketing department cover 11% share of total workforce
in terms of human resources it has in its department. Highest share is covered by the sales
department which have 19% share in the overall workforce of the company.
Administration and customer support both have 16% share in the total workforce and it
can be said that mentioned department comes on third rank in the table.

CONTINUE
• R&D department cover 14% share in the overall workforce and it can be said that
mentioned department comes at fourth number in the workforce in terms of human
resource they own. Accounting, finance and ICT department cover very low proportion in
the workforce. In Accounting department there are 10 employees out of 96 and have 10%
share in the entire workforce. In finance department there are 8 employees out of 96 and it
can be said that mentioned department have 8% share in the total workforce. ICT have 6%
share in the total workforce and it can be said that it has less proportion in total workforce.

DEPARTMENT CONTRIBUTION TO TOTAL
Row Labels Sum of Total salary Proportion in total salary
Accounting 688767 9%
Administration 984825 13%
Customer Support 1014527 14%
Finance 588008 8%
ICT 570092 8%
Marketing 668013 9%
R&D 1220611 17%
Sales 1639232 22%
Grand Total 7374075 100%
Accounting
Administration
Customer Support
Finance
ICT
Marketing
R&D
Sales
0%
5%
10%
15%
20%
25%
9%
13% 14%
8% 8% 9%
17%
22%
Proportion in total salary

DISCUSSION
• Important point to note is that there is difference in the salary offered to the employees in
varied department. If in above table both proportions will be analysed then in that case it
can be observed that proportion of single department in terms of share in total workforce
and share in total salary to some extent is different. Thus, according to work salary is
given to the employees at the workplace.
Row Labels
Sum of Total
salary
Proportion in total
salary
Proportion in total number of
employees
Accounting 688767 9% 10%
Administration 984825 13% 16%
Customer
Support 1014527 14% 16%
Finance 588008 8% 8%
ICT 570092 8% 6%
Marketing 668013 9% 11%
R&D 1220611 17% 14%
Sales 1639232 22% 19%
Grand Total 7374075 100% 100%

5 EMPLOYEES WITH HIGHEST EARNINGS AND DEPARTMENT
THEY WORKED FOR
Row Labels
Sum of
Total salary
Alexander 282043
R&D 282043
Justin 225398
Administrati
on 225398
Laura 182555
ICT 182555
Avery 145381
R&D 145381
Dave 142648
Sales 142648

DISCUSSION
• Five employees that earn higher are Alexander, Justin, Laura, Avery and Dave. These employees belong to R&D,
administration, ICT and Sales.
• Important point to note is that in research and development department higher number of employees are identified
with higher amount of salary. Avery and Alexander belong to research and development department. This reflect
that business firm is giving very high importance to its research and development department because it plays
crucial role in success of the business firm. Research and development department play crucial role in promoting
innovation at the workplace. It is the research and development department that assist firm in launching new
product time to time. Hence, it can be said that these are some of reasons because of which higher amount is paid
to the employees of mentioned department.

FIVE STAFF RECENTLY HIRED AND SEVEN STAFF THAT ARE OLD
• As per data five staff recently hired are Macia, Gage, Mila, Cassius, Corabus and
Virginia. All these hired in 2017 and 2018. On other hand, some of old staff members are
Laura, Billy, Lilles, Gloaria, Janetter, Marjorie and Mariana. All these were started to be
employed in 2005 and 2006.

DAYS GONE BECAUSE OF SICK LEAVE
Row Labels Sum of Sick Days
Accounting 59
Administration 75
Customer Support 63
Finance 43
ICT 44
Marketing 40
R&D 67
Sales 77
Grand Total 468

DISCUSSION
• Higher sick number is observed in case of administration, sales and research and development department. In
admiration department there are total 75 sick days followed by there are 77 sick days in sales department. Apart from
this there are 67 days total sick days in the research and development department. It can be said that two of core
departments which are sales and R&D observed higher sick days and such kind of things definitely affect business
firm. Low sick days are observed in case of finance and ICT where sick days are 43 and 44. Firm management need
to be very strict to ensure that in upcoming time period such number of leaves will not be observed. In this regard
proper system must be developed under which time to time medical check up of employees must happened. Such
kind of thing ensure that organization will be run smoothly in proper manner at the workplace.

EMPLOYEES WITH POOR PERFORMANCE APPRAISAL SCORE
AND DEPARTMENT THEY WORKED ALONG WITH SICK DAYS
Row Labels Sum of Sick Days
Not copping with job 129
Accounting 5
Administration 3
Customer Support 21
Finance 19
ICT 28
Marketing 0
R&D 27
Sales 26
Grand Total 129