Homepage
Introduction
There are two search modes – basic and advanced. Mapping tool is also present as additional visualization support.
In Basic search mode user could search for data in the scope of one indicator, one index and one unit.
In Advanced search mode, user could search the data in the scope of multiple indicators, with related indices and units. Advanced search mode also has additional calculation feature, which could be executed on search results, as well as additional graphical visualization.
As a third option, The mapping tool is presented with NUTS2 regional European map.
1. Application usage
Both search modes are organized in step-by-step manner in the following order: choosing the country, following by the corresponding Region, Indicator, Index and Unit, as well as the year of collected statistics.
1.1. Basic search form usage
As it was mentioned in introduction, Basic search mode usage is organized for search per one indicator, one index and one unit. A user could search the database in the order as follows:
Step 1: Choose the country of interest,
Step 2: Choose the Region that belongs to the chosen country,
Step 3: Choose the Indicator of the interest,
Step 4: Choose the corresponding index and unit that is related to the chosen indicator,
Step 5: Choose the starting year of collected statistics,
Step 6: Choose the ending year of collected statistics.
Selection is organized through the dropping lists. Choosing a parameter in the certain dropping list will dynamically generate other dropping lists of the other steps.
After selection of parameters through these 6 steps, Application automatically executes the search of the database and generates the results in the table located below the submission elements. Generated table could be exported to the MS Excel file by click on the Table Icon or corresponding text link (Figure 3).
Figure 3. Export to MS Excel file link
1.2. Advanced search form usage
Advanced search mode is organized for search per one or more indicators, indices and corresponding units. A user could search the database in the order as follows:
Step 1: Choose the country of interest,
Step 2: Choose the Region that belongs to the chosen country,
Step 3: Choose the Indicator of the interest,
Step 4: Choose the corresponding index and unit that is related to the chosen indicator,
Step 5: Choose the years of collected statistics.
Selection is organized through the lists. Parameters could be chosen by clicking on one or more values (using CTRL or Shift while clicking).
After selection of parameters through these 5 steps, Application automatically executes the search of the database and generates the results in the table located below the submission elements.
Generated table could be exported to the MS Excel file by click on the Table Icon or corresponding text link (Figure 1), above the table. Advanced search mode also has additional calculation feature Denoted as Optional Step 6., which could be executed on search results. This could be activated by click on button located below the resulting table (Figure 5).
Figure 5. Additional calculation button
NOTE: Excel file contains UTF-8 encoded data. This is not Microsoft default format and user could get message like one shown on the picture (Figure 4.), while opening the file. This dialog is quite regular and it should be always responded with option “YES”.
Also a one or more graphs that correspond to the generated table will be shown below the table. Graphics are contain dynamic legend, that highlights corresponding set of bars on click (Figure 6).
Figure 6. Dynamic legend - Highlighting bars
Graph could be saved by the right click ( Figure 7).
1.3. Additional Tabular calculations
Additional Tabular calculations could be executed on values located in columns of the generated table. Calculations could be executed using four basic mathematical operations (addition, subtraction, multiplication and division) by entered value or by values located in other columns.
Step 1. Choose operator
Step 2. Choose “value” or field
Step 3. Enter value, if “value” in step 2 has been chosen. In a column which values should be modified, calculations are executed as follows:
2. If values in a column should be modified by some constant value, in a Field-list option “value” should be chosen. Otherwise user should choose label of column which values are chosen for calculation (e.g. Field 2)
3. If field-list option “value” has been chosen, then appropriate number should be entered into Value-field.
Step 5. Button “Submit chosen calculations” should be activated.
Upon submission, chosen calculations are executed and new values should appear in the table, which is followed by modification of generated graphs below the table. All operations related to the mentioned graphs are the same as it was described earlier in Chapter 2.2.
1.4. Spider Graph visualization Tool
Spider graph is additional visualization tool that graphically represents search results related with at least three regions, as well as minimum three metrics with non-all-zero data statistics captured from at least three statistical years. If these starting requirements are not fulfilled, resulting page would be generated with corresponding error message.
Pressing button Spider Graph Visualization will open another web page that contains basic visualization setup (Figure 10).
Figure 10. Basic spider graph options.
Basic visualization setup defines the way in which represented data should be organized and represented in resulting graphs. Setup contains three options (dropping lists of data types, located on the left side), as well as example spider graph that shows positions of certain data types (located on the right side, as shown in Figure 10).
Setup offers options to assign relations between different data types (Regions, Metrics and Years) and Spider graphical elements (Header (Data type1), Series (Data type 2) and Axis label (Data type 3)). This could be done by choosing desired data types on corresponding dropping lists.
For example, if setup is made in a way that statistical years are assigned to Data type 1 (Header would show statistical years), Metrics is assigned to Data type 2 (Series would show chosen indices and units) and finally, Regions is assigned to Data type 3 (Region names would be shown on corresponding graph axes), then resulting web page would generate spider graphs in a way that each if graphs presents normalized values ratio between regions and different metrics, by corresponding statistical year (Figure 11).
Figure 11. A generated Spider Graph detail
The resulting web page will always show generated Spider graphs below example graph (Figure 12.) Resulting web page need to be scrolled down in order to show generated graphs, which depends on display resolution.
Figure 12. Resulting web page would need to be scrolled down in some cases, in order to show generated Spider graphs.
1.5. Mapping tool
Mapping tool is a visualization tool that graphically represents chosen metrics by NUTS2 regional Europe map. In order to generate this kind of visualization - desired indicator, indices (and units), as well as desired statistical year must be selected within corresponding dropping lists. Then resulting colored EU NUTS2 map will be generated, as shown in the following example (Figure 13).
Figure 13. Example of generated NUTS2 regional Europe map
The metric values, obtained by corresponding search) of each NUTS2 region will be shown below the generated map. A specific NUTS2 region could be marked (with color red) on generated map by click on its name (located in the table – example of Tübingen, Germany, Figure 14).
Figure 14. Locating certain NUTS2 region on map (example of Tübingen, Germany, chosen by click on the name of the region, in statistics table)
To remove region markings from map, the click to option Remove region marker, located on the left side of map, must be made (Figure 14).
Scoreboard Homepage
Introduction
In Search mode, user could search the data in the scope of multiple Scoreboards, with related indices and units. The Search mode also has additional calculation feature, which could be executed on search results, as well as additional graphical visualization.
As another option, The mapping Scoreboard tool is presented with NUTS2 regional European map.
2. Application usage
The presented Search mode is organized in step-by-step manner in the following order: choosing the country, following by the corresponding Region, Indicator, Index and Unit.
2.2. Scoreboard Search form usage
Scoreboard search form is organized for search per one or more indicators, indices and corresponding units. A user could search the database in the order as follows:
Step 1: Choose the country of interest,
Step 2: Choose the Region that belongs to the chosen country,
Step 3: Choose the Indicator of the interest,
Step 4: Choose the corresponding index and unit that is related to the chosen indicator,
Selection is organized through the lists. Parameters could be chosen by clicking on one or more values (using CTRL or Shift while clicking).
After selection of parameters through these 4 steps, Application automatically executes the search of the database and generates the results in the table located below the submission elements.
Generated table could be exported to the MS Excel file by click on the Table Icon or corresponding text link (Figure 2), above the table. Data search mode also has additional calculation feature Denoted as Optional Step 5., which could be executed on search results. This could be activated by click on button located below the resulting table (Figure 15).
Figure 15. Additional calculation button
NOTE: Excel file contains UTF-8 encoded data. This is not Microsoft default format and user could get message like one shown on the picture (Figure 4.), while opening the file. This dialog is quite regular and it should be always responded with option “YES”.
Also a one or more graphs that correspond to the generated table will be shown below the table. Graphics are contain dynamic legend, that highlights corresponding set of bars on click (Figure 16).
Figure 16. Dynamic legend - Highlighting bars
Graph could be saved by the right click ( Figure 17).
2.3. Additional Tabular calculations
Additional Tabular calculations could be executed on values located in columns of the generated table. Calculations could be executed using four basic mathematical operations (addition, subtraction, multiplication and division) by entered value or by values located in other columns (Figure 19).
Step 1. Choose operator
Step 2. Choose “value” or field
Step 3. Enter value, if “value” in step 2 has been chosen. In a column which values should be modified, calculations are executed as follows:
2. If values in a column should be modified by some constant value, in a Field-list option “value” should be chosen. Otherwise user should choose label of column which values are chosen for calculation (e.g. Field 2)
3. If field-list option “value” has been chosen, then appropriate number should be entered into Value-field.
Step 5. Button “Submit chosen calculations” should be activated.
Upon submission, chosen calculations are executed and new values should appear in the table, which is followed by modification of generated graphs below the table. All operations related to the mentioned graphs are the same as it was described earlier in Chapter 2.2.
2.4. Spider Graph visualization Tool
Spider graph is additional visualization tool that graphically represents Scoreboard search results related with at least three regions, as well as minimum three Scoreboards with non-zero data statistics . If these starting requirements are not fulfilled, resulting page would be generated with corresponding error message.
Pressing button Spider Graph Visualization will open another web page that contains basic visualization setup (Figure 20).
Figure 20. Basic spider graph options.
Basic visualization setup defines the way in which represented data should be organized and represented in resulting graphs. Setup contains an option (dropping list of data type, located on the left side), as well as example spider graph that shows its position (located on the right side, as shown in Figure 20). It offers an option to choose the Scoreboard position (in Series legend or Axis label).
After choose of corresponding option, the resulting web page would generate spider graph that presents normalized values ratio between regions and different scoreboards (Figure 21).
Figure 21. A generated Spider Graph detail
2.5. Mapping tool
Mapping tool is a visualization tool that graphically represents chosen Scoreboards by NUTS2 regional Europe map. In order to generate this kind of visualization - desired indicator, indices (and units) must be selected within corresponding dropping lists. Then resulting colored EU NUTS2 map will be generated, as shown in the following example (Figure 23).
Figure 23. Example of generated NUTS2 regional Europe map
The metric values, obtained by corresponding search) of each NUTS2 region will be shown below the generated map. A specific NUTS2 region could be marked (with color red) on generated map by click on its name (located in the table – example of Burgenland, Austria, Figure 24).
Figure 24. Locating certain NUTS2 region on map (example of Burgenland, Austria, chosen by click on the name of the region, in statistics table)
To remove region markings from map, the click to option Remove region marker, located on the left side of map, must be made (Figure 24).