Given the fact that benchmarking is one of the most prevailing RIS3 methods applied essentially by many regions, Benchmarking tool is the main tool for performing more sophisticated computational comparisons between regions, into a web-based dashboard. This application helps RIS3 stakeholders to derive basic information regarding the place of their region compared to others, in a quick manner.
The proposed tool provides a web interface where users can import regional data and then select a region of their preference to compare it against other regions. Various statistical metrics are obtained (minimum, maximum, mean, quartiles, Kernel density diagrams etc.). Τhe user can export benchmarking results in the form of tables and figures, or print the final benchmarking report produced by this application. This framework provides the user with the ability to import his own data, by importing an excel file from his local space or use regional data using Regional Assets Mapping tool.
The logical steps of the application, based on its methodological description are:
- Step 1. Data import tables into the framework.
- Step 2. Selection of group of regions to examine.
- Step 3. Statistical analysis on regional data will be performed.
- Step 4. Tables and charts will be generated.
- Step 5. The user can save and export the results.
- Step 6. A final benchmarking report will be produced, for the user to be able to make an extended interpretation of the results.
Following the application architecture described in previous steps, the information flows within the application are given in Figure 1, below. It should be highlighted that the initial input coming from the user, defines the group of regions that will be analysed, as well as the period to which it refers to. The processing of these data, in terms of benchmarking analysis, is based on table or graphic format, which will be illustrated on the application. Individual tables or graphics including the results, can be extracted through the application.
The main output of the application is the final report of Benchmarking exercise, which will give the user a comprehensive picture regarding his/her region compared to a group of other regions, for the chosen time frame.
How to use this application step-by-step?
Step 1 – Selection of source of input data and import data
During the first step of the application, the user will have to choose the main source of data for his analysis. The selection includes: a) import of an .xls file or b) generate a new table.
- import of an .xls file: the user is able to edit or clear the imported data of the table.
The application gives the user the opportunity to select specific regions that he/she wants to include in the benchmarking analysis. Regions that are selected in the In group column are included in the benchmarking exercise. Moreover, the user has to set a region as the reference region, for which the benchmarking will be performed.×
- create a new table: the user will have to first define the table size
(number of rows and columns) and then, complete the data that are going
to be included on the table.
Step 2 – Results of the analysis
In the second step of the application, the user will be able to see the selected indicators for the benchmarking exercise in a table format by pressing the Refresh button (Fig. 2a-d). The results are grouped into three categories:
- Descriptive statistics: this section includes information referring to
the selected group of regions regarding the min, max and average values,
as well as the differences between these values and the reference region.
An additional functionality of the application offers the opportunity to export these data at an excel format or CSV format. This can be done by pressing the Export button at the end of the table (Fig. 6a). The pop-up window gives the user the opportunity to open the file or Save it in his/her computer.
Quartile statistics: this section includes information referring to the
selected group of regions regarding the quartile distribution of the
selected variables. First, the quartile values of the distribution are
given, and in addition to that the corresponding quartile ratios are
also calculated. This information is essential, as it provides useful
insights regarding the inequality that might exist within the selected
group of regions that are investigated in each case. It moves one step
further from the descriptive analysis.
Moreover, the results referring to quartile analysis are also presented in a table format, including all grouped regions (Fig. 6d). As it can be seen, different quartiles are indicated with different colours in this table, which can be exported as an image (.png) by pressing the Export button at the bottom of the graph.×
Step 3 – Density plot and Kernel diagram
The third step of the application offers the opportunity to visualise the distribution of the selected group of regions on a density plot and a Kernel diagram (Fig. 7a). The reference region is highlighted in this case, in order to ease the benchmarking process. As previously, it is possible to export the diagram in an image format (.png) by pressing the Export button at the bottom of the graph.
Selected use cases using the Benchmarking tool of the Online-S3 platform:Will be uploaded soon
Selected RIS3 strategies including Benchmarking method in their implementation process: