Tag: Mac Index

For #MakeoverMonday week 31, this week’s makeover viz was about The Big Mac Index by The Economist. This index was based on “Big Mac Hamburger” price across various countries where it is sold to analyse the purchasing power parity.

Here is the original viz :

Data is available on data.world and source of data was The Economist

Whats good?

• Clear Legends showing price of Jul’17 and Jan’18 along with Price of Big Mac price in US Dollar
• Zero reference line to see the difference and sorting the countries with latest prices
• Sub-titles explaining the overvalued and undervalued with signs along with caveats

Here is what I did:

• Rather then using price of last 2 years, I selected price of last 10 years starting Jul’2009 and used only July prices for all the years
• Designed an jitter plot to show the plot the country wise price variation in comparison to US price
• Interactive tooltip to show Big Mac price in various countries with there overvalued and undervalued against US dollar and highlight option to select a country for trend

Here is the Image of the visualisation I created (Click on image to get interactive version):

Click here for Tableau file

Thanks Eva Murray & Andy Kriebel for this workout.