Tag Archives: data visualisation

The British are coming! At least to #Data16

Otherwise known as the Viz which shows who is going out to the Tableau Conference 2016 #data16 on the British Airways flight BA191 on Saturday 5th November.

A few weeks ago I tweeted out to see who was on my flight –

ba191-tweet

I got quite a few replies and it looks like there are about 25 of us going and it got me thinking to how many of the community on the flight will know of each other but not actually met each other.  So what better place than a 10hr flight to meet someone new and discuss all things Tableau?

So I set up a Google Form, which populates a Google Sheet to capture the details of who is flying (You can complete the form which is embedded below if you are on our flight)

 

I then downloaded a seat map of the aircraft which flies the route – a BA 787-900 series with four classes, First, Club, World Traveller Plus and World Traveller.

boeing-787-9_seatmap

Finally I mapped the coordinates, something I first did at easyJet, blended with the Google data and I now have an interactive seat plan where you can see who you will be sitting next to or where that member of the community is that you always wanted to talk to but were too afraid to ask!

The great thing with the Tableau Public Google Sheet connector is that it refreshes daily, so it will update automatically, which is great for the dashboard which I also built using device designer for the first time as feel that the Mobile experience is the best for viewing this.

The final touch is that you can go back in and change your form, should you decide to move seats.

The dashboard can be viewed by clicking the image below

img_4463

Vizable on the iPhone

For anyone that know’s me, they know that I am an advocate of Vizable, the app which Tableau and Dave Story launched in Vegas at the #data15 conference last year.

It was the fruit of their work on project elastic and really excited me.

I use Vizable almost every day.  Wherever I see a pivot table or an ‘Excel Database’, I introduce and usually convert the user to Vizable.

One thing I have been waiting for and tried numerous hacks to work has been to get it working on the iPhone, the product I have on my person and in my pocket ALL of the time.

I use an iPhone 6S Plus, which has a large screen real estate perfect for Vizable.

So when I had a call with Trina Chaisson, the Vizable product manager and co-founder of Infoactive and she said what was about to land in the App store I got very excited.

IMG_3833

In fact when it landed in the App store – I managed to tweet about it before even Tableau or Vizable were able to make the announcement – sorry guys!!

app store

Here is how in 90 seconds I  go from my home screen to having it installed and analysing data (Best watched in HD and fullscreen mode)

As you can see it is very simple to download and intuitive to use.

To get started, I thought I would explore one of the recommended data sets and download my Amazon shopping history.

Now if you use the US Amazon store, this is really easy to use by following these steps –

amazon recipe.png

However if like me, you are in the UK, it is not so simple as the order reports are not able to be downloaded.

Fortunately, if you use Chrome, there is a workaround which I found on the forum.

Amazon order history.png

Here is the app

chrome app

And what the data looks like

Amazon excel sheet.png

Now I can import into Vizable and start to explore my data.

First I explored my orders by year – I am definitely using Amazon more each year (2016 is only part year)IMG_3890

I have been an Amazon prime member for a few years, does it pay for itself?

IMG_3893

What are the products I repeat purchase the most?  Interesting that the Baby Wipe I have on a monthly delivery seem to change provider and description on a regular basis.  I would have to clean this up better to get the full picture.

IMG_3891

Are all of the items for me or do I send a lot of gifts?  It seams that I send a lot to @infolabUK ‘s own @_tombrown_  – or this may be skewed by a gift to say thank you 😀

IMG_3889

Finally I wanted to understand if my average postage costs had really come down through the use of Prime or was I still ordering products which were not eligable for the Prime service?  It certainly appears that I paid more high price delivery charges in 2015 with a maximum of £7.99 and have seen a 4.4% increase in the average shipping costs from when I started in 2010

IMG_3894

So very quickly I have been able to see, touch and understand my data and hopefully you will all try this as well.

Introduction to Data visualisation

Internally at work, I run a monthly workshop introducing people to data visualisation and explaining why it is important and how we use Tableau as our tool of choice in this area.

The workshop was initially aimed at the analyst community, but as the months have gone on and the popularity of Tableau increases, I am seeing a wide variety of people attending, from our Board, to managers to people who just use Excel but want to do things better.

The workshop lasts about 90 minutes and is mostly in Prezi, before I move into showing some Tableau demonstrations and our Facebook at work pages, where people can download our colour palettes and understand some of the choices we have made.

So far, about 130 people at work have seen this and along with a few members of my team, I am writing a follow up session.

Obviously, I have not created all of this content from scratch.  A few years ago, I was lucky enough to attend Stephen Few’s three day workshop in London, based around his books at the time.  It was at this event where I first met Tableau community legends Peter Gilks and Carl Allchin.

I took my leanings from that, and converted his three books and several hundred pages into a 30 page PDF that people could use as a reference.

Following this, I also attended Andy Kirk’s workshop and have several data visualisation books in our internal library including Alberto Cairo’s book the functional art, all of which I have tried to take examples from to improve our internal guidelines and best practices.

Data viz books

At the Tableau conference in Vegas #data15, I mentioned this workshop and touched on a small part of it.  A few people in the Twitter community sent me messages and asked if I would share it.  As it was internally branded, I didn’t want to do this on a wide scale level, so thought that I would create a ‘public’ version and publish it here.

The Prezi should allow you to follow through the journey, which is based around transforming information into insight.  It obviously works better when I am present to talk through it and the examples, but hopefully it gives enough of an introduction and I am happy to talk about it in more detail or come and present it.

Click on the image below to go into the Prezi.

data viz overview

I will follow this post up with some details on setting your colour palettes as well as how you can put standards in place for your Tableau dashboards.