HR_Qualifications
Intro: Get a full analysis of your employees’ qualifications and their expiration dates.
In Kompass: Kompass offers filters to identify qualifications that are soon to expire or have expired. It can also filter them by Department. The Expiring filter covers qualifications that expire in less than 60 days. However, when a user has several qualifications, it can get cumbersome to change filters. This spreadsheet will bring all data together.
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: The file returns only active users and their qualifications. Users who left your organization more than 365 days ago will not appear. You can hide qualifications that expire far in the future, hide qualifications that expired a long time ago, and hide employees who have left your organization. All these options are in the [HOW TO] tab.

Once you define those options, click "Refresh Here!".
You can review the four available tabs, which slice the data by Department, Qualification, Manager and Position.

Further analysis: The file already slices the data in numerous ways. You may decide to delete some of those tabs.