1 minute read

The Cereal Industry Had A Very Weird Year

About Makeover Monday

MakeoverMonday is a social data project: “Each week we post a link to a chart, and its data, and then you rework the chart. Maybe you retell the story more effectively, or find a new story in the data. We’re curious to see the different approaches you all take. Whether it’s a simple bar chart or an elaborate infographic, we encourage everyone of all skills to partake. Together we can have broader conversations about and with data.”

Starting from Jan 08, 2018, I decided to put aside one hour on Monday weekly to create some visualization and find some insights from the data.

The datasets are published each week at: MakeoverMonday Datasets.

Makeover Monday 20210322

This week’s topic is US monthly personal consumption expenditure. It’s really interesting to see how COVID has impact people’s expense on food. The original article specifically talks about cereal expense, but the datasets contain the data for many other categories.

My Visualization

I made some rose-shape chart to visualize the YoY expenditure change % with the color representing time (deeper as more recent).


Please notice that all the visualizations are designed for desktop view, so it is recommended to view them on a desktop device.

Dashboard link

Insights

  • For cereal category, there is a 25% YOY increase in personal expenditure in March 2021 – the last time we see a 20% increase was in 1974 (maybe due to the Oil Crisis?);
  • Similar pattern can be seen in other categories – a significant (and most of the time, historically high) YoY increase is seen in March 2021, then things flatten out but YoY increase still much higher than normal years.

Follow this link to find more weekly vizzes :)