The populationcensus in theRepublic ofBelarus tookplace onOctober 14-24,2009
The Law of the Republicof Belarus as of July 13,2006‘On the populationcensus’ is the legalframework to performcollection a...
Computation of the censuszoningThe following registers werepresented in E-form:The register of residential buildings thatc...
The System’s objectives:Provide complete automation of data inputprocess and increase the quality of theinformationReduce ...
Processing of the populationcensus results:Stage I Personal data inputStage II Generation of the populationcensus database...
Personal data input:Registration ofthe censusportfoliossubmittedScanning of thecensus formsPreliminaryprocessing andrecogn...
Personal data input:Automated coding andlogical control ofpersonal dataEditing of personal dataCoding of respondents’respo...
The population census database is aunique information resource9,504 thous.people3,873 thous.households2,691 thous.families...
Distribution of the census summaryinformation: approaches appliedStatisticaldigests andbulletinsOutputregulation chartsThe...
Business Intelligence technologies helped tospecify the following:Territorial distribution of the populationDemographic ch...
Business Intelligence technologies helped:To reduce the time needed to form theoutput regulation chartsTo receive up-to-da...
Distribution of the censussummary information:approaches appliedMajor issue:lack of access to thesummary informationto the...
Generalarchitectureof the systemFree access to the census results via InternetКоммерческие банкиData extraction, transform...
Prognoz Platform• Allows loadingdata fromseveral sources• BusinessIntelligencetoolkit• Provides alicense for anunlimitednu...
System of Web access to results of thepopulation census in the Republic of Belarus,based on the Prognoz Platform:On-the-sp...
Queries to be formed via the System:Population: Territory District type (urban or rural) Sex Age Marital status Coun...
Queries to be formed via the System:Population: Education Sources of subsistence Economic activity Occupation Type of...
Queries to be formed via the System:Households: Territory District type (urban or rural) Number of members in the house...
Queries to be formed via the System:Dwellings: Territory District type (urban or rural) Dwelling type House building p...
Development of the BI system based onthe Prognoz PlatformRepresentation ofup-to-date data ofdemographicstatistics in thefo...
Population Census Web Access System
Population Census Web Access System
Population Census Web Access System
Population Census Web Access System
Population Census Web Access System
of 25

Population Census Web Access System

System for Web Access to Results of the Population Census in the Republic of Belarus
Published on: Mar 4, 2016
Published in: Technology      Economy & Finance      
Source: www.slideshare.net


Transcripts - Population Census Web Access System

  • 1. The populationcensus in theRepublic ofBelarus tookplace onOctober 14-24,2009
  • 2. The Law of the Republicof Belarus as of July 13,2006‘On the populationcensus’ is the legalframework to performcollection andprocessing of personaldata as well asdistribution of thecensus results
  • 3. Computation of the censuszoningThe following registers werepresented in E-form:The register of residential buildings thatcomprises 4,3 mil. dwelling houses;The list of 23,5 thous. rural settlements.
  • 4. The System’s objectives:Provide complete automation of data inputprocess and increase the quality of theinformationReduce the number of employees involvedReduce the time needed to edit the data due tothe use of the census forms in E-form
  • 5. Processing of the populationcensus results:Stage I Personal data inputStage II Generation of the populationcensus databaseStage IIIForming the repository of theoutput regulation charts andthe aggregated datawarehouseStage IV Distribution of the censussummary information
  • 6. Personal data input:Registration ofthe censusportfoliossubmittedScanning of thecensus formsPreliminaryprocessing andrecognition ofmarks and symbolsVerification andcorrection of themarks and symbolsrecognized
  • 7. Personal data input:Automated coding andlogical control ofpersonal dataEditing of personal dataCoding of respondents’responses on theiroccupation and type ofeconomic activityLoading of personal datato the census database
  • 8. The population census database is aunique information resource9,504 thous.people3,873 thous.households2,691 thous.families3,477 thous.dwelling housesThe database contains thecomplete data about thefollowing:
  • 9. Distribution of the census summaryinformation: approaches appliedStatisticaldigests andbulletinsOutputregulation chartsThematic mapspresented ascartograms anddiagrammatic maps
  • 10. Business Intelligence technologies helped tospecify the following:Territorial distribution of the populationDemographic characteristicsEducational attainment of the populationSocio-economic characteristicsEthnic composition and the languages usedMigration characteristicsHouseholds’ characteristicsLiving conditions of the population
  • 11. Business Intelligence technologies helped:To reduce the time needed to form theoutput regulation chartsTo receive up-to-date information for fillingin bulletins and data booksTo generate data for their further integrationwith the GIS databaseTo present the information for users’ non-regulation queries without specialized ITsupport
  • 12. Distribution of the censussummary information:approaches appliedMajor issue:lack of access to thesummary informationto the extentrequired
  • 13. Generalarchitectureof the systemFree access to the census results via InternetКоммерческие банкиData extraction, transformation and loadingLevel of data sourcesAdministeringTools:Aggregated database offree access- Consolidation of the census summary information and data ofsocio-demographic statistics- Maintenance of reference data- Setting and execution of calculation algorithms- Dashboard designer- OLAP queries designerUniform client accessOLAP queries Information dashboardsThe censusaggregateddatabaseData of socio-demographic statistics
  • 14. Prognoz Platform• Allows loadingdata fromseveral sources• BusinessIntelligencetoolkit• Provides alicense for anunlimitednumber ofusers
  • 15. System of Web access to results of thepopulation census in the Republic of Belarus,based on the Prognoz Platform:On-the-spot extraction of data by theselected criteriaExecution of the required groupingsand group operations (results,addition, etc.)Generation of graphs and chartsGeneration of thematic maps in theinteractive mode
  • 16. 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
  • 17. 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)
  • 18. 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, theemployed, the unemployed and dependants inthe household Living conditions in the household
  • 19. 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
  • 20. Development of the BI system based onthe Prognoz PlatformRepresentation ofup-to-date data ofdemographicstatistics in theform oftables, charts andcartograms

Related Documents