Human Resource Dashboard - Department wise and salary wise distribution

Created by: DeadlyDay


About Dashboard:

Human resources: - Human Resources play a very key role in an organization. Human resource are have so many responsibilities such as hiring the candidates for a company, and ensuring they wouldperform well and check their previous records.

Human resources makes policies regarding Leaves, Salary Distribution, Manpower, Employee Data Manage, Performance Allowances, and Provident Fund etc.

Human resources dashboards are useful to analyze the performance and improvement area of resources, employee satisfaction. We can finalize the salary standard for every level and designation accordingly.

Let’s understand with a dashboard how we can prepare it and how it will be useful for us to analyze and maintain the company standard.


Salary Slip


In this table we have a salary slip in which few details are mentioned such as Employee name, Department, Hire Date, Salary, Bonus, Overtime, Sick Days, Performance score and total pay. We have to just select the employee name from the drop down list and we will get all the details.

Headcount Department Wise


In the above shown table we can see the headcount department wise. We can see IT department headcount is more comparatively than departments and Customer support headcount is very less in the all departments.

Chart:-Salary Distribution


To show the number of employees by salaries criteria column Chart is used. In this chart we can see that in this salary $55,000-$89,999 criteria’s number of candidates are 45 candidates.

Chart:-Compensation Cost by Department


Column Chart is used to show the Salary break up department wise. In this chart we can see Salary breakup as bifurcated (Salary+Bonus+Overtime). Through this chart we can analyze that Sales department is taking high bonus comparatively than other departments, IT department is taking a high salary among all the department and administration department is taking more overtime compared to other departments.


In this table we can see the total salary amount, total bonus amount, and total overtime amount.

In the second table we can seethe number of employees as per the performance ranking.

In the third table we can see the number of employees who’s taken the sick days.

Download Dashboard

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.