How to Forecast Hierarchical Time Series | by Dr. Robert Kübler | Aug, 2024

Editor
2 Min Read


A beginner’s guide to forecast reconciliation

Photo by Krista Mangulsone on Unsplash

Imagine you’re a data scientist at a charming little pet shop specializing in just five products: two varieties of cat food and three types of dog food. Your mission? To help this small business flourish by accurately forecasting the weekly sales for each product. The goal is to provide a comprehensive sales forecast — total sales, as well as detailed predictions for cat food and dog food sales, and even individual product sales.

The Data

You have data on the sales of the different types of cat food A and B, as well as the different types of dog food C, D, and E for 200 days. Lucky for us, the data is exceptionally clean, with no missing values, and no outliers. Also, there is no trend. It looks like this:

Image by the author.

Note: I generated the data myself.

In addition to the individual sales, we also have the aggregated sales for all cat food products, all dog food products, and all products. We call such a collection of time series hierarchical time series. In our case, they respect the following sales hierarchy:

Share this Article
Please enter CoinGecko Free Api Key to get this plugin works.