{"id":1688,"date":"2024-02-16T09:33:16","date_gmt":"2024-02-16T09:33:16","guid":{"rendered":"https:\/\/levellab.ee\/?post_type=portfolio&#038;p=1688"},"modified":"2025-08-04T18:28:15","modified_gmt":"2025-08-04T18:28:15","slug":"prevention-program-puhas-tulevik-effectiveness-study","status":"publish","type":"portfolio","link":"https:\/\/levellab.ee\/en\/portfolio\/prevention-program-puhas-tulevik-effectiveness-study\/","title":{"rendered":"The processing tool for admission statistics at the Estonian Academy of Security Sciences"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1688\" class=\"elementor elementor-1688 elementor-1687\" data-elementor-post-type=\"portfolio\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-530aa29 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"530aa29\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2b2d87a9\" data-id=\"2b2d87a9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ff20787 elementor-widget elementor-widget-text-editor\" data-id=\"ff20787\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<\/p>\n<p><strong>Background<\/strong><\/p>\n<p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight );\">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<p><strong style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif;\">Objective<\/strong><\/p>\n<p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight );\">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<p><strong style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif;\">Methodology<\/strong><\/p>\n<p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight );\">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<p><strong style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif;\">Benefits<\/strong><\/p>\n<p><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight );\">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<p><em>Project contracting institution: Estonian Academy of Security Sciences<\/em><br \/><em>Project implementer: LevelLab<br \/>Duration: 10\/2023 \u200d\u2013 12<\/em><i>\/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":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":3929,"menu_order":51,"template":"elementor_canvas","portfolio_category":[65,53],"portfolio_tag":[],"class_list":["post-1688","portfolio","type-portfolio","status-publish","has-post-thumbnail","hentry","portfolio_category-2024-year","portfolio_category-education-and-science"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The processing tool for admission statistics at the Estonian Academy of Security Sciences - LevelLab<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The processing tool for admission statistics at the Estonian Academy of Security Sciences - LevelLab\" \/>\n<meta property=\"og:description\" content=\"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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/\" \/>\n<meta property=\"og:site_name\" content=\"LevelLab\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T18:28:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/levellab.ee\/wp-content\/uploads\/2026\/02\/Pakkumus_10-10-2023_sisekaitseakadeemia_vastuv6tu_statistika_toorist_bg.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"1734\" \/>\n\t<meta property=\"og:image:height\" content=\"2419\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\\\/\",\"url\":\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\\\/\",\"name\":\"The processing tool for admission statistics at the Estonian Academy of Security Sciences - LevelLab\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/levellab.ee\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/levellab.ee\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Pakkumus_10-10-2023_sisekaitseakadeemia_vastuv6tu_statistika_toorist_bg.avif\",\"datePublished\":\"2024-02-16T09:33:16+00:00\",\"dateModified\":\"2025-08-04T18:28:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\\\/#primaryimage\",\"url\":\"https:\\\/\\\/levellab.ee\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Pakkumus_10-10-2023_sisekaitseakadeemia_vastuv6tu_statistika_toorist_bg.avif\",\"contentUrl\":\"https:\\\/\\\/levellab.ee\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Pakkumus_10-10-2023_sisekaitseakadeemia_vastuv6tu_statistika_toorist_bg.avif\",\"width\":1734,\"height\":2419},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Avaleht\",\"item\":\"https:\\\/\\\/levellab.ee\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Portfolios\",\"item\":\"https:\\\/\\\/levellab.ee\\\/portfolio\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"The processing tool for admission statistics at the Estonian Academy of Security Sciences\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/levellab.ee\\\/#website\",\"url\":\"https:\\\/\\\/levellab.ee\\\/\",\"name\":\"LevelLab\",\"description\":\"Anal\u00fc\u00fcsi ja hindamise teenused era- ja avaliku sektori organisatsioonidele.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/levellab.ee\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The processing tool for admission statistics at the Estonian Academy of Security Sciences - LevelLab","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/","og_locale":"en_US","og_type":"article","og_title":"The processing tool for admission statistics at the Estonian Academy of Security Sciences - LevelLab","og_description":"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 [&hellip;]","og_url":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/","og_site_name":"LevelLab","article_modified_time":"2025-08-04T18:28:15+00:00","og_image":[{"width":1734,"height":2419,"url":"https:\/\/levellab.ee\/wp-content\/uploads\/2026\/02\/Pakkumus_10-10-2023_sisekaitseakadeemia_vastuv6tu_statistika_toorist_bg.avif","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/","url":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/","name":"The processing tool for admission statistics at the Estonian Academy of Security Sciences - LevelLab","isPartOf":{"@id":"https:\/\/levellab.ee\/#website"},"primaryImageOfPage":{"@id":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/#primaryimage"},"image":{"@id":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/#primaryimage"},"thumbnailUrl":"https:\/\/levellab.ee\/wp-content\/uploads\/2026\/02\/Pakkumus_10-10-2023_sisekaitseakadeemia_vastuv6tu_statistika_toorist_bg.avif","datePublished":"2024-02-16T09:33:16+00:00","dateModified":"2025-08-04T18:28:15+00:00","breadcrumb":{"@id":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/#primaryimage","url":"https:\/\/levellab.ee\/wp-content\/uploads\/2026\/02\/Pakkumus_10-10-2023_sisekaitseakadeemia_vastuv6tu_statistika_toorist_bg.avif","contentUrl":"https:\/\/levellab.ee\/wp-content\/uploads\/2026\/02\/Pakkumus_10-10-2023_sisekaitseakadeemia_vastuv6tu_statistika_toorist_bg.avif","width":1734,"height":2419},{"@type":"BreadcrumbList","@id":"https:\/\/levellab.ee\/portfolio\/sisekaitseakadeemia-vastuvotu-statistika-tootlemise-tooriist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Avaleht","item":"https:\/\/levellab.ee\/en\/"},{"@type":"ListItem","position":2,"name":"Portfolios","item":"https:\/\/levellab.ee\/portfolio\/"},{"@type":"ListItem","position":3,"name":"The processing tool for admission statistics at the Estonian Academy of Security Sciences"}]},{"@type":"WebSite","@id":"https:\/\/levellab.ee\/#website","url":"https:\/\/levellab.ee\/","name":"LevelLab","description":"Anal\u00fc\u00fcsi ja hindamise teenused era- ja avaliku sektori organisatsioonidele.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/levellab.ee\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio\/1688","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":4,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio\/1688\/revisions"}],"predecessor-version":[{"id":1733,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio\/1688\/revisions\/1733"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/media\/3929"}],"wp:attachment":[{"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/media?parent=1688"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio_category?post=1688"},{"taxonomy":"portfolio_tag","embeddable":true,"href":"https:\/\/levellab.ee\/en\/wp-json\/wp\/v2\/portfolio_tag?post=1688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}