#Makeovermonday

No.10 Downing street Electricity usage | #Makeovermonday – Wk4 -2019

No.10 KILOWATT HOUR METERv2

No.10 Downing Street | KILOWATT – HOUR METER

Interactive viz

Source – Carbonculture


Description

Aims were simple with this weeks Makeovermonday. I just wanted to have a bit of fun and wished to make the viz look like an electricity meter. so here is my interpretation of vizzing one of them – imples……

The original version published to the twittersphere got an iteration fairly rapidly after a bit of feedback from Simon Beaumont:

sbaumonttweet

Thanks Simon, the month by month usage looks much more integrated in the v2 iteration (right)

no.10 kilowatt hour meter

No.10 KILOWATT HOUR METERv2

Viz Type

A DOT BAN (well this is the term i’m coining for them).

A quick ‘how I constructed the viz’

The how to for this viz would certainly relate to the DOT BAN and how you get control over all those dots!. I’m going to cover this in a specific post. Currently getting them to work is a bit of a faff! and its all in the data prep.

Feel free to download the workbook and have a looksie if you can’t wait for the blog post!

Interactive viz

Adam

Advertisements
Standard
#Makeovermonday

Freedom of the Press | #Makeovermonday – Wk2 -2019

Keeping an EYE on the free press.png

KEEPING AN EYE on freedom of the press

Interactive viz

Source – Freedom house.org


Description

Wk2 of Makeovermonday 2019 focused on world freedom of the press. For this viz my self imposed brief was to create something a little ‘eye’ catching, and not necessarily viz best practice. So I fancied creating something with the data that did the following:

  1. Headline BAN.
  2. Something eye catchy that looked at change over time (i.e in this case change between 1993 and 2016).
  3. A trend over time per country if the user wished to interact with the visualisation, with some nice clear roll over tool tips.

Viz Type

A Circle, A BAN and a Line chart

A quick ‘how I constructed the viz’

The main component of this viz is the ‘eye’ and this is just a circle mark type,

A difference calculation comparing 1993 and 2016 on colour to depict positive change (orange) and negative change (grey) and the country on size. The specific year calculation on labels to make the tool tips. Wola!

how to circle

Very simple this one, but I like the effect you get in the graduation of colour along what looks a bit like an iris.

Adam

Standard
#datathatinterestsme

Michael Jackson | UK peak charting singles positions

MIchael Jackson_The SIngles.png

Michael Jackson | UK Peak charting singles positions

Interactive viz

Source – Offical charts.ocm


Description

Given i’d done data prep for the Michael Jacksons Album viz, and the format of the data was the same for the singles data, my interest moved to see what singles hit it big in the UK….

And here they are, All 5 decades of them!

This is a a pretty static info-graphic viz with all the data showing in the visualisation. The detail and interactivity is in the hover of the radial bars, displaying finer detail about each song. The viz is read in a clockwise motion starting (as indicated) at 3 o clock. No.1’s are highlighted in red both in the visualisation (radial) and the text on the right hand side.

The idea for the visualisation is intended to look like the backside of an cd case, hope that idea comes off in this viz. I took inspiration for the look and feel of this viz from this image found on the web (vinyl revamp) doing Michael Jackson vinyl Art:

MJ art covers

Viz type

Another radial bar chart!

A quick ‘how I constructed the viz’

The Radial chart

As in previous posts the radial is done as follows:

  1. Duplicate your data and add a new column called ‘path Order’, set the original to ‘0’ and the second underneath it to ‘1’.
  2. Bang out 7 calcs, or copy and paste them! I’ve done a few of these charts now and tend to just go back to my last workbook and copy and paste the calcs in and tweak the ‘radial field’ and bish bash bosh! RADIAL……

I think the original video I watched was this really useful one by super data science

Basically this vid walks you through doubling your dataset in Tableau’s data source window, and then step by step takes you through how to create the necessary 7 calcs:

calcs

The tweak I did in this viz was to do a little calculation that inverted those singles that peaked at no.1 and gave it a negative value (-4), this enabled me to bring the red bars into the inner of the radial bar chart, thus making them pop out, and coloured them in red to highlight.

peakpos radial

Thanks for reading, hope it has been a useful overview to the aims of the viz and unpicking of the method.

Adam

Standard
#datathatinterestsme

Michael Jackson | UK peak charting album positions

Michael Jackson_charting albums.png

Michael Jackson | UK Peak charting album positions

Interactive viz

Source – Offical charts.ocm


Description

Well i’d been sitting on this viz for a while, and was reminded it was sitting in the ‘part done viz’ folder awaiting a final push to make it publishable.

I was spurred on to publish this viz in early Jan 2019, after seeing Neil Richards – Elvis and Beatles viz which was a dead ringer for the Albums viz id somewhat forgotten i’d created! I was both surprised and flattered to receive a few nice comments from some lovely peeps (namely Kev Flerlage and Neil), likening it to something Neil may have published. A privilege of course to come close to executing a viz to Neil’s standard, which always have the wow factor and curb appeal.

album tweet

My intentions for this viz were to take a look at the albums of the ‘king of pop’, intrigued to understand which of his albums charted best in the UK and when. So I decided to split the charting albums into decades and present them in a fun way – something like a vinyl record. The smaller the ‘ring’ (or groove), the higher the peak charting position. Data taken from official charts.com also includes the label in which the album was published and felt it would be an interesting dimension to interact with in the visualisation.

Viz type

Circles and shapes

A quick ‘how I constructed the viz’

So this viz (in the end) is just one worksheet using a duel axis (one circle and one shape type). I originally had two worksheets in play and floated them on top of each other in the final dashboard, but good friend, colleague and critique Lorna Eden told me to stop being lazy and do it more elegantly! So…. its in one worksheet now – thanks for the steer Eden.

To get the duel axis we have a couple of dummy pills ‘sum(0)’, and then it was a case of dropping all the fields required to build up the layers.

The ‘Shape’ type (circle) handles the ‘rings’- and chart position data, and the ‘circle’ type  handles the vinyl disk.

The Key to getting the vinyl disk look is to create a couple of measures avg(15) and avg(20) to fix the circle sizes, the rest of the pills are pretty much labels etc.

vinyl disk

with the exception of one sneeky ‘mofo’…..

‘dummy colour’……….

One complication of wanting that ‘elegant solution’ Eden so determinedly insisted on, meant creating a additional data set to help handle the records publishing label and related highlighting!

Download the dashboard off Tableau public here for a delve into that.

Thanks for reading

Adam

Standard
#datathatinterestsme, #Sportsvizsunday

ITU WORLD TRIATHLON SERIES | OUTSTANDING PERFORMANCES

itu mens tri series

ITU World Series | Outstanding Performances

Interactive viz

Source – WTS.Triathlonseries/rankings



Description

I’ve been looking to create something #Sportsvizsunday related for a while, and I was also looking for a data set that would require some data prep therefore allowing me to familiarize myself with Alteryx (a tool which I now have access to and need to get mastering pretty sharpish).

I love triathlon, and whilst I have diverted my activities to other sports (Swim runs, and straight run events) of late I love a good watch of the ITU series. So this web data set paged by year seem prime for sorting out in Alteryx and then visualising.

My aims for the viz were to understand how the 2018 standings panned out, focusing on some exceptional performances (Orange highlighted athletes), provide a way to visualise how these athletes have performed by final scores over time (bottom left) and also their final rankings. This viz has highlight and filter actions in place so that you can explore an athlete and gain score and ranking positions interactively.

Viz types

  • The Final standings strip – Shapes (custom images)
  • Overtime highlighter – More shapes (squares)
  • Rankings overtime – Bumpchart

A quick ‘how I constructed the viz’

Whilst this viz pretty much pulls together off the peg Tableau chart functionality, brought together by some dashboard actions, I wanted to unpick the ‘Final standings strip’ worksheet to show you how I achieved the multiple images and colours used to accentuate the exceptional performances in the 2018 final points standings:

 

shapes

A couple of key points

  • It uses a synchronized duel axis to present the athlete shape and the gannt bar lines which are used to help show the individuals and lets you pick them out on rollover in the interactive dashboard better.
  • On the gannt lines I was then able to provide context with a min and max score label, whilst on the shapes axis highlight the key top performing scores.
  • To allow the ‘outliers’ to be picked out both in colour and shape, I created a simple group off an early box plot set to highlight 1 -1 standard deviation of scores for 2018, and used that to identify the two groups in a calculation. Adding that group dimension to shape will allow you to choose your shape files and also add to the colour pill.

have a play with it and let me know what you think

Interactive viz

Thanks for reading, hope you found the viz and post useful and interesting.

Adam

Standard
#datathatinterestsme

2019

2019

What do you do when you have 9 blogs in draft…..?


Write a 10th and publish it to tell folks some blogs are coming…….

For 2019 I’m aiming to write a a quick blog for each of my vizzes I publish on Tableau Public. As you will see i’m not doing all that well on this idea just yet. In fact to date I haven’t published a single thing in 2019, instead quite happily vizzin away on datasets that have been tempting my taste buds. And that is just fine with me, but I thought I best start somewhere.

The format:

  • Viz, interactive link, source

  • Description, detailing why I approached the viz this way and my intentions

  • Viz type

  • a quick ‘How I did some of the interesting/key bits’

Why? well someone might find the ‘how I did’ tips useful. and I quite like having a place where I can present each viz with the ability to express why I have presented the data this way, rather than any other way!

Coming soon

  • Michael Jackson’s Albums – Circles
  • Michael Jackson’s Singles – Radials
  • ITU triathlon series – Gantt bars
  • a few other things
  • and my new fun thing – DOT BANS, getting an airing in wk4 makeovermonday and Andy Murray’s current key stats

In lieu of any of those, all the interactive vizzes are on Tableau public

Is it too late to wish every one happy new year? 🙂

Adam

Standard
#Makeovermonday

What % of people earned below the federal min wage? | #Makeovermonday – Wk3 -2019

makeovermonday2019wk3_percentofpeopleearningbelowusminimumwage

What percent of people earned below the federal minimum wage?

Interactive viz

Source – Bureau of labor stats



Description

A Makeovermonday challenge. Jan Wk3 2019

I didn’t feel this data set lent it self to presenting ‘all’ the data in a single visualisation. Nor did trying to present a ‘headliner viz’ – a viz type I am most fond of.. Instead the takeaway I wished to get from this data set was to present a single year at a time to get a picture of which states display strong or weak proportions of people earning minimum wage. As well as this main takeaway I wished to have a second phase takeaway (pudding if you will!) for this I wanted the interaction to show how each state had ‘performed’ of the time frame of the data set – done in this viz by a ‘roll over’ time series line chart by state showing trend over the period 2002-2017.

Whilst the static image for 2017 (shown above) doesn’t really meet a particularly well executed graphic design standard, I consciously fixed the radial bar line size over the data sets time frame, so that when you interact with the viz years you can appreciate the changes over time that have been achieved by each state.

Viz type

Radial bar chart, a line chart and a cheeky no background map thrown in for fun (basically because I am pretty poor at identifying US states by shape and it was informative for me to see these.

A quick ‘how I constructed the viz’

The radial:

These aren’t so ‘out of the box’!

  1. Duplicate your data and add a new column called ‘path Order’, set the original to ‘0’ and the second underneath it to ‘1’.
  2. Bang out 7 calcs, or copy and paste them! I’ve done a few of these charts now and tend to just go back to my last workbook and copy and paste the calcs in and tweak the ‘radial field’ and bish bash bosh! RADIAL……

I think the original video I watched was this really useful one by super data science

Basically this vid walks you through doubling your dataset in Tableau’s data source window, and then step by step takes you through how to create the necessary 7 calcs:

calcs

Then throw them on the workbook like so (being mindful of your compute by on the radial X Y’s……)

radial

Other elements:

  • The map, nothing special here – just removed the background to de-clutter.
  • The line chart – and ‘state’ and ‘year label’, formatting achieved by creating a worksheet and floating it under the line chart, as follows:

text

To get a better idea of any elements, be sure to download the dashboard and reverse engineer if you wish.

Interactive viz

Thanks for reading

Adam

Standard