Streamlining Data Compilation and Dissemination at ILO: A New Approach for Improved Quality
This presentation outlines the challenges faced by the ILO's current data compilation and dissemination processes, including high maintenance costs, low response rates, and issues with data comparability. A new, country-centric approach is introduced, featuring streamlined procedures and enhanced IT considerations. By implementing an automated e-questionnaire system, a controlled vocabulary for metadata, and a unified online platform, ILO aims to improve data quality, enhance stakeholder engagement, and reduce publication delays.
Streamlining Data Compilation and Dissemination at ILO: A New Approach for Improved Quality
E N D
Presentation Transcript
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 • Betterresponse rate • Reduceddelayin disseminating • More indicatorscovering the DW agenda • Improveoverall data quality
Agenda • The old system • Processoverview • IT considerations • The new approach • Processoverview • IT considerations • Conclusions
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
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
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
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
Data Workflow Qtable (country + indic + survey) E-mail (country + user)
Currentwebsiteservicesdelivery Independentuser interfaces Content & Documents WCMS 10g LABORSTA data SAS Colaboration LABORSTA backoffice Plone
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
Conclusions • Increasedcoverage • Improved opportunity • Improved quality • Reduced overburden • Standards based • General purpose • Reduced TCO
Questions? E-mail:greising@ilo.org Skype:egreising Twitter: egreising LinkedIn: http://www.linkedin.com/in/egreising
Thank you! E-mail:greising@ilo.org Skype:egreising Twitter: egreising LinkedIn: http://www.linkedin.com/in/egreising