This Web-App performs automated checks on whether evaluators in the database are eligible for a visit or not.
This tool is designed to also work in practice on a real database (given a secured connection).
An SQL statement automatically checks the requirements of a visit for each potential evaluator (for example sorting out evaluators who have visited a store in the last year).
The database behind this app contains generated, fake data and is similar to a shopmetrics database.
Personally designed and automatised email sending using chatGPT functionalities could be the next extension of the tool.
This plot shows how many visit have been assigned and completed successfully.
The following table gives closer insights in the assignemnts of visits.