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:
We have divided this dashboard into 4 sections of information. Let us take a look at each one separately.
This section shows Strength, Performance, Sick Days, Salary, Bonus, Over time.
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.
The following is a departmental comparison chart on average salary.
The following is a departmental comparison chart on average bonus.
The following is a departmental comparison chart on average overtime.
The following is a departmental comparison chart on Strength.
The following is a departmental comparison chart on average sick days.
The following is a departmental comparison chart on average performance.
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.
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 [email protected]