Background

The Estonian Academy of Security Sciences wanted to implement an automated tool for processing admission statistics queries in the SAIS information system, which simplifies the processing of admission statistics, presenting them as compact data tables and visualizations.

Objective

The aim of the proposed solution was to create an Excel workbook, which takes as input structured data tables (for example, .csv extracts from the SAIS admission information system) or PowerQuery data queries from SAIS.

Methodology

The structure and functionality of the solution were designed during the requirements gathering process, which involved document analysis and interviews with representatives from the Estonian Academy of Security Sciences. During the interviews, the structure of the output worksheets, the formatting of tables, charts, and diagrams, as well as other necessary information, were clarified.

Benefits

The tool helps reduce the time spent on compiling and analyzing admission statistics at the Estonian Academy of Security Sciences, thereby ensuring a faster and more efficient process.

Project contracting institution: Estonian Academy of Security Sciences
Project implementer: LevelLab
Duration: 10/2023 ‍– 12/2023