Australian Census data visualised with new Tableau 6.1 dark maps feature reveals a severe man draught

When we saw the new Tableau 6.1 dark map background feature and given today is Australian Census day, we though this is ideal to visualise the best nightlife hunting grounds for single men and women in Australia looking for a romance using some of the older Census data from 2006! But before we go into that, let's have a quick look at the sizeable Tableau 6.1 upgrade the company released last week. 

As far as the changes to Tableau go, here are some of the highlights:
+ Dashboards are now rendered specifically for iPads
+ Australian postcode data can now be plotted on maps automatically
+ Faster data processing and extraction, especially for test files
+ Ability to append additional data to extracts and data connections
+ View the input data as a whole via the left-hand side data window
You can check out a full demo of the new Tableau Desktop 6.1 features online but let's have at look at the last Census 2006 data on single men and women in Australia to demonstrate Tableau's new postcode functionality and sexy dark map background.

The topic of interest: Australia's supposed man drought

The basic theory is that there's a severe undersupply of single men for single women, particularly in their 30's. At first glance, this would seem a bit odd given that there's a roughly 50/50 split of men and women at birth. So let's see if this is true ...

At the national level, there are actually more single men than women for ages 20 to 34. And for the 35 to 39 age group there's only around 10,000 more single women than single men. Overall, the man drought doesn't really exist for 30-somethings.

However, the man drought may just be a regional phenomenon.

The below maps highlight the ratio of women to men in between the ages of 30 and 39. Depending on the map and your gender preference, a redder shade indicates a less favourable ratio and a greener shade a more favourable ratio. The size of the location represents the total number of people aged 30 to 39.

Northern NSW appears to have the largest scarcity of single men aged 30-39 (ratio of 1.07), while there's an abundance of men in Regional SA (ratio of 0.85). Although these ratio's aren't particularly high, there's some evidence of the man drought in particular regions of Australia.

Now, here's the best bit. If we look at ratios of single women to single men aged 30 to 39 in particular postcodes, then there are some places in Australia with an obvious scarcity of men. The top 3 places (of notable size) are:

1. 2559, Blairmount, NSW - 2.4 women for every man
2. 4509, Mango Hill/North Lakes, QLD - 1.9
3. 6770, Halls Creek, WA - 1.8 
It seems that there is a man drought, but it just depends on where you live. Similarly, there are places with a severe absence of single women in their 30s too. Here's the top 3:

1. 3008, Docklands, VIC - 0.4 women for every man
2. 5725, Roxby Downs/Olympic Dam, SA - 0.5
3. 4774, Moranbah, WA - 0.5
Single women are advised to avoid regions that suffer from a scarcity of single men if they are looking for a romance and single men might want to consider an excustion to these areas to imporve their chances of success. Have a look at our interactive maps and screen shots of wider Sydney and Melbourne to find out where you should be looking for your next man or woman.

Note: There's a fair bit of data behind the dashboards so please be patient when zooming in to your location.

(download)
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

YouTube channel with easy to understand videos on statistical concepts such as regression analysis

For those of you who would like to get into the heavy stats side of data mining (or have accepted the fat that they probably have to), I just came across a great YouTube video channel thanks to Shailendra Kumar's blog, the current data mining lead at Woolworths (his blog is a great reas as well but a little more involved).

The StatisticsFun YouTube channel contains some really great videos with step by step explanations of statistical concepts including the below on regression analysis which is basically the mechanism behind the prediction of customer behaviour based on past transactions or the holy grail of data mining. How about watching a few stats videos of the Christmas break?

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

SocialMention.com: Barack Obama vs. Osama Bin Laden

There's a new social media search and analytics engine out there called http://www.socialmention.com/ which not only scans the social and consumer generated content sphere out there for any search term you put in but also gives you a sentiment analysis, i.e. whether people are talking about the specified keyword in a positive, neutral or negative way. Very useful for brand strength and perception analysis if combined with http://www.google.com/trends charts on brand search term volume in general.

We love the new service and think it's awesome but would love some more info on how the sentiment analysis is done as the outcome sometimes seems questionable, i.e. Barack Obama negative 27 vs. Osama Bin Laden negative 11). Also, a comparison and charting functionality would be great so we could compare a few different search terms next to each other over time.

SocialMention.com: Barack Obama
http://socialmention.com/search?q=barack+obama&t=blogs&btnG=Search

SocialMention.com: Osama Bin Laden
http://socialmention.com/search?q=osama+bin+laden&t=blogs&btnG=Search

(download)

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

Excel Analytics: import Google Analytics data right into Excel via plug-in