Makeover Monday, 2017 #46-47

Week 46:

Original: The world’s top cities for sustainable transport.

Makeover:

DASH-sustainable-cities



Tableau public: link

Notes: nothing particularly special here! The breakdown per continent allow two of the key stories to emerge. Hong Kong is top but there is a high concentration of European cities at the top of the ranking.

 

Week 47:

Original: Snapchat is tops with American teens.

Makeover:

DASH-teens-fave-apps


Tableau public: link

Notes: I’m pleased with the simplicity of this chart. We can clearly see that Snapchat has grown to be the main favourite. The arrow is an aligned dual axis line and shape chart to give the effect of an arrow. This allows me to highlight the combined percentage for Snapchat and Instagram before pulling in some extra information in the final paragraph about the way young people perceive those two apps.

Makeover Monday, 2017 #45

Not so much a makeover for me this week. The original chart was a WHO map of life expectancy data. I’ve just looked at a simple comparison of a country of the viewers choice with the two countries with the highest and lowest life expectancy at birth for a given year:

DASH



.

Want to try different countries or years? Click through to the Tableau public version.

Some of my favourites from the community this week:

Makeover Monday, 2017 #44

For week 44 of #MakeoverMonday Eva selected a Daily Telegraph article mapping the countries with the most public holidays. Nice map – although as ever with filled maps there are data points that get a little lost (the smaller countries). The lists work well to make up for this, although they’re pretty basic and unexciting.

The dataset was quite challenging this week - broader than the original article, lots of variation and some data quality issues. I’ve decided to focus on a specific public holiday, labour day, because it was easier to hone that subset of the data for analysis and visualising. Labour day is also reasonably prevalent and it’s roots are a great reminder to us all about striking a suitable work-life balance!

First up I wanted to map those countries celebrating Labour Day to get a feel for how much of the world does celebrate the day. An image and large KPI-style number lend a bit of focus here. The rest of my makeover focusses on drilling into the variation in when the world celebrates the day – not everyone celebrates it at the same time or for the same duration. For example I was really surprised to see that China counts a weekend as part of it’s celebrations.

DASH



.

The viz is also available on Tableau Public where you get a little more hover over – e.g. to see what dates each country celebrates and for how long.