ilostat statistical indicators database
DESCRIPTION
After many years of operating with an old system for the compilation and dissemination of labor statistics, the need to streamline processes and have new tools in the ILO Department of Statistics was clear. High maintenance costs, low coverage and problems of comparability between data were some of the most important gaps that determined the urgent need to redesign the system. The project to redesign the department’s approach included not only the development of new applications using updated and appropriate tools to achieve the required functionality, but procedures that could be automatized and allowed to have an auxiliary system for monitoring the flow of information to assist in the task of data collection. One aspect that was emphasized from the beginning of the new project was the adoption of every possible standard, so as to increase the chance of interaction with our partners. Thus, the process follows the recommendations of GSBPM, development tools from the Oracle suite (a “de facto” standard) are used, and the means of collection are based on Excel, XML and SDMX (coming soon). The new process for data compilation and dissemination is built on five main ideas: - The broadening of the ways of interaction with the countries for data collection; - The full automation of computerized procedures, so as to enable Statistical Assistants to engage more efficiently in non-computerized activities; - The systematization of the consistency and correction procedure regardless of the way the data was received; and - The ability to know when and why (or why not) data from the countries is arriving, thus knowing how much information is to be included in a publication. - The addition of new indicators and variables to approach the DWI definition These simple ideas once implemented, would enable the new ILOSTAT database to have a better response rate from the countries, reduce the delay of the information received and improve the overall quality of the data published. The challenge was to achieve these objectives while simultaneously reducing the TCO of the system. This presentation describes the set of new processes and the IT tools developed so far (as well as those forthcoming), to optimize the data compilation and dissemination at the ILO Department of Statistics.TRANSCRIPT
Increase coverage in topics and countries More indicators covering the DW agenda Move to a «country oriented» collection
Reduced delay in disseminating Improve overall data quality &
comparability Reduce overburden to countries for data
collection Standards based General purpose, integral system Reduced TCO
Objectives
A new system: not only IT Effective dissemination ILOSTAT and DWI Conclusions
Agenda
The old systemProcess Overview
Paper or faxquestionnaire
SAS Database
SAS Database(Replica)
YEARBOOK Publication
Automatic Upload(per sheet basis)
Format & totals check
Manual Inputby Stat. Assistant
Full DB Consistency check
Automatic printout generation
OPTIONAL Editingby Stat. Assistant
Weeklyupdate
LABORSTA Website
YEARBOOK CD
No Answer
Manual data grabbingby Stat. Assistant
Internet
Excel questionnaires(9 books per country)
Manual consistency 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
Paper or faxquestionnaire
SAS Database
SAS Database(Replica)
YEARBOOK Publication
Automatic Upload(per sheet basis)
Format & totals check
Manual Inputby Stat. Assistant
Full DB Consistency check
Automatic printout generation
OPTIONAL Editingby Stat. Assistant
Weeklyupdate
LABORSTA Website
YEARBOOK CD
No Answer
Manual data grabbingby Stat. Assistant
Internet
Excel questionnaires(9 books per country)
Data stored in a hierarchical database
Time consuming «per sheet» upload procedure
Unfriendly consistency checking program turned useless
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 approachProcess Overview
Country-centric approach Broader interaction with countries
◦ Off-line x-Questionnaire (Excel)◦ e-Questionnaire◦ EDI (SDMX)
Controlled vocabulary footnotes system
Error-free data passed to the dissemination database
New ILOSTAT website integrated to Department of Statistics’ and ILO’s IKMG
Paper or fax
questionnaire
Data CollectionDatabase
Web Database(Replica)
YEARBOOK Publication
Full AutomaticUpload
Manual Inputby Stat. Assistant
Consistency check
Automatic printout generation
Editingby Stat. Assistant
Weeklyupdate
LABORSTA Website(with dynamic charts and maps)
NO
YEARBOOK CD
Excel questionnaires(1 simplified book)
SDMX fileE-Questionnaires
(on line via internet)
Full AutomaticUpload
Stat. AssistantE-mail or phone call
Country counterparts
Selected data collection mode
CORRECT?
Main Database
YES
No Answer Received
Error Report
Data Flow Control Dashboard
1 2 3 4 5
The new approachIT considerations
Modular design following GSBPM Oracle RDBMS and development tools Automated procedure for xQ and SDMX
uploading with structural consistency E-Questionnaire online data collection Single set of metadata Single interactive consistency
procedure regardless of data collection means
«False positives» handling thru allowance issuing
Full screen data editor Dynamic content dissemination website Data workflow management module
LABORSTA data
Content &Documents
Current website services deliveryIndependent user interfaces
Colaboration
WCMS 10g
SAS
Plone
LABORSTA
backoffice
Oracle WebCenter Portal
Content &Documents(Dynamic)
ILOSTAT data Backoffice
Applications
WCMS 11g
WCMS 10g
Oracle DBMS
OBI EE
WebCenter Spaces
APEX
SAS
Oracle DBMS
Colaboration &
Social Network
New website services deliveryUnified user interface
Accessing the data By Country By Subject By Source By Classification By Collection By DWI Bulk download
Crosscutting access to related publications, documents, survey’s metadata, etc
ILOSTAT and DWIM – Main decent work indicators LABORSTA YI STI Othe
r
Employment to population ratio
Unemployment rate
Youth not in education and not in employment
Informal employment
Working poor
Low pay rate (below 2/3 of median hourly earnings)
Employment in excessive working time
Child labour
Precarious Employment rate
Occupational segregation by sex
Female share of employment in senior and middle management
Occupational injury rate, fatal
Share of population aged 65 and above benefiting from a pension
Public social security expenditure (% of GDP)
Union density rate
Enterprises belonging to employer organization [rate]
Collective bargaining coverage rate
Indicator for Fundamental Principles and Rights at Work (To be dev)
AD-HOC
SIMPOC
SECSOC
SECSOC
ILOSTAT
ILOSTAT and DWIA – Additional decent work indicators LABORST
A YI STI Other
Labour force participation rate
Youth unemployment rate
Unemployment by level of education
Employment by status in employment
Proportion of own-account and contr. family workers in total empl.
Share of wage employment in non -agricultural employment
Average hourly earnings in selected occupations
Average real wages
Minimum wage as % of median wage
Manufacturing wage index
Employees with recent job training
Usual hours worked
Annual hours worked per employed person
Time -related underemployment rate
Hazardous child labour
Forced labour
SIMPOC
ILOSTAT
ILOSTAT and DWIA – Additional decent work indicators (cont.) LABORST
A
YI STI
Other
Job tenure
Subsistence worker rate
Real earnings casual workers
Gender wage gap
Other worst forms of child labour
Indicator for Fundamental Principles and Rights at Work
Measure for discrimination by race / ethnicity / of indigenous …
Share of women in wage employment in the non-agricultural sector
Occupational injury rate, non fatal
Time lost due to occupational injuries
Labour inspection (inspectors per 10,000 employed persons)
Health care exp. not financed out of pocket by private households
Share of population covered by (basic) health care provision
Strikes and lockouts/rates of days not worked
SECSOC
SECSOC
ILOSTAT
SIMPOC
ILOSTAT and DWI
C – Economic and social context for decent work LABORSTAYI ST
IOthe
r
Children not in school (% by age)
Estimated % of working age population who are HIV positive
Labour productivity (GDP per employed person, level & growth rate)
Income inequality (percentile ratio P90/P10, income or consumption)
Inflation rate (CPI)
Employment by branch of economic activity
Education of adult population
Labour share in GDP
Real GDP per capita in PPP$ (level and growth rate)
Female share of employment by industry
Wage / earnings inequality (percentile ratio P90/P10)
Poverty measures
UNESCO
WHO
UNESCOUNDP
IMF
ILOSTAT
ILOSTAT and DWI
SUMMARY TOTAL LABORSTA
ILOSTAT
M – Main decent work indicators 18 6 12
A – Additional decent work indicators 30 15 18
C – Economic and social context for decent work 12 3 8
TOTAL 60 24 38
[+Ext]
Conclusions
Increased coverage Improved opportunity Increased comparability Multi-mode data collection Standards based Integrates multiple “collections” Reduced TCO
Questions?
E-mail:[email protected]
Skype:egreising
Twitter: egreising
LinkedIn: http://www.linkedin.com/in/egreising
Thank you!
E-mail:[email protected]
Skype:egreising
Twitter: egreising
LinkedIn: http://www.linkedin.com/in/egreising