DC COMICS TOP TRUMPS

Image

TOP TRUMPS #SWDChallenge Oct18

Interactive viz:
DC COMICS TOP TRUMPS

Description:

A viz for #SWDChallenge.  Octobers challenge was all about the scatterplot.

Having spent a few days tediously hunting for a dataset with a couple of continuous variables, I had a light bulb moment! I remembered a totally unnecessary data crunching exercise I bashed out a few months ago, I manually entered all the details from deck of TOP TRUMPS into excel to work out which Superhero/villain was in fact the TOP TRUMP! Why you may ask? Well my son tends to cheat when we play TOP TRUMPS, so I therefore felt it only fair for me to get the upper hand in the only way I know how – a top trump analysis!

For this viz I manipulated the dataset using Tableau Prep to get the spreadsheet into a vizzable format which enabled me to create a matrix of categories and present their correlations.

Viz type:

Scatter plot and a data table.

 How:

Super hero magic! and a beautifully written blog post by Emily Dowling on how to create linear regression lines in tableau by the information labs data school.

Why did I create the line rather than just use a trend line? Well I wanted to be able to control the colour by significance, seemed a lot of effort but I also learned a ton too.

And that is the point and my reason for doing Cole’s #SWDChallenge.

Colour encoding how to:

Having exported the descriptive data from the standard linear trend (below)

trend_model.pngI sorted the information in excel to highlight significant correlations (95% confidence interval), and created an if statement (below) to use as a colour encoding: significant P-value = Y/pink else N. With a little cheeky added ‘if’ to create an ‘E’ to blank out those categories in the matrix that needed to be hidden. eg where strength = strength etc

how_to.png

Source:

A deck of TOP TRUMPS DC Comic cards put into excel, and then a bit of z-scoring to create a league table’esk overall score and ranking.

Thank for reading

Adam

 

Advertisements

A looksie at UCAS placed applicants

Standard

A looksie @ UCAS placed Applicants.png

Interactive viz:
A looksie at UCAS placed applicants

Description:

This viz is the feature viz for #VisualisingHE ‘s September blog post: ‘A looksie at UCAS placed applicants 2018‘ – 31/08/18. The idea was to create something a little eye catching to support the blog, which took a dive into three key takeaways of the data UCAS published.

  • Internationalisation
  • Subject change
  • Nursing

This viz picks up the internationalisation thread and highlights the overall volume of the UK sector Undergraduate Higher Education population, and the international (EU no UK and Non EU) populations for 2017 and 2018 entry.

Viz type:

Donut and a cheeky line

How:

First off thanks to Andy Kriebel who is the go to source for all ‘how to’s’ in terms of cracking that virgin chart type in Tableau. Whilst I no longer need to follow his how to donut tutorial to create the chart type having knocked a few now, his step by step guide is a must if you have never created one before.

The only ‘I wonder how you did that in Tableau‘ bit to this viz is probably the nose band to the glasses rim. And for that all I have done is called on the ever trusty power point to create the arc image, matching the colour by copying the RGB colours from my Tableau pallet.

glasses nose

Having created the arc shape in power point, right click the shape and ‘save as picture’, float the image in your Tableau dashboard and set the image ‘to back’ in terms of placement in the viz, as to not get in the way of interactivity of the donut chart. Wolla!

Couple of extras:

I spent a little extra time with my annotations for this viz to make it as clear as possible which labels related to which sections of the donut. This is done by giving it only a single edge, tweaking the shading and colour coding the annotation box.

annotation.png

The second added fiddle to this viz is the placing of the takeaway text. this is simply achieved in Tableau by a bit of trail and error carriage returns in a text box, floated on the dashboard:

text.png

Source of dataviz: 

UCAS Placed Applicants – 31 Aug 2018

thanks for reading,

hope this has been useful.

Adam

YEMEN – the forgotten war| MOM Wk34

Standard

MOMWk34_YEMEN

Interactive viz:
MOM Wk34 | Conflict in YEMEN

Description:

Breaking the #makeovermonday hiatus, this weeks dataset seemed a real must, both an important dataset and topic, but also a chance to create something using maps, of which i never normally use.

Viz type:

A Map and some simple marks on a time line.

How:

first off thanks to András Szesztai first of all for knocking out a cracking viz which gave me the inspiration to create something for this weeks Makeovermonday, and secondly for helping me get all my datapoints to appear on my viz following a fundamental errors with long and lat generated measures rather than the required correct long and lats that should have been used with the dataset and the need for location of detail etc.

For my viz I wanted to go long and thin and use a press article esq style for the overall composition. setting the size up is always a bit of a pain til you have everything on the dashboard and in place.

Some key challenges

  • A mixture of  floating and tiled objects
  • matching of colours with the background maps and backgrounds.
  • Actions to make things work together on the dashboard

Source of dataviz: 

ACLED

thanks for reading,

hope this has been useful.

Adam

BEER & its unsung hero

Standard

BEER & its unsung hero #IRONVIZ WATER 2018

Interactive viz:
BEER & its unsung hero

Original tweet: BEER & its unsung hero

Description:

Make a splash in Iron viz water

  • Build a viz in Tableau that somehow touches on the theme of water.
  • Upload it to your Tableau Public profile.
  • Submit the link to the viz via the submission form, before 11:59:59 p.m. Pacific Time on August 28th, 2018:

I decided to take a slightly different twist to the theme of ‘Water’ and explored the nectar that is the beautiful BEER, what its made of, the process that makes it & what it looks like.

In my long form viz I have split the data story into four parts:

  • What are the key ingredients
  • The unsung hero – WATER
  • A basic overview of the brewing process
  • Ending with an interactive colour swatch using the SRM method of categorising beverage colour in a 40 point scale.

Source of dataviz: 

Ingredients: https://www.dummies.com/food-drink/drinks/beer/the-main-ingredients-of-beer/

Water: https://beercanada.com/beer-101/beers-ingredients

Process: http://blog.beeriety.com/2009/07/06/how-beer-is-made/

SRM: swatch colour chart – http://www.franklinbrew.org

Images: https://www.flaticon.com

Inspiration

http://beercraftbook.com/book/

 

hope this has been useful.

Adam

Respect the water | Give yourself a floating chance

Standard

Give yourself a chance_RNLI

Interactive viz:

Haven’t publish this one as a tableau public viz (given it is not interactive in any way), further more the font (chiller) doesn’t render in public either!!

Description:

A simple infographic visualisation highlighting the clear and strong advice of the RNLI.

“Give yourself a floating chance” in 6 east steps

Viz type:

A simple bar chart

Source of dataviz: 

Data to support the stats are derived from the national water safety dataset “Annual fatal incident report”: WAID

RNLI campaign

Adam

 

safleoedd terfynol

Standard

TOP10GC ranking2018

Interactive viz:
Final rankings (safleoedd terfynol)

Description:

A visualisation showing the final TOP10 rankings for the Tour de France 2018, highlighting the final time splits. This years tour put the riders in the seat for some 83 hours, 17 mins and 13 seconds (or three and a half days!) over 23 days (21 stages with just two rest days).

Viz type:

A simple chart made using a shape and some text, nothing special….

How:

As with most of my vizzes most work goes into bringing out the text I wish to emphasise  by spending a bit of time formatting of each of the text dimensions – slow and a bit annoying but worth it.

tour_final_rankings.png

TOP Spot info square:

Welshes own Geraint Thomas wins this years tour by nearly 2 mins.

GC_winner

Source of dataviz: 

Cyclingnews.com

thanks for reading,

hope this has been useful.

Adam

Proportion of 1sts

Standard

Proportion of 1sts by subject group.png

Interactive viz:
Proportion of 1sts

Description:

A visualisation showing the proportion of 1st class honours degree issued by UK providers in 2016/17, redesigned for the #SWDChallenge July18 – a makeover month

Viz type:

A simple Bar chart nothing special, but (in my opinion) a slightly improved version from the pink vertical bar visualisation.

The orginal

Source of dataviz: 

UK REFORM

thanks for reading,

hope this has been useful.

Adam