Human Resource Dashboard – Nice use of excel column and bar chart including pivot

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




Created by: Oldmaster

 

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

Chart:- Average Compensation and performanceby Department

img2

The above chart is showing the average compensation and performance score by department, we can easily analyze the compensation and performance ratio through this chart and it is easy to understand about the compensation and performance rating Department Wise.

Chart:- Summary Compensation and performance by Employee

img3

The above chart is showing the summary compensation and performance by Employees to every department wise. We can easily analyze the compensation and performance ratio through this chart in depth about every department.

Chart:-Average Sick Days by Department

img4

The above chart is showing the graphic analyses about the average sick days department wise. We can easily analyze for every department how many sick leaves they are taking and which department is taking less leaves and which department is taking more leaves.

Staff Summary

img5

In the above shown table, we can analyze the data on most parameters. In the table we can see the count of employees, then %age of manpower to every department in the company, average years in company, average salary, average overtime, average bonus, bonus(%age of salary), average of total compensation, bonus(% of salary), average total compensation, average performance score, average sick days.

Through this table we can easily analyze the performance and expenditure of every department.

Chart- Hiring Activity

img6

In the above shown chart is about to how many employees were hired in all the quarters. To show the quarterly hiring used the Bar chart, where we can analyze that in which quarter we hired more employees and in which quarter we hired less employees.

Chart- Top Ten Employees by Bonus

img7

The above shown chart shows thetop ten employees; who get the high Bonus in the overall employees in company.

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>