1 / 22

ESCWA SDMX Workshop

ESCWA SDMX Workshop. Session: Data Formats. Country: UK Unemployed: 13million Year: 2010. Country: Australia State : Perth Coastline (Km): 12500. Country: France Unemployed: 5million Year: 1982. What is Data?. Results of Measurements. Data Set. KEY. KEY. Values. Values.

smithcory
Download Presentation

ESCWA SDMX Workshop

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. ESCWA SDMX Workshop Session: Data Formats

  2. Country: UK Unemployed: 13million Year: 2010 Country: Australia State : Perth Coastline (Km): 12500 Country: France Unemployed: 5million Year: 1982 What is Data? • Results of Measurements

  3. Data Set KEY KEY Values Values What is a DataSet? • An organisedcollection of Data Think of a Dataset as an organised container for exchanging Data

  4. How is the Data organised? Use case: House Price Data

  5. Code List Dimensions (Concepts) Average House Price • House Type • Terrace • Semi Detached • Detached • County (location) • Surrey • Hampshire • Number Bedrooms • Time • Average Price (measure)

  6. Data

  7. KEY House Type Terrace County Surrey Bedrooms 2 House Type Semi-Det House Type Detached County Surrey County Hampshire Bedrooms 2 Bedrooms 3 VALUES VALUES VALUES 2008 130,000 2009 150,000 2010 220,000 2008 200,000 2008 210,000 2009 220,000 2009 210,000 Time Series View

  8. KEY House Type Terrace Bedrooms 2 Time 2008 VALUES Surrey 130,000 Hampshire 200,000 Pivot on County

  9. Pivot on House Type KEY County Surrey Bedrooms 2 Time 2008 VALUES Terrace 130,000 Semi 220,000 Detached 300,000

  10. Q: What is the Key? A: Anything except the Observation Value and a pivot dimension

  11. Values Key Pivot on House Type

  12. Values Key Pivot on Country

  13. Values Key Add new Dimension

  14. DataSet and SDMX Schema

  15. The way the XML is structured 1. GENERIC 2. COMPACT <Person name=“Matt” age=“28” /> <Person> <Name>Matt</Name> <Age>28</Age> </Person> SDMX Schema for Data • SDMX Has 2 Widely Used Formats Data

  16. KEY VALUES Generic Data

  17. KEY VALUES KEY VALUE KEY VALUE DATASET Compact Data

  18. GENERIC DATA – ONE SERIES COMPACT DATA – ONE SERIES

  19. SERIES ATTRIBUTES GENERIC DATA – 1 Series COMPACT DATA – 1 Series

  20. OBSERVATION ATTRIBUTES GENERIC DATA – 1 Observation COMPACT DATA – 3 Observations

  21. Exercise Generate Schema • Open Up the SDMX Tool Suite • Drag DSD File onto Tool Suite • Generate a Compact Schema

  22. Web Services

More Related