1 / 13

STREAMLINING DATA COMPILATION AND DISSEMINATION

STREAMLINING DATA COMPILATION AND DISSEMINATION . ILO Department of Statistics. Edgardo Greising greising@ilo.org. Introduction. Why ? High maintenance costs Low coverage Problems of comparability between data What? Applications Procedures Objectives Better response rate

genero
Download Presentation

STREAMLINING DATA COMPILATION AND DISSEMINATION

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. STREAMLINING DATA COMPILATION AND DISSEMINATION ILO Department of Statistics Edgardo Greising greising@ilo.org

  2. Introduction • Why? • High maintenance costs • Low coverage • Problems of comparability between data • What? • Applications • Procedures • Objectives • Betterresponse rate • Reduceddelayin disseminating • More indicatorscovering the DW agenda • Improveoverall data quality

  3. Agenda • The old system • Processoverview • IT considerations • The new approach • Processoverview • IT considerations • Conclusions

  4. The old systemProcessOverview • Manualconsistency • No procedure to re-contact non-responding countries • Thousands of footnotes, dozens of them meaning exactly the same • “Source & Methods” metadata collected as text documents • Veracity relayed on huge workload • Declining response rate • Delayed publication release • High direct costs • Overburden to countries

  5. The old systemIT considerations • Data stored in a hierarchicaldatabase • Time consuming «per sheet» uploadprocedure • Unfriendlyconsistencychecking program turneduseless • Data with errors not marked, could be published • No solution for “false positives” • Command line editor • Disconnected dissemination tools • Manual workflow management • High maintenance costs

  6. The new approachProcessOverview • Country-centric approach • Broader interaction with countries • Off-line x-Questionnaire (Excel) • e-Questionnaire • EDI (SDMX) • Controlledvocabularyfootnotes system • Error-free data passed to the disseminationdatabase • New ILOSTAT websiteintegrated to Department of Statistics’ and ILO’s IKMG

  7. The new approachIT considerations • Modular design following GSBPM • Oracle RDBMS and developmenttools • Automatedprocedure for xQ and SDMX uploadingwith structural consistency • E-Questionnaire online data collection • Single set of metadata • Single interactive consistencyprocedureregardless of data collection means • «False positives» handling thruallowanceissuing • Full screen data editor • Dynamic content dissemination website • Data workflow management module

  8. Data Workflow Qtable (country + indic + survey) E-mail (country + user)

  9. Currentwebsiteservicesdelivery Independentuser interfaces Content & Documents WCMS 10g LABORSTA data SAS Colaboration LABORSTA backoffice Plone

  10. New websiteservicesdelivery Unifieduser interface Colaboration & Social Network Content & Documents (Dynamic) WCMS 11g WCMS 10g Oracle DBMS WebCenter Spaces Backoffice Applications ILOSTAT data Oracle WebCenter Portal APEX SAS Oracle DBMS OBI EE

  11. Conclusions • Increasedcoverage • Improved opportunity • Improved quality • Reduced overburden • Standards based • General purpose • Reduced TCO

  12. Questions? E-mail:greising@ilo.org Skype:egreising Twitter: egreising LinkedIn: http://www.linkedin.com/in/egreising

  13. Thank you! E-mail:greising@ilo.org Skype:egreising Twitter: egreising LinkedIn: http://www.linkedin.com/in/egreising

More Related