What are the most liveable Melbourne suburbs? See our interactive Tableau data visualisation for The Age

Wondering what the most liveable Melbourne suburbs are? We have the answer...

In case you missed it, Datalicious created an interactive web-based data visualisation for The Age newspaper to showcase their data on the liveability of Melbourne suburbs. The Age pulled together scores via a survey for each suburb across a range of metrics such as Low Crime, Eating Out, Low Traffic, and Open Space.

Screen_shot_2011-12-06_at_1
The interactive web application was built using Tableau Public and allows you to adjust how important each metric is for you so that an overall score is calculated for each suburb. Have a play and see how the map colours for each suburb change according to your preferences. The top five suburbs are automatically displayed in a list above the map. South Yarra comes out on top if all metrics are considered equal and you have lots of money. The data visualisation also allows you to filter suburbs by median house price.
A few other key insights:
  • Ormond and Aberfeldie are the suburbs with something for everyone
  • Footscray West rated well across the board for median house prices less than $600K
  • Black Rock and Dandenongs are the suburbs for the quiet life with low crime, low traffic, and open spaces
  • Footscray: the best suburb for shopping, eating out, and public transport
  • Montmorency is the top suburb if you have children with schools, open spaces, and low crime
Would love to do the same for Sydney!
Check out the Datalicious Supertag: Container tag for smarter tag management

Latest news on Tableau 7.0 from the 2011 Tableau data visualisation conference in Las Vegas

There was madness in any direction, at any hour. You could strike sparks anywhere. There was a fantastic universal sense that whatever we were doing was right, that we were winning.

– Raoul Duke in Fear and Loathing in Las Vegas

Unlike Raoul, there hasn't been much winning on the tables of Vegas so far but, no doubt, my luck's gonna change soon! Where's that ATM again ...

So anyway, the 2011 Tableau customer conference is coming to an end at the Encore Casino, Las Vegas and your faithful Datalicious correspondent has been there to see it all (and I mean ALL of it).

For Tableau, it has been a chance to showcase their new releases of Desktop and Server (both due in January). More on that below. For customers, it has been a great opportunity to meet the 300 strong team (all that was left back in Seattle was an answering machine), and learn about features (old and new) that we can use to pimp our vizzes.

Tableau 7.0

I’m not going to list everything they’ve changed since 6.1 because there's stacks but here are the best bits:

  • Tableau Server will have a separate repository for datasets that can be automatically refreshed. Essentially, this means that the ‘keepers of the data’ can easily build and share ‘nice’ datasets with the people who need to build the reports and do the analyses. No drivers or database passwords required. It’s another big step to putting more data into the hands of the people who want answers to their business questions.
  • A “replace with new dataset” function. This is my favourite because quite often we build and develop dashboards in prototype form based on some sample Excel data, only to have to rebuild the dashboard once the data warehouse is built and Tableau is connected live. With this new feature, all we’ll need to do is switch in the database for the Excel at the click of a button and bam!
  • And for all you Excel perverts out there, area charts now come standard. Still no guages though ;)
We’ve got our hands on the beta version of 7.0 and look forward to demonstrating the new features with some vizzes over the coming weeks.

Also big thanks to Dirk and Ross, two Tableau Doctors who sorted out some really nasty Tableau table calculations that’ll help us build an interactive media attribution engine.

Adios amigos

Encore

Check out the Datalicious Supertag: Container tag for smarter tag management

How to use Tableau to analyse raw SiteCore web analytics data and build interactive dashboards

Screen_shot_2011-10-05_at_3

Ever wondered what kind of data WCM (Web Content Management) systems collect on individual visitors? Well, usually not much (or not in a readily accessible format anyway) but SiteCore is the exception! 

SiteCore stores all campaign response and visitor behaviour in a MS SQL database that can easily be accessed using standard BI tools such as Tableau. Have a look at the below video to see just how easy it is to connect to the database in order to create custom reports and interactive dashboards from your web analytics data.

The custom dashboard you can see in the video is unfortunately too big for Tableau public so we can only show you some screen shots in this post. However, please contact us if you're a SiteCore customer or thinking about becoming one and are interested in using Tableau as a reporting solution

Just in case you are wondering, SiteCore and Tableau probably can't replace your current web analytics platform but there's a lot of other funky stuff you can do with the raw SiteCore data, especially if you use Tableau to combine it with other additional data sources such as your CRM or call center data.

(download)

Check out the Datalicious Supertag: Container tag for smarter tag management

A data visualisation to divide the nation: Analysing Tweets for SBS's Go Back series #gobacksbs

SBS's remarkable reality TV series on refugees and asylum seekers called Go Back exploded on Twitter with over 36,000 Tweets last week. We thought it would be cool to analyse the Tweets and try distill the sentiment of a nation (or at least the Twitter savvy part of it) on this issue that apparently divides the population.

Partnered with Alterian using their business intelligence product SM2 to extract all the information on each Tweet, a database of all word pairs was created (over a million!). The word pairs, like 'asylum seekers' or 'boat people', were generated from each Tweet independently and then tallied up over all Tweets. Common words like 'the' and 'it' were removed, and a stemming algorithm was used to group words such as 'Australia', 'Australian', or 'Australia's' together. All Tweets were treated equal and all Retweets were included so that the content of the most popular and followed people on Twitter would emerge via Retweets.

Once the top word pairs (based on a tally) were finalised an open source software called Gephi, which is a powerful tool for visualising and analysing large networks, was used to present the data. See below for our first attempt; each word is connected to the words that were paired with it, taken from the the top word pairs. The size of the words is related to how many other words are connected to it (not how mant times the word pair appeared in all Tweets).

The whole network is below and shows how the different words are associated. The word 'Raquel' is at the centre (and is the largest) because it was associated with the most words. Many interesting word associations come out of the data. For example, there is a sub-network with words 'live', 'exports', and 'corners' (top left) most probably comparing the SBS Go Back series to the Four Corners program that exposed the live exports trade.

Gobacksbs1
One thing that you might notice is that there are pockets of networks that are associated with a particular Tweet that was Retweeted a lot. For example the Tweet below is associated with the sub-network (bottom middle) that contains words such as 'no', 'vote', 'mad', 'point', and 'court'. You can search Google with any combination of associated words along with the word 'gobacksbs' to find the Tweets that made up the data.

Screen_shot_2011-07-05_at_8
A focus on the main star of the program Raquel shows that the word 'Raquel' was often used in Tweets along with words like 'ignorant', 'racist', 'hate', and 'complain', but also the words 'hope', and 'change'. This surely reflects the change in viewer sentiment for Raquel as she modifies her views on refugees and Africans, and shows compassion, over the three-part series.

Gobacksbs2
 An interesting set of word pairs ...

Gobacksbs3
In our next installment we will try, among other things, to see what comes out if Retweets are not used. We will also visualise the number of times each word pair occurred making the line joining words thicker if it occurred a lot. There is a lot of scope for further analysis as Alterian's SM2 provides data on things like the gender of people who Tweeted, where in the world they are from, and when they Tweeted. See below for a screenshot of SM2's interface:

Screen_shot_2011-07-06_at_11
We hope you like it. Let us know what you think in the comments section below. Stay tuned.
Check out the Datalicious Supertag: Container tag for smarter tag management

Google Fusion Tables for easy online data storage, aggregation and visualisation including mapping

If you're into data analysis and visualisation but not quite ready to invest in one of the more professional business intelligence tools such as Tableau and Spotfire (contact us if you want to find out more), then you should check out Google Fusion Tables.

Apart from being free (all you need is a Google account), Google Fusion Tables allows you to import your data, visualise it using a slection of charts (the interactive maps are especially cool, see below) and publish reports on your own website that users can interact with via filters. Have a look at the below fusion table from the WHO on global tuberculosis control and hover over some of the countries.

WHO report on global tuberculosis control 

Check out the Datalicious Supertag: Container tag for smarter tag management