Presentazione di PowerPoint - coms.events

Presentazione di PowerPoint - coms.events

Metadata driven monitoring of electronic data capture: the Ethiopian experience New Techniques and Technologies for Statistics 2019 Brussels 11 - 15 March 2019 M. Bruno, G. Drovandi, P. Giacomi, M. Grassia - Istat A. Whitesell, J. Handley - Census Bureau Outline The Italian support to the 4th Ethiopian Population and Housing Census Metadata driven monitoring of electronic data capture: CSPro 7 data collection process (strengths & weaknesses) Dashboard to monitor field operations Data collection architecture

Cspro2sql Dashboard Metadata driven monitoring of electronic data capture NTTS 2019 2 The Italian support to the 4th Ethiopian Population and Housing Census - 1 Ethiopia - Summary statistics Region Eastern Africa Capital city Addis Ababa Surface area (sq km)

2015 1.104.300 Population (projected estimate) 2017 104.957.000 GDP: Gross domestic product (million current US$) 2017 59.917 GDP growth rate

(annual %) 2017 9,6 Metadata driven monitoring of electronic data capture NTTS 2019 3 The Italian support to the 4th Ethiopian Population and Housing Census - 2 Capacity building in statistics Population Census Project Financing Body Italian Agency for development Cooperation Partner

Institution Starting date Overall objective Main expected results/ (activities) Implementation Agency Italian National Institute of Statistics Central Statistical Agency (CSA) June 2016 Duration 24 months

To contribute to the improvement of the statistical information available in Ethiopia through the implementation of the 4th Population and Housing Census that will make available updated information on the structure and composition of the Ethiopian population To reinforce the statistical capacity of CSA through the increase of the average professional level and qualifications of the staff involved in the PHC preparation. Technical assistance and training for improving the Census Methodology, setting up a System for data collection monitoring, Data center configuration Metadata driven monitoring of electronic data capture NTTS 2019 4 The Italian support to the 4th Ethiopian Population and Housing Census - 3 Capacity building in statistics Population Census Project Coordination with other Partners / Agencies

UNFPA DIFID / ONS USAID / US Census Bureau Resources Istat provided technical assistance, training on the job and statistical training addressed to CSA staff for a total of 33 working weeks Main deliverables Web based monitoring system (CSPro Dashboard) fully integrated (via CSPro2sql software) with the primary data collection system CSPro2sql & Dashboard User Guide; Prototype of a web-based application for record linkage; Guidelines for the design and implementation of the Post-Enumeration Survey in Ethiopia (including instructions for the use of the Web-based application for record linkage).

Metadata driven monitoring of electronic data capture NTTS 2019 5 Data collection process: CSPro 7 & Dashboard Metadata driven monitoring of electronic data capture NTTS 2019 6 Census data collection process - CSPro 7 CSEntry Supervisor CSEntry CSEntry CSPro 7 (Census Bureau)

CSWEB Metadata driven monitoring of electronic data capture NTTS 2019 7 Census data collection process - CSPro 7 CSEntry Supervisor CSEntry CSEntry CSPro 7 (Census Bureau) CSWEB Strenghts: metadata driven

used in several countries no coding needed no licence fees Metadata driven monitoring of electronic data capture NTTS 2019 8 Census data collection process - CSPro 7 CSEntry Supervisor CSEntry CSEntry CSPro 7 (Census Bureau) Weakness: microdata is stored in plain text files difficult to monitor fieldwork activities

CSWEB Metadata driven monitoring of electronic data capture NTTS 2019 9 Census data collection process - CSPro 7 CSPro 7 (Census Bureau) Weakness: microdata is stored in plain text files difficult to monitor fieldwork activities CSWEB Metadata driven monitoring of electronic data capture NTTS 2019 10 Census data collection process We want to address the following questions:

How to make field operations smoother? How to increase quality of survey data? We need to move microdata to a relational database and a dashboard to monitor fieldwork activities MICRO DATA Metadata driven monitoring of electronic data capture NTTS 2019 MONITOR 12 Census data collection process - Dashboard CSEntry Supervisor CSEntry CSEntry

CSPro 7 (Census Bureau) CSWEB Metadata driven monitoring of electronic data capture NTTS 2019 13 Census data collection process - Dashboard CSEntry Supervisor CSEntry CSEntry Dashboard (Istat) CSWEB MICRO DATA

Metadata driven monitoring of electronic data capture NTTS 2019 14 Census data collection process - Dashboard CSEntry Supervisor CSEntry CSEntry Dashboard (Istat) CSWEB MICRO DATA MONITOR

Metadata driven monitoring of electronic data capture NTTS 2019 GIS DB 15 Data architecture: data flow STAGE 1 STAGE 2 CSWEB MICRO DATA CSPro plain file Separated columns

STAGE 3 GIS DB MONITOR Report tables Metadata driven monitoring of electronic data capture NTTS 2019 16 Data architecture: data flow STAGE 1 STAGE 2 CSWEB

MICRO DATA CSPro plain file Separated columns STAGE 3 GIS DB MONITOR Report tables Metadata driven monitoring of electronic data capture NTTS 2019 17

Data architecture: data flow STAGE 1 STAGE 2 CSWEB MICRO DATA CSPro plain file Separated columns STAGE 3 GIS DB MONITOR

Report tables Metadata driven monitoring of electronic data capture NTTS 2019 18 Architectural components In order to implement the data collection process described above you need: CSPro data dictionary: the data dictionary contains all the questionnaire metadata (e.g. variables, classifications, relations between variables) Cspro2sql: parsing the content of the data dictionary, cspro2sql generates the scripts to create the microdata database and to load microdata collected using CSPro Dashboard: a web application implemented using open source Java frameworks. The dashboard displays the reports generated by cspro2sql Metadata driven monitoring of electronic data capture NTTS 2019

20 Architectural components: cspro2sql Cspro2sql: parsing the content of the data dictionary, cspro2sql generates the scripts to create the microdata database and to load microdata collected using CSPro https://github.com/mauroIstat/CSPro2Sql Metadata driven monitoring of electronic data capture NTTS 2019 21 Architectural components: dashboard Dashboard: a web application implemented using open source Java frameworks. The dashboard displays the reports generated by cspro2sql https://github.com/drovandi/CSProDashboard Metadata driven monitoring of electronic data capture NTTS 2019

22 a success story Improved statistical capacity of CSA in performing census survey Sustainable goals achieved Census process standardization A set of tools that can be used/modified in several surveys by CSA staff Easy software enhancements over the time Win-Win cooperation Learning from each other how to build reusable solutions for different countries Metadata driven monitoring of electronic data capture NTTS 2019 23 Thank you!

[email protected] Generalized Process for Business Statistics SORS, 6/11/2017 24

Recently Viewed Presentations

  • Literature Circles Independent Study Unit

    Literature Circles Independent Study Unit

    Divergent - Veronica Roth. In Beatrice Prior''s dystopian Chicago world, society is divided into five factions, each dedicated to the cultivation of a particular virtue-Candor (the honest), Abnegation (the selfless), Dauntless (the brave), Amity (the peaceful), and Erudite (the intelligent).
  • Title of Presentation - Jefferson Lab

    Title of Presentation - Jefferson Lab

    Source Dependencies. Thermal Emittance: Intrinsic property of a cathode. Depends on work function, surface roughness, laser wavelength, temperature.
  • Chapter 9 Correlational Research Designs

    Chapter 9 Correlational Research Designs

    Chapter 9 Correlational Research Designs What are correlational research designs, and why are they used in behavioral research. What patterns of association can occur between two quantitative
  • Get Hooked on a Wiki - Valparaiso University

    Get Hooked on a Wiki - Valparaiso University

    Get "Hooked" On A Wiki. Becky Klein. Matt Smith. Dave Sierkowski. TheOffice of Information Technology at VU has been looking for ways to better facilitate information flow among staff members, especially since a new CIO came on board and restructured...
  • Writing Specific Aims: The Cornerstone of a Successful ...

    Writing Specific Aims: The Cornerstone of a Successful ...

    Each specific aim has a short descriptive title and brief description. Aim 1: To determine the pathogenesis of the disease in vivo. Based on our hypothesis, we predict that disruption of the interaction between XYZ and the ABC receptor will...
  • ADD PROJECT AND COUNTRY ADD NAME What is

    ADD PROJECT AND COUNTRY ADD NAME What is

    Raleigh offer two programmes: expeditions which young people join directly or through referral agencies, and people aged 25 plus join to help run the expeditions; and ICS. Raleigh run expeditions in Borneo, Costa Rica and Nicaragua, Nepal and Tanzania and...
  • Why Cant We All Just Get Along? Malachi

    Why Cant We All Just Get Along? Malachi

    Malachi 2:10-12. 10 Don't we all come from one Father?Aren't we all created by the same God? So why can't we get along? Why do we desecrate the covenant of our ancestors that binds us together?
  • Gender Specific Effects of Early-Life Events on Adult Lifespan

    Gender Specific Effects of Early-Life Events on Adult Lifespan

    SSA DMF birth cohort mortality Nelson-Aalen monthly estimates of hazard rates using Stata 11 Selection of competing mortality models using DMF data Data with reasonably good quality were used: non-Southern states and 85-106 years age interval Gompertz and logistic (Kannisto)...