Human Resource Dashboard by [email protected]

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




 

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 and Summary: – Department Wise Salary

img2

img3

In the dashboard we have a summary and linked chart, on the top of the summary table we have a drop down list where we have 2 types of selection report. 1st is Department Wise Salary and 2nd is Department wise Total & Average Sick leaves.

Department Wise Salary:-

Columnchart and Line chart areused to show the Average salary and monthly total salary department wise. In this chart, Column chart is showing the value of department wise average salary and lines are showing the monthly total salary.

Through this chart we can analyze that IT team’s salary amount is very high comparatively than departments.

Department wise Total & Average Sick leaves:-

img4

Column chart and Line chart are used to show the Department Wise Total & Average Sick Leaves department wise. In this chart, Column chart is showing the Average Sick leaves and lines are showing the total sick Leaves.

Through this chart we can analyze that Sales department has taken more leaves comparatively than departments.

Summary:-Department Wise Performance & Expenses

img5

The above shown summary data is presented for Headcount, Performance, Sick leaves, Salary, and Overtime department wise.

Headcount: - In the rows we can see the no. of employees to Score-1 category and score-5 category department wise.

Performance: -In this rows we can see that which department is having high and low headcount from the other departments.

Sick leaves: - In the Sick leaves rows we can see the total sick leaves and average sick leaves for every department.

Salary: -In the Salary rows we can see the maximum, minimum, average and total salary for every department.

Overtime: -In the Overtime row we can see the total amount for Overtime.

Chart :- Company Headcount

img6

Pie chart used to show the head count for every department, in this chart we can see and analyze that IT department is having large number of head count comparatively than other departments and Customer support department is having a smaller number of headcount compared to other departments.

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>