170 likes | 315 Views
Unified Enterprise Survey and Metadata. Third International Conference on Establishment Surveys. Sylvain Boucher Statistical Metadata Specialist Standards Division. Montreal June, 2007. UES and Metadata. UES and infrastructure. Integrated Questionnaire and Metadata System (IQMS).
E N D
Unified Enterprise Survey and Metadata Third International Conference on Establishment Surveys Sylvain Boucher Statistical Metadata Specialist Standards Division Montreal June, 2007
UES and Metadata • UES and infrastructure • Integrated Questionnaire and Metadata System (IQMS)
UES and Metadata • What • Why • Who
UES and Metadata Who » Client Processes Questionnaire Development Collection Applications Data Warehouse Estimations Data Browser (USTART) IQMS Allocation Correction tool Edit and Imputation
UES and Metadata What » Content • Questionnaire Cells • Building New Questionnaires • Survey Identification Numbers
UES and Metadata What » Collection • Collection Application Specifications • Capture Specifications • Edit Specifications • Output Specifications • Managing Collection Edit Changes
UES and Metadata What » Data Warehouse • Variables Stored in the Warehouse • Tax Data • Derived • Frame
UES and Metadata Data Warehouse What » Post-Collection • Applications • Correction tool • Edit and Imputation • Allocation • Estimations Data Browser (USTART)
UES and Metadata What » Managing ‘Traffic’
UES and Metadata Why IQMS Was Created? • Collection Applications • Standardize Metadata and Reports • Official Source of Information
UES and Metadata Why IQMS Evolved • Share Data between Processes • Timeliness of Processing and Metadata Coherence • Less Maintenance
Post-Collection (ESD) Data Management(ESD) Subject Matter Content and Data Management (ESD) Who » Maintenance Questionnaire Survey Identifiers Capture Cells Specifications PCP Cells PCP Metadata Data Warehouse Variables Processing sources ‘Filters’ Derived Variables Collection Edit Specifications
UES and Metadata Who, What, Why and… Wow !!!
UES and Metadata Additional Notes on IQMS • IQMS and Access • Data transfer from IQMS to SAS • New Reference Year Initialisation
UES and Metadata UES metadata… and tomorrow
UES and Metadata Thank you!