1 / 19

STREAMLINING DATA COMPILATION AND DISSEMINATION Lessons Learned

STREAMLINING DATA COMPILATION AND DISSEMINATION Lessons Learned. ILO Department of Statistics. Edgardo Greising greising@ilo.org. Introduction. MSIS 2012. Introduction. MSIS 2012. Agenda. Lessons Learned Changing the procedures Application development Current status.

Download Presentation

STREAMLINING DATA COMPILATION AND DISSEMINATION Lessons Learned

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 Lessons Learned ILO Department of Statistics Edgardo Greising greising@ilo.org

  2. Introduction • MSIS 2012

  3. Introduction • MSIS 2012

  4. Agenda • LessonsLearned • Changing the procedures • Application development • Currentstatus

  5. Changing the procedures • From Topic- to Country-centric approach • «Country specialists» assigned based on language and cultural affinity • Coverageincreasedcompared to last 5 years • Evenwith 72 indicatorsfrom 17 topics • Training needed, specially on new topics • CS requestingimprovements in contacts management tool

  6. Changing the procedures • Towards timely and comparable data • Timeliness has to be improved. What was wrong? • New questionnaire, broader and bigger • New topics • New IT tools, some under development • Comparability improved • Adhering to suggested breakdowns • Coded notes • Data quality improved thanks to extensive consistency checking

  7. Changing the procedures • Towards timely and comparable data • For next collection: • Some indicators to be simplified • Some breakdowns to be simplified • New data channels available • Increase technical assistance to countries • Increase response rate

  8. Application development • “The size of the accomplishment can be measured by the obstacles you have to overcome to reach your goals” – Booker T. Washington • Conceptual design of new collection took too long and put high pressure on development • An agile iterative-incremental development model was adopted to provide “ready-to-work” basic versions of the tools • Early adoption of a new software platform in the ILO was the cause of several delays

  9. Application development • “Vamos más despacio, Sancho, que estoy apurado” – Don Quijote de la Mancha(Let’sgoslower, Sancho, I’m in a hurry). • Some modules of the initial project were deferred because: • eQuestionnaire: We privileged backoffice editing tools aiming to efficiency and data quality • SDMX and csv upload: Many developing countries lack a repository of indicators as to easily generate the files in the format requested.

  10. Application development • Knowing how it goes. • The Workflow Control Subsystem was misunderstood by the CS as a tool for controlling their work • After some time, they started to understand the usefulness of having real time information of contacts made and data status • Now they are providing feedback on improvements for the workflow dashboard reports • Task1

  11. Application development • To BI or not to BI?

  12. Application development • To BI or not to BI? • ILOSTAT isbased on Oracle technology platform (ILO standard) • Dissemination based on WebCenter portal manager with OBI-EE for building the reports (Original idea) • Standard BI reports were not able to handle breakdown’s labels and footnotes properly • Star-schema datawarehouse did not provide any added value to the solution • Switched to ad-hoc reporting solution using ADF and a “flat” materialized view for dissemination • Valuable help from the official statistics community in sharing experiences

  13. Application development • All you need is data… • Fully metadata driven website • Every navigation menu is contextual and is built dynamically • Avoid duplication of efforts in editing web pages • Minimize errors due to missed updates

  14. Current status • Increasedcoverage • Improved timeliness • Improved quality • Reduced overburden • Standards based • Metadata driven • General purpose

  15. ILOSTAT Stats 2 78,916 9 364,524 71 165 1,657 ~5,000,000 49 427 7,719 137 17 30,121

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

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

  18. Changing the procedures • From Topic- to Country-centric approach

  19. Application development • Knowing how it goes. Qtable (country + indic + survey) E-mail (country + user)

More Related