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

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

Recently Viewed Presentations

  • Body Mechanics - Healthcare Science

    Body Mechanics - Healthcare Science

    Body Mechanics. Positions and movements used to maintain proper posture and avoid muscle and bone injuries. Back injury is the number one injury experienced by health care workers while they are on the job.
  • Presentation EC project

    Presentation EC project

    - leave it to free market forces to play their role (possible in countries with more than 3 cables e.g. Nigeria, Kenya, South Africa, Ghana) - regulation (essential in particular in countries with a single landing station) - the example...
  • Guardians of the Person & Property Training - Maryland Judiciary

    Guardians of the Person & Property Training - Maryland Judiciary

    Lacks the physical or mental capacity to provide for their personal or financial needs. ... In reality, the court is the disabled person's ultimate guardian. ... MAP is statewide program that can connect you with resources. For more information, contact...
  • Data Analysis DNA Microarrays - Massachusetts Institute of ...

    Data Analysis DNA Microarrays - Massachusetts Institute of ...

    Data Analysis DNA Microarrays ... Oligofectamine control (cy3) and knockdown (cy5) Cy3/cy5=ratio=fold change Data Analysis Step 6-Generate Summaries Number of Genes with differential gene expression fold change above a cutoff (1.5) Number of Genes expressed on array (need not be...
  • Why did people believe the ideas of Hippocrates

    Why did people believe the ideas of Hippocrates

    Why did people believe the ideas of Hippocrates and Galen for so long? Ian Dawson www.thinkinghistory.co.uk How long were their ideas believed? Why did people believe the ideas of Hippocrates and Galen for so long? 0 - Ideas and methods...
  • Smart Business Gateway - Aria Technologies

    Smart Business Gateway - Aria Technologies

    MOH. Station Groups. Paging. 3 Way Conference. Dialing Restrictions (Class of Service) Prime Line - Immediate/Delayed(Hot line) SMDR . Authorization Codes. Mobile Extensions. Networking. DHCP Server. IP Address distribution. File Server. Print Server ... Diagnostic Tool. Set Trace Direction. Set...
  • Metabolism of Sulfur containing amino acids Dr. Ketki

    Metabolism of Sulfur containing amino acids Dr. Ketki

    Cystinosis (cystine storage disease). Cystine crystals are deposited in many tissues & organs of reticulo-endothelial system throughout the body. These include spleen, lymph nodes, liver, kidney, bone marrow etc.
  • Exploring On-site Food Waste Reduction: Dehydrators and ...

    Exploring On-site Food Waste Reduction: Dehydrators and ...

    The state welcomes Tribal governments to explore if becoming certified beverage container collection centers or service programs would make sense. The application process to become a certified collection center is described on CalRecycle's website. CalRecycle staff are available today to...