Dashboard Week Day 4, dreaded ABS data again. The task was to two choose two questions from last year’s Census data and create a dashboard. As always working with Census data is always fun, there’s a lot to get your head around before you get started on the mammoth task of cleaning your data, after that there’s more!

I decided to go with Health, sections G19A and G19B, the main thing to watch out for in ABS data is, that there are nested Totals and for some reason, there are A and B when it can all easily fit into one excel file. Here’s a picture of the Alteryx workflow, All the summarisation tools you see there, are me double checking and triple checking my numbers because they did not add up. Using the summarise tool is a great way to check your numbers.

I eventually went to the excel spreadsheet to validate my validation, and clearly the numbers the ABS was reporting did not add up, something like 4 + 7 = 8. If this is a user error, I’ll be sure to come back and update this blog, for now, I had to keep going as time was of the essence.

Secondly bear in mind the gain of your data, otherwise, your relationships in the tableau won’t work. I tried to add additional details for further insights, but this did not work. Here’s the dashboard and some interesting insights,

As per the Australian Bureau of Statistics, just over half of all Australians consider themselves healthy. More Australians over the ages of 25-34 consider themselves unhealthy.  Over 55% of females consider themselves unhealthy with Mental illness leading the list of health conditions. Men on the other hand seem to not speak up as always when it comes to their health.

Mental health condition is the leading cause of ill health for most unwell Australians, affecting more women between the ages of 25-34, whereas for men it peaks from this age group and tends to affect men until the ages of 55-64.

Phew! That’s 4 days done. Day 5 is going to be a race to the finish line.

Jude Shu
Author: Jude Shu