Overview

This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient and smart way. It can be used for an in-house HR analysis or as part of a due diligence review. The findings are illustrated by professionally designed magazine-quality charts you can use in your reports and presentations.

 

The analysis covers:

 

● Employee headcount and salary (costs) per head by department. This part of analysis makes use of a jitter-scatter chart, a great visual tool you can use in many other situations.

 

● Employee turnover and retention. Includes the calculation of average service period and other relevant statistics 

 

● Employee headcount changes by years and departments, turnover analysis. Demonstrates total headcount, new joiners and leavers on an elegant vertical waterfall chart. Also has other charts showing the headcount by years and departments, turnover by years and others.

 

● Employee service period by department. Splits the headcount in each department by the length of service period. This is somewhat similar to ageing analysis (of accounts receivable or inventory) where we split every product type by the period the items have been on our books.

 

● Employee churn analysis. A more granular way of looking at employee turnover and retention. The methods and techniques explained in this section are also applicable to customer churn analysis.

 

The publication includes a detailed text guide.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
HR Analytics and Dashboard
504
0
This publication contains a set of tools to perform employee analysis and communicate key statistics in a concise, efficient and…
Startup Cap Table
1,110
81
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cap Table with Investor Returns, Derivative Instruments and Charts
1,138
1
Most startups are initially financed by their founders. They contribute relatively small amounts of money for the company to make…
Cost-Volume-Profit (Breakeven) Analysis
1,285
96
Cost-Volume-Profit analysis is one of the fundamental types of analysis which deals with product profitability. It classifies the costs into…
“Budget-versus-Actual” Charts
1,115
6
This file contains magazine-quality charts in Excel to illustrate variances between budgeted and actual figures.  Professionally designed charts in business…
Due Diligence Tools and Methods
1,697
2
A prospective investor is concerned about the target’s: 1. Quality of earnings 2. Adequacy of working capital 3. Unrecorded or…
See All