1
System of Access to
Census Summary Data 2009, Republic of Belarus
via the Internet
User Manual
Minsk 2011
TABLE OF CONTENTS
1.Introduction
2.Purpose and Application Conditions
3.Subject Blocks of the System of Acces
4. Tab «Dashboards»
4.1. Beginning of Work
4.2. Dashboard Structure
4.3. Data Detalization and Filtering
4.4. Rating Charts and Data Sorting
4.5. Statistical Maps Construction. Map Legend Settings.
5. Tab «Reports»
5.1.Beginning of Work
5.2. Custom Setting Dashboard
5.2.1. Custom Setting Dashboard Structure
5.2.2. Data Detalization
5.2.3. Filters Setting
5.3. Report Toolbar
5.3.1. Custom Report Saving
5.3.2. Report Visualization in Chart Form.
- Introduction
This User Manual contains the description of purpose, terms and conditions of application and functionalities of the System of Access to Census Summary Data 2009, Republic of Belarus via the Internet (hereinafter - the System of Access). The document describes the user interface of the System of Access, as well as gives the instructions on working with it.
- Purpose, Terms and Conditions of Application
The System of Access aims to provide the wide range of Internet users with the access to the census summary data 2009, Republic of Belarus, and to the data of demographic statistics. The user interaction with the System of Access is carried out through the web-browser.
To assure the normal functioning of the system, the working station of user should meet the following minimum requirements:
Processor with the clock frequency of 450 MHz and higher
RAM memory space: 128 Mb and more
Hard disk space: 4 Gb and more
Ethernet 10/100TXNetwork Adapter
Monitor TFT 15”
Keyboard
Mouse
The working station of the user of the System of Access should be equipped with the following applications:
Operating System (OS) Microsoft Windows 2003/XP/7
Web-browser (MS Internet Explorer (8.0 and higher), Google Chrome (9.0 and higher), Mozilla Firefox (3.6 and higher), Opera (11.0 and higher))
Microsoft Office 2003 and higher
Adobe Flash Player (10.0 and higher)
The working station should be equipped with theaccess to the Internet. The recommended connection speed is 33,6 Kbits/sec and higher.
The users of the System of Access should have basic Windows applications skills (working with windows, system and contextual menu, pictograms, scrolling, drag&drop and other standard procedures), as well as Internet application knowledge.
Before starting work with the System of Access, the user should get acquainted with this User Manual.
- SubjectBlocks of the System of Access
Through the System of Access the Internet user can access the statistical information on the following subject blocks:
Census results of the Republic of Belarus in 2009:
1. Number and territorial distribution of population
2. Demographic characteristics
3. Educational attainment of population
4. Socio-economic characteristics of population
5. Ethnic composition of the population, citizenship
6. Migratory characteristics of population
7. Characteristics of private households
8. Housing conditionsof population
9. Population temporarily resident in the Republic of Belarus
Demographic statistics data:
1. Population size at the beginning of the year, people
2. Average annual population, people
3. Fertility,people
4. Mortality, people
5. International migration balance, people
6. Number of marriages
7. Number of divorces
8. Natural increase (+), loss (-),people
The user obtains the necessary information in the form of indicators in the selected slices.
The access to information is carried out by two methods: through the dashboards, and through the reports.
4. Tab “Dashboards”
4.1. Beginning of work
After opening the tab “Dashboards”, the user gets the access to the work window shown in Figure 1, which consists of two parts: the dashboard tree and dashboard visualization area. The dashboard tree contains subject blocks for which the user can deploy the dashboard. To do this, the user should select the necessary item in the tree. Figure 2 shows thework window with expanded dashboards by two selected items: “Population size” in the demographic block and “Educational attainment”.
Figure 1. Work Window of the Tab “Dashboards”
Figure 2. WorkWindow with Open Dashboards
4.2. Dashboard Structure
General dashboard view is given in Figure 3.
Figure 3. General dashboard view
Structurally the dashboard consists of the following elements.
Slice, Unit. These elements enable the user to select from the list of units (in this case – Population size) and slice in which the user needs to display information (in this case - Territory).
Data visualization area. It is the area where the data is displayed by indicator in the selected slice.
Toolbar.It enables the user to change the type of data visualization (table, graph, map), as well as to print and export the query results. It contains the following elements:
- - Tabular data presentation
- Mapping
-Data presentation in a doughnut chart
- Data presentation in a pie chart
-Data presentation in abar chart indicating leaders and outsiders for the selected slice
- Data presentation in abar chart
- - Dashboard procedures. The user can print, export data, and edit map legend
4.3. Data Drill-Down and Filtration
If the data is structured hierarchically, i.e. it contains nestings, then it is possible to drill it down in an appropriate way. To detail the category (drilling down to the lower level) click on it. Figure 4 shows an example ofthe territoryrefinement of higher level (Brest region) drilled down to the territory of lower level (districts ofBrest region). Figure 5 shows an exampleofdrilling down from the category "Have education” to "Educational Attainment".
Figure 4. Territory of Brest region drilled down to the level of districts
Figure 5. Those who have education drilled down to the level of educational attainment
If the user needs to obtain data in the specific combinations (for example, Male / Brest region / 20-24 /Rural / have education), then the user should click on corresponding categories to select them. In this case the filter value will be set in the specific place of the dashboard. Figure 6 shows the sequence of setting the filter mentioned above (Male / Brest region / 20-24 /Rural / have education).
Figure 6. Sequence of filter setting(Male / Brest region / 20-24 /Rural / have education)
The tool of drilling-down and filtering of data, represented incharts and maps, is applied the same way. Figure 7 presents the drilling downof the territory of Brest region represented on the map up to the level of districts. Figure 8 gives an example of filtration of data, represented in charts.
Figure 7. Territory of Brest region displayed on the mapdrilled down to the level of districts
Figure 8. Filtration of data represented incharts
4.4. Rating Diagrams and Data Sorting
Initially when the user opens the dashboard, the data is sorted by categories (items of slices). Figure 9 shows the dashboards with datasorted by slices“Age” and “Territory”.
Figure 9. Dashboards with data sorted by categories
The rating diagram is used to sort the data by indicator value, its example is shown in Figure 10. When switching to the tabular mode, sorting by indicator value is preserved. Figure 11 shows “leaders and outsiders” sorted by value both in chartand table form.
If data must be sorted by categories (items of slice), rating diagram mode and diagram “leaders and outsiders” mode should be disabled (for example, when pie chart is active).
Figure 10. Dashboards with data sorted by indicator values (rating)
Figure 11. “Leaders and outsiders” in chart and table form
4.5. Construction of statistical maps. Map legend customization.
To construct the statistical map, select the slice “Territory” and the mode "map" on the toolbar (button ). The dashboard with the map of distribution of population by regions and Minsk city and a similar map for the Vitebsk region in the slice of districts are shown in Figure 12.
Figure 12. Dashboard with statistical maps
The towns of regional subordination stand out separately on the maps in the form of scalable symbols.
In the lower part of the map there is a legend which reflects the groups of territorial entities represented on the map by indicator value.
If desired, color range and group size can be changed. To do this, select the element () on the toolbar and select “Legend settings” from the drop-down list. This opens a dialog box shown in Figure 13.
Figure 13. Map legend settings window
When setting the map legend it is possible to select a quantity of intervals, their upper and lower bounds, as well as the color range.
5. Tab “Reports”
5.1. Beginning of work
Switching to the tab “Reports” opens the work window shown in Figure 14, which is divided into two parts. The tree of reports is displayed in the left part of the window;the right part of the window is aimed at data visualization and custom settings.
Figure 14. Work window of the tab “Reports”
To obtain the data, select a relevant subject in the tree of reports (for example, “demographic characteristics”, and then “population size”). In the right side of the window the following items will be reflected (as shown in Figure 15):
Data report
Custom setting dashboard
Report Toolbar
Figure 15. Work window with the open report
5.2. Custom Setting Dashboard
Custom setting dashboard is aimed at selection of indicator, slices of its representation, their arrangement (by rows or columns), and data filtration.
5.2.1. Custom Setting Dashboard Structure
Custom setting dashboard consists of three elements:
By Columns. This part of the dashboard contains the slices whose values will be reflected in the columns of report. Initially in the same part there is a list from which it is possible to select an indicator.
By Rows. This part of the dashboard contains the slices whose values will be displayed in the report by rows.
Fixed. It is the storage of all other slices. In this part of the dashboard the data filtration is carried out.
Thus, for instance, as shown in Figure 15, the selected indicator is “Population”; the slice “Area of residence” will be shown by columns, and the slice “Territory” will be displayed by rows.
Slices can be dragged with the mouse button between the different elements of custom setting dashboard. To do this, the user shouldtake the slice with the mouse button and drag it to the necessary place of the dashboard. Figure 16 shows the sequence of user procedures for the arrangement of slices in the report.
Figure 16. Sequence of user procedures for the arrangement of slices in the report
As seen from the Figure, initially the slice “Territory” (a) is in the rows, and the slice “Area of residence” is in the columns. Afterwards they were reversed (b), and then another slice “Sex” was dragged into the columns (c).
5.2.2. Data Drill-Down
Initially the data in the report is presented in the upper levels of aggregation. In order to obtain the information of the necessary degree of drill-down (drill down to the lower level), the user should click on the slice value to be detailed in the report (for example, when clicking on the slice value “Both sexes”, items “men” and “women” will be reflected separately in the report), as it is shown in Figure 17. In the example shown in Figure, the Republic of Belarus is drilled down to the level of regions.
Figure 17. Example of data drill-down
The user can detail data through the custom setting dashboard. Moreover there is a possibility to select from the listthose items of the slice which are to be reflected. To obtain detailed data on the selected items, click on the button located on the report toolbar. Figure 18 shows an example of drill-down by the slice “Territory” (selected items are highlighted in gray color).
There is an option of group highlighting (dehighlighting) of the slice items. To do this, right-click on the definite place of the list, and carry out one of the proposed procedures, as it is shown in Figure 19.
Figure 19. Data drill-down through the custom setting dashboard
Figure 19. Group highlighting (dehighlighting) of the slice items
5.2.3. Filter Setting
Filter setting is carried out by selecting the corresponding item of the slice, situated in the element “Fixed”. In this case only one item can be selected from the list. Figure 20 shows an example of filter setting for the slice “Sex” (category "men" isselected) and "Age" (age category "1 year"is selected).
Figure 20. Example of filter setting
5.3. Report Toolbar
Report toolbar contains the following elements:
“Save as”. It saves the custom report.
“Update”. It updates the report. It is necessary when selecting the slice values.
“Undo”.It cancels the previous user's action.
“Redo”.It repeats the cancelled action of user.
“Print Preview”. It enables the user to preview the report, and, if necessary, to print it out.
Buttons for report export into the formats .rtf, .xls, .pdf respectively.
Buttons for visualization report mode selection: table, table-diagram, diagram respectively.
“Pivot Table”. It enables the user to reverse columns and rows in the report.
Buttonsof data filter settings, cell highlighting and their conditional formatting respectively.
“Calculating totals”. It enables the user to calculate totals in the report.
“Analysis 80/20”. It enables the user to cutomize the analysis parameters 80/20.
“Table Style”. It enables the user to select the table style.
Buttons of data format setting in the report.
5.3.1. Custom Report Saving
To save the custom settings and the report obtained, click on the button. This opens the work window “Save report as…” in which the user should type in the name of the report and click on “Save”. The report will be saved under the corresponding name in the tree of reports in “User's Folder”, as it is shown in Figure.
Figure 21. Custom ReportSaving
If necessary, this report can be selected and opened by the user.
5.3.2. Report Visualization in Chart Form.
There are two methods of data representation using charts and graphs: mode “Chart” and mode “Table-Chart”.
To display the chart report, select the data of the report which should be reflected in graphic form and click on the toolbar button . The data will be reflected in the chart form, as it is shown in Figure 22.
Figure 22. Visualization of report data in chart form
Using the chart toolbar, the user can change the chart type and its view.
Figure 23 presents an example of linear chart construction. It is necessary to note that for the correct display of X-axis legends on this graph, only one slice and its values should be selected by the columns for which the data should be reflected.
Figure 23. Data visualization in linear chart form
In the visualization mode “Table-Chart” (button) the user can simultaneously see data both in table and chart form. It enables the user to change the data displayed in chart form on-the-fly as it is shown in Figure 24.
Figure 24. Example of data visualization in “Table-Chart” form