Finance/ HR_Tenure
Intro: Full analysis of employee tenure using various slicers. It can also calculate revenue per employee for the analyzed period.
In Kompass: There are not many options to calculate employee tenure in Kompass.
File Needed: This file uses an API token, so there is no need to export any data from Kompass.
Uploading method: API Token
The File: To refresh the file, open the [HOW TO] tab, set the Start and End dates of your analysis and click "Refresh Here!". Note that the analysis period cannot be longer than a year.

There are four [Tenure] tabs: for Employees, by Department, by Manager and by Position. Tenure covers only employees employed by your company during the selected period. Employees who left the company before your selected period will not appear.

The [Tenure by Name] tab has a table calculating the Revenue per Employee. For the calculation to be correct, you must define the Period Revenue, which is set in the [HOW TO] tab.

The [New Starters per Year] tab analyzes new starters per year and department.

The [Turnover] tab offers several calculations of turnover.
Further analysis: We can run calculations for the full tenure of employees if asked.