#SWDchallenge

A star is born

A star is born

A star is born | UK Christmas No.1’s from 1952-2017

Interactive viz

Source – Official Charts.com

A viz for #SWDChallenge December 2018 – Lets visualise the holidays!

The concept was to try and present a christmassy styled viz to fit with the brief ‘lets visualise the holidays’, so what better than Christmas No.1’s.

12/12

Pretty chuffed with myself for completing all 12 Story Telling with Data challenges in 2018.  Here they all are in a nutshell.

 

A quick ‘how I constructed the viz’

There are two key components to this viz.

  1. The city silhouette
  2. The Stars

First the city silhouette, nothing too special here, its a simple bar chart with the colour opacity set to 0% and the the text formatted to bottom centre, and float at the bottom of your dashboard

2018-12-09_2039

Next the stars.

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 creating the necessary 7 calculations :

calcs

Then throw them on the workbook:

1950

Download my workbook if you would like to see how (and or copy and paste them into your own worksheet).

From there it is, as always, just a bit of faffing……..

  • Each of the floating radial charts (stars) are filtered to a decade bin of the year data.
  • Then faffed about with to make them look a individual, by tweaking the colour, opacity %.
  • A few dashboard actions to make the bands highlight the song city scape and multi highlight when you select a group/artist that has had multiple No.1s

Hope this has been useful. it was a fun one to make. Go on have a play with it in tableau public here

Merry Christmas to one and all.

Adam

 

 

Advertisements
Standard
#SWDchallenge

#SWDChallenge Stickies | STRAVA data

swdchallenge Nov18

A viz for Cole’s November #SWDChallenge.

This month Cole challenged the community to use the power of a sticky note…….

I invite you to use sticky notes in whatever way will be useful for you. Maybe you’ll use them like I do to storyboard or align your ideas along the narrative arc. Perhaps you’ll use giant sticky notes to mock up slides in a presentation. Maybe you’ll plan and organize sections of a report or graphs in a dashboard. I’ll bet some of you will use sticky notes in ways that I haven’t even imagined. I can’t wait to see it all!

Me, well I chose to go digital with my stickies to plan a viz flow, and a potential dashboard to present my STRAVA run stats.

I already viz my STRAVA data in this Tableau Public published dashboard:

STRAVA Run stats_oct2018

Interactive viz

However I thought it would be interesting to pick out a few of the existing elements contained in the viz for a potential makeover. The first, some BANS, the second, an overview of distance by month, but this time introducing a line chart variation added recently to the functionality of Tableau – step lines! (something i’ll tweak in the above viz when I get a moment). And thirdly, I have dropped in a chart I saw @chrisluv tweet recently:

chrisluv_tweet

Chris had a bash at presenting each run he has completed in 2018, by week and day, and including an indication of the distance and the speed of each run – Some mean feat in one visual. I have always opted to box them out in different tables (like that above). So I recreated this viz and included it into a ‘potential’ tweak to the existing STRAVA RUN STATS.

My STRAVA STICKIES challenge is more like an IDEAS BOARD of potential tweaks, but identifies the key and core building blocks to any viz:

  • Headline takeway
  • Summary Overview
  • A delve into some detail

Thanks for reading

Adam

 

 

Standard

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

 

#SWDchallenge

DC COMICS TOP TRUMPS

Image
#VisualisingHE

A looksie at UCAS placed applicants

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

Standard
#Makeovermonday

YEMEN – the forgotten war| MOM Wk34

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

Standard
#datathatinterestsme

BEER & its unsung hero

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

Standard
#datathatinterestsme

Respect the water | Give yourself a floating chance

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

 

Standard