On my company, there's a training platform that is unoptimized and assigns all available trainings to everyone and generates a report. As the example below:
User Training Status Staff A Training 01 Assigned Staff A Training 02 Completed Staff B Training 01 In Progress Staff B Training 02 Assigned
The problem is, let's say Staff A works with finances and Staff B works with HR; let's also assume that Training 01 is related to HR, and training 02 is related to finances. In this scenario, Training 02 shouldn't even be assigned to Staff B, but it does and it also generates a pendency in the system. The issue is, we have hundreds of people and dozens of trainings.
To filter this mess, we have an excel tracker, which is manually updated (check the report to see status of applicable trainings, and manually update the tracker just like the Neanderthals did). The worst part is, we have to perform this task connected to a VPN. It takes a whole morning to do it.
My idea is to use this report as a source to update the tracker, but filtering out trainings that are not applicable. Any insights?