{"id":2440,"date":"2026-02-03T09:22:36","date_gmt":"2026-02-03T09:22:36","guid":{"rendered":"https:\/\/levellab.ee\/?post_type=portfolio&p=2440"},"modified":"2026-02-03T09:22:36","modified_gmt":"2026-02-03T09:22:36","slug":"the-processing-tool-for-admission-statistics-at-the-estonian-academy-of-security-sciences","status":"publish","type":"portfolio","link":"https:\/\/levellab.ee\/en\/portfolio\/the-processing-tool-for-admission-statistics-at-the-estonian-academy-of-security-sciences\/","title":{"rendered":"The processing tool for admission statistics at the Estonian Academy of Security Sciences"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t<\/p>\n

Background<\/strong><\/p>\n

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.<\/span><\/p>\n

Objective<\/strong><\/p>\n

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.<\/span><\/p>\n

Methodology<\/strong><\/p>\n

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.<\/span><\/p>\n

Benefits<\/strong><\/p>\n

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.<\/span><\/p>\n<\/p>\n

Project contracting institution: Estonian Academy of Security Sciences<\/em>
Project implementer: LevelLab
Duration: 10\/2023 \u200d\u2013 12<\/em>\/2023<\/i><\/p><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":3,"featured_media":1398,"menu_order":14,"template":"elementor_canvas","portfolio_category":[],"portfolio_tag":[],"class_list":["post-2440","portfolio","type-portfolio","status-publish","has-post-thumbnail","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio\/2440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":1,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio\/2440\/revisions"}],"predecessor-version":[{"id":2441,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio\/2440\/revisions\/2441"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/media\/1398"}],"wp:attachment":[{"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/media?parent=2440"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio_category?post=2440"},{"taxonomy":"portfolio_tag","embeddable":true,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio_tag?post=2440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}