Insights from single datasets

Goal: Generate insights from single datasets and the data quality.


  1. Locate the datasets that have visualisations: Go to your dashboard > under City Library go to “Datasets” > Click on “Datasets with visualisations”; See this example
  2. Choose the visualisations that will enrich your SCA report, such as those that (1) have the most accurate data and/or (2) data that represents the sector and/or (3) waste collection amounts and/or (4) waste treatment shares. This is because they will give good insights into the (circularity of the) sector.
  3. Select the most suitable chart type and download them as an image.
  4. Add the image to the dataset and note down the ID of this new library item.
  5. Ask yourself the exemplary questions below and note down the answers in the respective chapters where you include the visualisations.

Exemplary questions for analysis

  • What can be seen in the graphic?
  • What sector is this about?
  • What materials are involved?
  • What is the share of the single materials?
  • What year(s) is the data for? if there is a clear evolution or trend etc.
  • Is there a clear evolution or trend for a material? How did it increase or decrease over time?

Outline of the video

  • Aside from the Sankey, there are other visualisations in the form of diagrams that are based on your data. You have already seen them once you have processed a dataset.
  • With all those nice datasets, it will be great to feature some in the SCA report. Therefore, we encourage you to choose some that you’d like to add in the report, such as pie charts or evolutions of constructed buildings.
  • This can eventually be done in the report form under Data analysis > “Insights on status quo”
  • There is no minimum amount or limit on how many you should choose. Just be aware that you will have to describe them in the report a bit, to put them into context.
  • Be sure to add the ID of this new entry to link the image in the report.
  • Visualisations to include: We recommend that you choose those visualisations that (1) have the most accurate data or (2) data that represents the sector or (3) waste collection amounts or (4) waste treatment shares. This is because they will give good insights into the sector.
  • Once you have selected a visualisation that you want to include, you should choose the best way to represent data. You do so by selecting the most suitable chart type.
  • In the example, the AREA chart type or PIE chart type (for your reference year) would be quite suitable.
  • In order to add it to the report, you need the ID again. However, adding the original ID will simply add the first chart type, and not what you have selected. Therefore, you need to download the image.
  • You can download the chart as a .png image and attach it to the dataset library item. To do so, you can attach it in the data collection section, by clicking on “+ Add image” at the end of the row, see here.
  • You can now add the ID of this static image to the report in the format with the square brackets [#ID] where ID is the ID number of the dataset.