4

Chinese New Year and Thanksgiving – how do they compare?

 3 years ago
source link: https://datavis.blog/2019/02/04/mm2019w06/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

Chinese New Year and Thanksgiving – how do they compare?

mom2019w06.png?w=400

This week’s #MakeoverMonday provided a small data set that summarised some of the events around these two large events – Chinese New Year and Thanksgiving – that take place in China and the USA respectively.

The Data

01-data.png

The original visualisation, from Statistica, showed the numbers in their actual, non-normalised form, which gives a sense of the scale of the total spending or total activity (number of trips taken, for example). However, I found this a bit hard to digest from a personal perspective.

From Aggregate Numbers to Per Person Metrics

I was curious to know what these numbers meant for the individuals in each country:

  • How much did each person spend (in retail and restaurants)?
  • How many trips to each person take?
  • What percentage of the population watched the main TV events for each occasion?

Fortunately the total populations for the USA and China were also in the data set, so it was a fairly simple case of dividing the metrics by the respective country populations to get per capita metrics.

Mobile Design

I don’t often create mobile designs so this was a good opportunity, given the relatively small data set and the simple comparisons I wanted to make.

I decided to keep the original aggregate data for context of the scale of the two events and add the per-person metrics to give an appreciation for how each ‘category’ affected individuals in each country. Click the image to open in Tableau Public:

mom2019w06.png

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK