introduction to data modeling - un escap...introduction to data modeling statistics division,...
TRANSCRIPT
![Page 1: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/1.jpg)
Introduction to Data Modeling
Statistics Division, September 2019
![Page 2: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/2.jpg)
Data Structure Definitions
• DSDs are a description of the data model
• SDMX provides a framework to build DSDs
• To design a DSD, we first need to find concepts that
identify and describe our data
• Each concept describes something about the data
![Page 3: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/3.jpg)
Building DSDs
![Page 4: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/4.jpg)
Building DSDs
Concepts
Dimensions
Primary Measure
(Obs. Value)
Attributes
![Page 5: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/5.jpg)
Dimension or Attribute?
• Concepts that identify data, should be made dimensions
• Concepts that provide additional information about data,
should be made attributes
If a concept is a dimension, it is possible
to have time series that are different only
in the value of this concept
![Page 6: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/6.jpg)
Time Dimension
• TIME dimension provides the observation time
• FREQUENCY dimension describes interval between
observations (yearly, quarterly, daily, etc.)
![Page 7: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/7.jpg)
Representation
Coded
• Based on code lists
• For example:Country, Sex, Indicator
Un-coded with format
• Format specified
• For example: postal code with 5 digits
Un-coded free text
• Any text is valid
• For example: footnote
![Page 8: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/8.jpg)
Examples of Code Lists
![Page 9: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/9.jpg)
Representation of Concepts
• Dimensions must always be coded
• Attributes can be coded or un-coded
![Page 10: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/10.jpg)
SDG Data Structure
• Developed by the IAEG-SDG Working Group on SDMX
• Version 1.0 released in June 2019 (link)
![Page 11: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/11.jpg)
SDG DSD – Dimensions
Frequency
Reporting Type
Series
Reference Area
Sex
Age
Degree of urbanization
Income or wealth quantile
Education level
Occupation
Disability status
Economic activity
Product type
Custom breakdown
Composite breakdown
Time period
![Page 12: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/12.jpg)
SDG DSD – Dimensions
• Reporting type: ‘N’ for national, ‘G’ for global
• Sex: when series refer to female population, use ‘F’ – for
example: Number of seats held by women in national
parliaments
• Custom breakdown: for non-standard breakdown, ad-hoc
• Composite breakdown: combination of few seldom used
breakdowns
![Page 13: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/13.jpg)
SDG DSD – Code Lists
• Dimensions with breakdown have a code _T to denote the
total or no breakdown. For example CL_URBANISATION
• Code list CL_AREA has countries and groupings. For
country-level use, the code list needs to be expanded with
regions, cities, provinces, etc.
Code Description
_T Total
U Urban
R Rural
![Page 14: Introduction to Data Modeling - UN ESCAP...Introduction to Data Modeling Statistics Division, September 2019 Data Structure Definitions • DSDs are a description of the data model](https://reader036.vdocuments.us/reader036/viewer/2022063019/5fdf0243a0dc4d0456745d03/html5/thumbnails/14.jpg)
THANK YOU
WWW.UNESCAP.ORG
UNESCAP
UNESCAP
UNESCAP
UNITEDNATIONSESCAP
UNITEDNATIONSESCAP