Human Resource Dashboard by CHatmaker

 

Created by: CHatmaker

 

About Dashboard:

Human resources play a very key role to an organization. Human resource are having so many responsibilities such as hire the candidate for a company, and ensuring they would be a good performer and check them previous records.

Make the policies for company about the Leaves, Salary Distribution, Manpower, Employee Data Manage, Performance Allowances, Provident Fund etc.

For the human resources dashboards are useful to analyze the performance and improvement area of resources, employee satisfaction. We can finalize the salary standard for every levels 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:- Total Headcount on yearly basis
 
img2
 
Chart:-Average Longevity (YY-MM)

3D Pie chart used to show the staff part department wise. Through this chart we can analyze that IT department is having big part of staff in the all departments.
 
img3
 
Column chart used to the durability to the department. Through this chart we can analyze that Accounting department’s duration is long to other departments and marketing department is from very lesser duration in all department.

Chart:-Average Sick Days
 
img4
 
Column Chart used to present the report of average sick days to every department. Through this chart we can see that sales department is having more average sick days in the all departments and human resource is having very less average sick days in the all departments.

Chart:-Average Salary
 
img5
 
Column chart used to show the analyses of Compensation distribution to every department on amount basis. Through this chart we can see that sales department is getting very high compensation in all the department and Finance department is getting very low compensation comparatively to other departments.

Chart:-Average Compensation Vs Performance
 
img6
 
Column and Line chart are used to show comparison between Average compensation v/s performances for the all department.

Summary:-Total Compensation 
 
img7
 
In this table we can know about the compensation ratio in every department. Through this table we can analyze that IT department is getting high compensation in the all department.
 
 



One thought on “Human Resource Dashboard by CHatmaker

  1. Wow – so much missing from this posting. The charts feature:

    [*] Double click drilldown, a “Must Have” feature for Executive Dashboards. Readers can add drilldown to XL’s pivot charts with my add-in available free from my blog here: https://dl.dropboxusercontent.com/u/13737137/Projects/Drilldown/Drilldown.pdf

    [*] Double click Expand/Restore so small Executive Dashboard charts can be more easily read. The above add-in provides this as well.

    [*] Threshold conditional formatting so key performance measures are readily identified as above or below thresholds.

    [*] Near real-time updating from external data sources so this dashboard is just as useful an hour from now or tomorrow or next month as it is today. This is achieved using MS Query which comes with XL and requires no VBA. See it here: http://youtu.be/I1qvqMiGyhc

    [*] The download link is missing. Readers can get it here: https://dl.dropboxusercontent.com/u/13737137/Projects/Drilldown/Drilldown.zip

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>