Wattie's Wordpress

Random reviews, remarks, reports and rants!

We can work it out!

leave a comment »

The biggest problem I had with my Production Labs project was that the client wanted an animated timeline map showing the Manchester cuts in sequence. No matter how much I searched, I could not find a way to do it within my current abilities.

I even spoke the the Flash developers at the Financial Times, but they said that I would need a lot of expertise to achieve what I wanted. Then over a beer in the afternoon a fellow Online Journalist, Desi Velikova, suggested I look at Tableau to see if that would work.

Firstly, I made sure I had all the longitude and latitude data in the spreadsheet, dates formatted correctly etc and then loaded it into Tableau. At first it just showed a map with one large circle in the middle, but then I found out the default setting was to find the average of the numbers, so correcting that immediately changed the view to one of Manchester with all the locations of the cuts correctly displayed.

Next, through trial and error (as the help facility was anything but helpful), I managed to work out how to add a time element to the map and also change the size of the markers depending on the size of the cut (dropped from the final version) and how to change colour depending on which department the cut was from.

You can see a screenshot of the resulting map below, or to see it in action, have a look on Kijamedia.

Advertisements

Written by Andy Watt

March 24, 2011 at 7:54 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: