population census web access system
DESCRIPTION
System for Web Access to Results of the Population Census in the Republic of BelarusTRANSCRIPT
![Page 1: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/1.jpg)
System for Web Access to Results of the Population Census in the Republic of
Belarus
Elena Ermolitskaya
Head of the Main Department of Information Technologies
![Page 2: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/2.jpg)
The population census in the Republic of Belarus took place on October 14-24, 2009
![Page 3: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/3.jpg)
The Law of the Republic of Belarus as of July 13, 2006
‘On the population census’ is the legal framework to perform collection and processing of personal data as well as distribution of the census results
![Page 4: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/4.jpg)
Computation of the census zoning
The following registers were presented in E-form:
The register of residential buildings that comprises 4,3 mil. dwelling houses;
The list of 23,5 thous. rural settlements.
![Page 5: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/5.jpg)
The System’s objectives:
Provide complete automation of data input process and increase the quality of the information
Reduce the number of employees involved
Reduce the time needed to edit the data due to the use of the census forms in E-form
![Page 6: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/6.jpg)
Processing of the population census results:
Stage I Personal data input
Stage II Generation of the population census database
Stage IIIForming the repository of the output regulation charts and
the aggregated data warehouse
Stage IV Distribution of the census summary information
![Page 7: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/7.jpg)
Personal data input: Registration of the census portfolios submitted
Scanning of the census forms
Preliminary processing and recognition of marks and symbols
Verification and correction of the marks and symbols recognized
![Page 8: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/8.jpg)
Personal data input: Automated coding and logical control of personal data
Editing of personal data
Coding of respondents’ responses on their occupation and type of economic activity
Loading of personal data to the census database
![Page 9: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/9.jpg)
The population census database is a unique information resource
9,504 thous. people
3,873 thous. households
2,691 thous. families
3,477 thous. dwelling houses
The database contains the complete data about
the following:
![Page 10: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/10.jpg)
Distribution of the census summary information: approaches applied
Statistical digests and bulletins
Output regulation charts
Thematic maps presented as cartograms and diagrammatic maps
![Page 11: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/11.jpg)
![Page 12: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/12.jpg)
![Page 13: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/13.jpg)
Business Intelligence technologies helped to specify the following:
Territorial distribution of the population
Demographic characteristics
Educational attainment of the population
Socio-economic characteristics
Ethnic composition and the languages used
Migration characteristics
Households’ characteristics
Living conditions of the population
![Page 14: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/14.jpg)
Business Intelligence technologies helped:
To reduce the time needed to form the output regulation charts
To receive up-to-date information for filling in bulletins and data books
To generate data for their further integration with the GIS database
To present the information for users’ non-regulation queries without specialized IT
support
![Page 15: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/15.jpg)
Distribution of the census summary information:
approaches applied
Major issue:
lack of access to the summary information to the extent required
![Page 16: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/16.jpg)
General architecture of the system
Free access to the census results via InternetКоммерческие банки
Data extraction, transformation and loading
Level of data sources
Ad
min
iste
rin
g
Tools:
Aggregated database of free access
- Consolidation of the census summary information and data of socio-demographic statistics
- Maintenance of reference data- Setting and execution of calculation algorithms- Dashboard designer- OLAP queries designer
Uniform client access
OLAP queries Information dashboards
The census aggregated database
Data of socio-demographic statistics
![Page 17: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/17.jpg)
Prognoz Platform
• Allows loading data from several sources
• Business Intelligence toolkit
• Provides a license for an unlimited number of users
![Page 18: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/18.jpg)
![Page 19: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/19.jpg)
![Page 20: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/20.jpg)
System of Web access to results of the population census in the Republic of
Belarus, based on the Prognoz Platform:
On-the-spot extraction of data by the selected criteria
Execution of the required groupings and group operations (results,
addition, etc.)
Generation of graphs and charts
Generation of thematic maps in the interactive mode
![Page 21: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/21.jpg)
Queries to be formed via the System:
Population: Territory District type (urban or rural) Sex Age Marital status Country of birth Citizenship Nationality Linguistic characteristics
![Page 22: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/22.jpg)
Queries to be formed via the System:
Population: Education Sources of subsistence Economic activity Occupation Type of economic activity Migration characteristics Number of children born (for women)
![Page 23: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/23.jpg)
Queries to be formed via the System:
Households: Territory District type (urban or rural) Number of members in the household Household type Number of children in the household
(depending on a child’s age) Number of economically active people, the
employed, the unemployed and dependants in the household
Living conditions in the household
![Page 24: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/24.jpg)
Queries to be formed via the System:
Dwellings: Territory District type (urban or rural) Dwelling type House building period The house’s outside walls material Total floor space Conveniences available
![Page 25: Population Census Web Access System](https://reader036.vdocuments.us/reader036/viewer/2022062514/557f9637d8b42a522c8b4cfe/html5/thumbnails/25.jpg)
Development of the BI system based on the Prognoz Platform
Representation of up-to-date data of demographic statistics in the form of tables, charts and cartograms