Analysis of Human Resources Data Project Report for HR Department

This project analyzes human resources data using Microsoft Excel to provide insights into various aspects of the workforce. The analysis includes an examination of the distribution of employees across different departments, their respective contributions to the total salary expenditure, and the identification of employees with the highest earnings. The project also explores employee hiring dates, sick leave patterns across departments, and the relationship between performance appraisal scores and sick days. Key findings reveal disparities in salary distribution, departments with high sick leave rates, and the correlation between performance and absenteeism. The project utilizes pivot tables and data analysis techniques to present the findings, offering a comprehensive overview of the HR data and potential areas for improvement within the organization. The data indicates that the sales and R&D departments have the highest share of total workforce and also the highest salary, while departments like accounting and ICT cover a smaller proportion of the workforce. Furthermore, the analysis highlights employees with high and poor performance based on their salaries and sick days.

PROJECT

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
CONCLUSION................................................................................................................................1
REFERENCES................................................................................................................................2

INTRODUCTION
(1)
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.
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.
(2) Department contribution to total
Row Labels
Sum of Total
salary Proportion
Accounting 688767 9%
Administration 984825 13%
1

Customer
Support 1014527 14%
Finance 588008 8%
ICT 570092 8%
Marketing 668013 9%
R&D 1220611 17%
Sales 1639232 22%
Grand Total 7374075 100%
Sales and research and development cover 22% and 17% share in the total population.
Thereafter, administration and customer support have 13% and 14% share in the total salary paid
to the employees. Accounting, finance and ICT have very low share of 8% to 9% in the total
salary. It can be said that there are four departments namely sales, R&D, administration and
customer support that have higher and more the double relative to other department share in the
total salary given to the employees.
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%
2

Grand Total 7374075 100% 100%
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.
(3) 5 employees with highest earnings and department they worked for
Five employees that earn higher are Alexander, Justin, Laura, Avery and Dave. These
employees belong to R&D, administration, ICT and Sales.
Row Labels
Sum of Total
salary
Alexander 282043
R&D 282043
Justin 225398
Administration 225398
Laura 182555
ICT 182555
Avery 145381
R&D 145381
Dave 142648
Sales 142648
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.
3

(4) 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.
(5) Days gone because of sick leave
Total 468 days gone because of sick leave which means that almost one year gone because
of such kind 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
Higher sick number is observed in case of administration, sales and research and
development department. In admistration department there are total 75 sick days followed by
4

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 busines 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 happaned. Such kind of thing ensure that organization will
be run smoothly in proper manner at the workplace.
(6) Employees with poor performance appraisal score and department they worked alongwith
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
5

As per requirement filter of not coping with job is applied on data set and it is
observed that if only those are considered who give very poor performance then in
that case sales and research and development as well as ICT are the departments
where there is higher number of sick days. Apart from this, low sick days are
observed in the case of accounting and administration department.
6

REFERENCES
Books and Journals
7