Human Resource Dashboard – Nice vizualization of employee and HR related information

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/human-resources/human-resource-dashboard-by-lcartwright.html
SHARE




Created by: lcartwright

About Dashboard:

This dashboard visualizes various employee and HR related information. It allows HR managers and senior management to quickly view employee statistics including headcount, payroll breakdown, number of employees by salary, salary distribution, average sick days, department’s averages.

HR Dashboard can be designed in different ways and used for different things, but it’s mainly developed & designed keeping in view the important metrics.

There are several ways in which you can visualize HR data to understand the objectives. In October, ExcelForum team launched a dashboard competition in which you were asked to visualize sample data. The challenge has generated a huge thrill around the community and fetched 118 incredible entries.

In this article, we will show you the steps on how to create this dashboard.

Let us see how the Dashboard made by lcartwright looks:

img1

We have divided this dashboard into 9 sections of information. Let us take a look at each one separately.

Section1:

The below picture shows individual details i.e. department, hire date, salary, bonus, overtime, sick days & performance score for the selected name in the drop down list.

img2

All these details are dynamically updated when we change the selection criteria from the drop down list.

Section2:

In this section, department averages for salary, overtime, sick days & performance score for the selected department in section 1 will get updated automatically.

img3

If we change the name of the employee in the drop down list as shown in section 1, then accordingly, the department information will also get updated &hence data shown in above picture will also be changed accordingly.

Section3:

In this section, there is a drop down list, which provides flexibility to select the department & all the related information in the below table gets updated.

img4

The above table shows name, department, hire date, salary, bonus, overtime, sick days & performance score for the selected department.

Section4:

The following chart shows the overtime by the employees of selected department.

img5

Section5:

This section highlights on sick days by the employees of selected department.

img6

Section 6:

This section covers salary in amount & percentage for all the departments.

img7

Section 7:

This section covers bonus in amount & percentage for all the departments.

img8

Section 8:

This section covers overtime in amount & percentage for all the departments.

img9

Section 9:

This section covers number of sick days & its percentage for all the departments.

img10

Using this dashboard we can get a clear view of the Human Resource;and thus we can get the information from various points of view.

Download Dashboard

Please follow and like us:
0


Leave a Reply

Your email address will not be published. Required fields are marked *

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>