Unit 5: Creating a Dashboard

Defining the Dashboard's Purpose and Audience
SDMX-DG Dashboard
SDMX-DG Dashboard

Finding SDMX Data

Here is a shortlist of public SDMX APIs to help you get the data you require.

Note: A catalogue of SDMX APIs is being published on sdmx.io - watch the Data Science section on sdmx.io for more information.

pdf download
iText

Click the icon to download a job aid listing these resources.

Background

Create a Dashboard using YAML

Below we will look at the steps with the YAML code to build a dashboard , using as an example, a Labour Statistics Dashboard named ex_labour_statistics_dashboard.yaml

Step 1: Identify Data and Indicators

Find the data

  • Find the best available data from an SDMX API.
  • For global population statistics, the International Labour Organisation (ILO) is a good resource.

Identify indicators of interest

  • Earlier we identified labour market indicators of interest.

Core Labour Market Indicators available from the ILO

  • Unemployment Rate by sex and age: DF_UNE_DEAP_SEX_AGE_RT
  • Labour Force Participation Rate by sex and age: DF_EAP_DWAP_SEX_AGE_RT
  • Employment-to-Population Ratio by sex and age: DF_EMP_DWAP_SEX_AGE_RT
  • Job Creation & Losses: no data found
  • Wage Growth: no data found
  • Underemployment Rate: DF_TRU_DEMP_SEX_AGE_RT
Background

Note on SDMX API

This course does not aim to go into details on SDMX API data. Here is a simple refresher to interpret the API call:

itext Click the Information Icon to find out what the highlighted code means.

Code

https://sdmx.ilo.org/rest/data/ DF_POP_XWAP_SEX_AGE_NB/CAN+FRA+DEU+ITA+JPN+GBR+USA.A.POP_XWAP_NB.SEX_T.AGE_AGGREGATE_TOTAL"

Step 2: Add Charts to Your Dashboard

Click each tab to learn more.

Step 3: Finalize Your Dashboard

Load the YAML file
Load the dashboard
Verify the API URL
Adjust colours
Background

Load the YAML file into SDMX-DG by moving the labour_statistics_dashboard.yaml into the SDMX-DG yaml/ directory.

pdf download
iText

Click the icon to download a job aid listing the steps to build your dashboard.