Human Resource Dashboard – Department wise Performance shown

 

Created by: pangam_s@yahoo.com

 

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 would perform 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: – Department Wise Headcount

img2

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

Department wise Average &Total Salary

img3

Column chart and Line charts are used to show the Average salary and total salary department wise. Column chart is showing the total salary value and lines are showing the average salary department wise.

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

Chart: – Department Wise Minimum & Maximum Salary

img4

Columnchart and Line chart areused to show the minimum and maximum salary department wise. In this chart Column chart is showing the minimum salary value for every department and Line is showing the maximum salary value for every department.

Department wise Average &Total Sick leaves:-

img5

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 total sick leaves and line is presenting Average Sick leaves.

Through this chart we can analyze that Sales department had taken more leaves comparatively other departments.

Summary:-Department Wise Performance & Expenses

img6

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 the average performance ratio department wise.

Sick leaves: - In the Sick leaves rows we can see the total sick leaves and average sick leaves fpr 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 :-Top Sick Leave Users and Their Department Average

img7

Column chart and Line charts are used to show the top sick leaves and sick leaves ration in their department.

Columns are representing the sick leaves for employees and lines are representing the sick leaves in their department.

Chart :- Best Performer and Low Performer

img8

Column and Line charts are representing the performer report. In the top chart we can see the Best performer and in the below chart we can see low performer and line are presenting their department performance.

Chart: – Average Line Chart 

img9

Column and Line charts are representing the performance comparison in between departments. In this line is used to show the average number. Through this line we can easily identify that which departments are performing above the average line and which departments are below the line.

Download Dashboard



Example:


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>