Friday, 27 December 2013

Another disappointing Lions season draws to an end...

As a basketball fan growing up in England, my love of the NBA has been late to bloom. Well, when the time finally came to fall for the game, I first started to watch 'Football' through college games when Suh was dominating every game he played. Yes, I now know his disciplinary record is far from spotless!

Hence, when it came to him being drafted by Detroit, this fitted with me picking a team to follow. Oh why!! I hear you cry... Well for once the crowd is right. Here is my investigation in to whether individual player dominance on the offensive side of the ball brings success (as the other key Lions players are sitting on the offensive side after all). I have gone for a more journalistic style (the first foray of potentially many) to see if I can refine this art form. Thoughts in the comments below please and fingers crossed for next year!

Monday, 16 December 2013

Was it always this bad? (Speed Visualisation)

It's dark outside and I have spent 10 hours with data at work and come home to find Tottenham have sacked yet another manager. So what is my coping mechanism, data visualisation of course. I wanted to explore whether I have lived through terrible Tottenham manager or has it always been this bad for Tottenham fans (yes the Double still offers a clue of the 'Glory Days' gone past). So i set myself a time limit of 30 minutes to create a visualisation to allow fellow fans to see whether they have it better or worse. Have you lived through a higher proportion of better managers than I have? Enter your date of birth to find out and use the filter to find out whether the Win % of managers you have lived through is better than mine (39%).

Monday, 2 December 2013

Quality Father and Son (and Tableau) time

This weekend I took a trip home and at the same time, used some time with Senior Ninja (my Dad) to show him some of the work I do in Tableau. Four hours later, he was up and running and creating a visualisations on the fly.

So what did Tableau have to offer Senior Ninja?

Well first of all, Senior Ninja is a very active man in the community. He has many roles (sound engineer, theatre technician, electrical engineer... the list goes on) but one creates data... a lot of data. As part of his web design work, he has a MySQL database capturing the use of community Digital Cinemas. He has never queried this database to see what was going on because he never had the chance.

To make the Tableau example real, I took a csv extract and loaded it straight in to Tableau. In seconds we had 10,000 rows of data telling us stories: most popular films, when the equipment is used, what different locations prefer... the list goes on.

Well, just letting Senior Ninja have access to the data is useful but at the end of the day, he doesn't control the input of the data; the users do. One issue with the data is the terrible quality of the data. Easy to fix in Tableau, but it takes time, so why not incentise the users to put in top quality data?

The best way I have found to do this is to allow users to see the data they input. This is where Tableau Public comes in amazingly useful as Senior Ninja can host the visualisations alongside the data input on his website.

Making the data better, will allow for better analysis, which will allow for better use of equipment, that will support more members of the community.

Win, win, win, win, all thanks to a bit of software and some quality father and son time.