1 / 20

Implementing SDMX exchange of national development indicators

Implementing SDMX exchange of national development indicators SDMX Expert Group Meeting, Paris, 13 – 14 September 2012. UNSD-DFID Project. Introduction Progress on country SDMX Design Key issues Questions & discussion. Introduction: Objectives.

larue
Download Presentation

Implementing SDMX exchange of national development indicators

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Implementing SDMX exchange of national development indicators SDMX Expert Group Meeting, Paris, 13 – 14 September 2012

  2. UNSD-DFID Project • Introduction • Progress on country SDMX • Design • Key issues • Questions & discussion

  3. Introduction: Objectives • Improve the coherence and clarity of dev’t indicators • Improve coordination in the NSS • Collate development data in 1 place/database • Explain differences between intl. & nat. data • Improve accessibility and visibility • Make access to national data easier • Draw attention to wider set of indicators • Reduce data request burden • Enhance knowledge • Strengthen IT support • Use of latest IT software & practices • Training & study tours

  4. Introduction: Background • Implementation in 11 countries across Africa and Asia • A pilot ran during 2008-2009, full phase started in late 2010 • All countries initiated now, 5 countries started implementing and 5 about to start. • Project runs until Jul 2014

  5. Progress on country SDMX May 2011 Cambodia : SDMX registry installed & mappings of 46 time series complete/ available (with further 175 time series identified for mapping) Burundi : SDMX registry installed Rwanda : Expanded SDMX registry Lao & Uganda : Expanded SDMX registry & mapping tool Feb 2012 Jun 2012 Planned to Dec 2012

  6. Design: Overview • Most project countries are unfamiliar with SDMX • Many do not have experience with underlying technologies such as XML, XSLT. • Conflicting pressures on project solution: • Must be simple to use, to facilitate its adoption • Must be powerful, to fulfill requirements • Must give the user a chance to familiarize themselves with SDMX.

  7. Design: SDMX solution • Some of the ways in which project solution simplifies the implementation of SDMX: • Automated mapping between DevInfo database structures and CountryData DSD • Automated data export from DevInfo database into CountryData SDMX • Automated publication of data and registration of datasets at a DevInfo registry.

  8. Line Ministry Database XLS Design: System Line Ministries National Statistical Office United Nations National Repository DB Post notification DevInfo Upload Mapping tool Publish Scripts SDMX-ML Download National Indicator Registry Register files

  9. Design: SDMX add-ons • Project works with DevInfo to expand functionality offered by DevInfo registry and offer such new features as: • User-defined dataflows, metadataflows, and provision agreements • Constraints • Metadata discovery and other Web service functionality.

  10. Design: MDG DSD • Supports exchange of MDG Indicator data between international agencies (UN, UNICEF, UNESCO, …) • Developed by SDMX Task Team of Interagency and Expert Group on Development Indicators (IAEG) • Implemented in SDMX 2.0 • CountryData DSD is based on the MDG DSD.

  11. Design: CountryData DSD • Codelists amended to support non-MDG development indicators published by countries • To avoid confusion and clearly separate national and international data, a new DSD with its own ID was defined for the project, which reuses MDG artefacts as much as possible. • Codelists are currently maintained by UNSD • New indicators proposed by project countries are introduced with a lag • Centralised codelist maintenance unsustainable in the long run as more countries join the project.

  12. Design: CountryData MSD • Based on the MDG global database, agreed by the IAEG (i.e. definition, method of computation etc.). • Attachment at the indicator level • Key to understanding differences between international estimates and country estimates of the same indicator • Also benefits in consistency, transparency, reporting burden, …

  13. Key issues: Codelist maintenance • Codelist maintenance must eventually be taken over by the countries • Compatibility becomes an issue. • Design under consideration envisages using constrained dataflows to maintain compatibility.

  14. Key issues: Matching • Trying to match a country indicator with an available indicator code • At what point is a new code required • i.e. For the indicator “Using improved drinking water / sanitation” does measurement on a household basis rather than population make it different indicators? • Or using Gross instead of Net to calculate Gender Parity Indices make them a separate indicators?

  15. Key issues: Mapping • Process of mapping the indicator time series to other dimensions (i.e. Sex, Age group, Location etc.) • Complicated by the fact that MDG and other development indicators vary greatly in their dimensionality • Further guidance developed to ensure codelist items are applied properly

  16. Key issues: Metadata exchange • Metadata is usually not comprehensive enough to understand comparability. • The importance of good metadata (and even what it is?) is little understood within some National Statistical Systems. • Few examples of metadata exchange using SMDX • Format issues: HTML vs. Plain Text, Presentation vs. security.

  17. Key questions • Project Sustainability • Sharing national development indicators in SDMX • Commitment to maintaining good metadata • Governance • Managing structural metadata among multiple national and international organizations • Expansion • System used for greater sharing between different parties.

  18. Thank you for your attention Sources of further reference: http://data.un.org/countrydata Cambodia SDMX Registry http://nd.nis.gov.kh/registry/ Rwanda SDMX Registry http://sdmx.statistics.gov.rw/ http://unstats.un.org

More Related