Migrating to the .Stat Suite by Edgardo Greising and Gyorgy ...

Migrating to the .Stat Suite Different approaches and tools available to assist in the migration Prepared and presented by Edgardo Greising (ILO) Gyorgy Gyomai (OECD) Agenda Presentation of scenarios & tools Breakout session: one group per scenario (30 min) Groups presentations (5 min each) Open discussion and conclusions

Migration Scenarios 1. Existing system is SDMX-capable or the Data Model is close to SDMX IM 2. A Database exists but requires re-modelling 3. No Database. Diversity of data sources Existing SDMX capabilities 1. Cubes may require re-modelling I. Load first, transform in DLM II. Transform off-line and upload definitive structures

2. Harmonization 3. Transitional solution for visualization 4. Toolkit [Which tools to use in the process for structure design, concepts recoding] Data Model is close to SDMX IM 1. Add SDMX capabilities Go to previous case 2. Cubes will require re-modelling: Transform off-line and upload the new structures

3. Harmonization 4. Toolkit [Which tools to use in the process for structure design, concepts recoding] Non-SDMX database Questions to ponder 1. Spacing [How many Dotstat spaces to maintain?] 2. Timing [Timescale and steps for the migration] when considering timing issues like skills building, data model development, migration planning come to play

3. Toolkit [Which tools to use in the process for structure design, data-flow (re)-routing?] No structured database blank page Similar to the non-SDMX database Bigger emphasis on knowledge acquisition, steeper learning curve Fewer spacing dilemmas, and less rugged edge Toolkit [Which tools to use in the process for structure design, data-flow (re)-routing?]

SMART Structural Metadata SDMX Registry DSD Dataset NRP DATA

REPORTING DATA CONVERSION Dataset SMART Microdata

LMIS UPLOAD LMI ANALYSIS Aggregated Data Dataset 8

PROJECT DSD Constructor Load & Edit a DSD Upload concepts DSD

SDMX Registry Upload Code lists DSD Codelist Manual entry

9 Excel2CSV Add-in Excel2CSV Add-in 10 All together DSD CONSTRUCTOR

DSD Excel2csv SMART PROJECT 11 DATA

REPORTING Excel Domain Modeler with SDMX generator https://github.com/OECDSTD/sdmx-matrix-generator Eurostat Data Structure Wizard An SDMX artefact editor Persisting locally or providing a frontend for and SDMX registry

The user needs to have an understanding of the relationship between the different objects However user-friendly UI, no need to directly manipulate the SDMX syntax EDD scripting (Excel Data Description) Some powertools to consider ILO plugin for Dotstat Eurostat SDMX-RI plugin to Dotstat (with Mapping Assistant) ISTAT Meta-manager