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.

Examples

• 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.