Model for Evaluating the Impact of Cultural and Sporting Events

Background

Cultural and sports events have diverse impacts, including economic, social, cultural, and environmental aspects. These events increase Estonia’s attractiveness in the eyes of both domestic and international tourists, promote local culture and sports life, and help enhance Estonia’s reputation worldwide. Various models have been developed to assess the socio-economic impact of events, but they often lack a social dimension. Additionally, the impact of media visibility associated with events on the image of tourist destinations is inadequately evaluated, and the application of these methodologies for events held in larger cities is complex.

Objective

The aim of the study is to develop a methodology (tool) for assessing the socio-economic impact, including the influence on Estonia as a tourist destination, of internationally appealing cultural and sports events held in Estonia. This includes assessing the image of Estonia as a tourist destination, and allowing for future reassessments. In addition, the methodology will be piloted based on 20 events, and proposals for the implementation of the methodology will be developed.

Methodology

LevelLab will pilot the model at 20 events, where three target groups will be surveyed: foreign and domestic tourists, the local community in the areas where the events take place, and businesses. In addition, personal interviews will be conducted with organizations organizing the events and representatives of local governments in the event locations, focus group interviews will be held, and secondary quantitative data will be analyzed.

Benefits

A decision-making tool  for cultural management will be developed to facilitate the planning of individual events. In addition, the tool can be used to enhance Estonia’s positioning and reputation as a tourist destination.

Project ordering institution: Ministry of Economic Affairs and Communications
Project implementers: LevelLab and Roheline Rada
Duration: 08/2023-12/2024

The processing tool for admission statistics at the Estonian Academy of Security Sciences

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