Human Resource Dashboard by sc0oby

 

Created by: sc0oby

 

About Dashboard:

This dashboard focus on Human Resource of an organizationdepartment’s real time visibility of the data & insights.

With this dashboard, we can view various human resources statistics that automatically updates like headcount, payroll, salary distribution, employee numbers & sickness related information.

There are several ways in which you can visualize HR data to understand the objectives. In October month, Excelforum team has launched a dashboard competing in which you are asked to visualize data using 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 the how Dashboard made by Sc0obylooks:

img1

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

Section1:

This section shows Strength, Performance, Sick Days, Salary, Bonus, Over time.

img2

Section2:

This sections shows department related information which can be changed by using drop down list & all the below information like total salary, average salary, bonus, sick days & average performance will get updated dynamically.

img3

Section3:

The following is a departmental comparison chart on average salary.

img4

Section4:

The following is a departmental comparison chart on average bonus.

img5

Section5:

The following is a departmental comparison chart on average overtime.

img6

Section 6:

The following is a departmental comparison chart on Strength.

img7

Section 7:

The following is a departmental comparison chart on average sick days.

img8

Section 8:

The following is a departmental comparison chart on average performance.

img9

After the detail comparison for each department, we can find out the department which is performing overall good & which department is not performing well.

Using this dashboard you can get a clear view of the Human Resource and we can get the information from various point of view.

 

image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 



18 thoughts on “Human Resource Dashboard by sc0oby

  1. Used this for our new dashboards im producing, a good clean look and just what I was looking for. Easy to replicate and excellent clear data on show

  2. Hi, Great dashboard, which I have managed to replicate, and would appreciate link to file/template to compare functions etc. Thanks JH

  3. This dashboard is Excellent! It is simplistic and has a pleasant color scheme, with just enough information to compare and evaluate the functional teams. I have a few questions thought.
    1. How is the overall data collecting?
    2. Is the data one spreadsheet/template, or do you need several sheet to collect and house all the input data?

    Great Job!

Leave a Reply

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

*

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>