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.

img1

Salary Slip

img2

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

img3

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

img4

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

img5

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.

img6

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 *

*

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>