This time it is with data+visual London, 22 February 2017
Tableau – Part Three
It’s a shame I missed parts one and two, but as part on my MA in Online Journalism assignment I attended a data+visual London Meetup.
The meeting was held at Tableau’s impressive offices in Southwark. Well, they impressed me anyway.
Together they were going to demonstrate how users can combine the power of Excel and Tableau.
We would be shown how to prepare Excel files for analysis, and how to leverage Excel mastery in Tableau. There was also a short ‘give it a go’ session, with prizes awarded to the best data displays.
The company says that its mission is to “help people see and understand their data”. It is doing this by writing business intelligence (BI) software to transform the way people use data to solve problems.
It can create visually-appealing reports, charts, graphs and dashboards using a data source. The reports are interactive and can easily be shared. Using ‘drag and drop’ it aims to be user friendly so there is no need for a technical background.
Excel has been the default software for data visualisation. After all, it seems that MS Office is everywhere. It is also easy to learn the basics of using it for spreadsheets.
It also has a chart wizard to assist users in creating a visual representation of the spreadsheet. But it can be slow and inflexible. Making changes can be a real pain.
This presentation was to show how Tableau allows users to connect to Excel data to ‘easily’ create charts and graphs with total flexibility. Tableau uses drag and drop instead of a wizard.
As I mentioned, I couldn’t remember how to play with the data. However, three people did manage to put something together.
The Tableau community does like to share their work. This is regularly done during Makeover Monday. The potato data was the Makeover challenge for 20 February.
User skills can be found by following #makeovermonday on Twitter. Below are some examples produced by those who know what they are doing.
In an earlier blog, I created a map of London where a click on a borough showed the median income for 2013-14. It took a while, even when following someone else’s coding instructions.
I wanted to try this with Tableau Public. However, I have found that the maps available with the free version of Tableau are limited.
My first try just ended up sticking the City of London over the whole of Greater London.
Good old Google
By Googling I found a blog by Russian Sphinx, who had created a map of the London Boroughs. I downloaded it and tried adding my Excel file of tax payer income to it.
Of course, it didn’t work. I had to build a relationship between the map and the Excel file. Both contained GIS codes, so when these were matched it worked! It took around 20 minutes to do this. The coding I used before took a couple of days to work through, including finding out how to host the map on line.
So Tableau Public definitely wins in this case.
Will I continue to use Tableau Public?
Short answer, yes. I still don’t really know how to use it, but there are plenty of YouTube videos to help me to find my way around it.