Stock data processing

Outline of the video

  • First show you how you can start to work on a file and then discuss in which format the data needs to be.
  • Example: Buildings by building material 1960-2019 in Finland
  • The stock data processing template has 8 columns. Going through them one by one to explain what they are.
  • Different from the flow data processing is that start and end date columns aren’t there. This is because those aren’t needed for stock, as it stays for more than a year in the system.
  • Back to the example, formatting the data after copying it from the source.
  • Unfortunately the unit is not in tonnes, but instead buildings in numbers.
  • We will just use it to show how the data can be arranged based on the info from the source.


  • Livestock
    • This is an example of a chaotic file. In this case, it is best to go to the original source and try to get the comma separated values in a better shape. However, in this case the source does not exist or is not given, which underlines the importance of providing it, always.
  • Rather unusual “stock” example to demonstrate the processing, dairy products.
    • The “Type of dairy product” column can be used as segments.
    • And as always, correct EMP codes need to be looked up.