For the third day of Dashboard Week, the task is to create a dashboard using the Victoria census dataset from the Australian Bureau of Statistics. It is possible to supplement the analysis with additional statistics from other states or other data sources. The interesting rule for today is that we are not allowed to use Alteryx, so we will have to rely on Tableau Prep in the data preparation process.

The Dataset

In this challenge, we use a dataset containing Victoria census data that covers a variety of topics, including population, economy, income and family, and education. This means that we are not restricted in the questions we can ask or the topics we can explore using this data.

My approach

Selecting a topic question can be both exciting and challenging, as it sets the direction for the entire analysis project and my question for today is: “Is Victoria a good place to live?” While there is no specific data that evaluates the livability of Victoria or other states, I have found a dataset on the World Happiness Score that rates countries based on various factors such as Health life expectancy, social support, GDP per capita, etc. This dataset will allow me to determine if Australia is a good place to live overall, and then I will drill down to the sub-state level to examine Victoria’s health long-term conditions, and income levels.

Data preparation

As we have mentioned from the beginning, I will have to use Tableau Prep instead of Alteryx for this. There are 3 small stages for this section

1. Union and cleaning the World Happiness Data

The cleaning process for all of the files is largely the same, but there are some differences due to the fact that each file has differently named fields. Therefore, I need to manually rename the columns before combining them. These files contain happiness scores and cover the years 2015 to 2022.

2. Cleaning Victoria Health Data

In this flow, I just cleaning all the health data, which is the people with different long-term conditions data and then union them.

3. Cleaning Victoria Income Data

In this workflow, the first block obtains data on the income range of employees in Victoria, while the second block combines data from the economy (number of businesses in various industries) with data from education (number of employees in various industries). Note that I joined those 2 data based on similar industry

The Dashboard

First, let’s have a look through the dashboard

Look quite simple right, The key thing is that I have used Dynamic Zoning to swapping sheets when you click on those icons (which stands for health and income) in terms of evaluating those aspects of Victoria.

Here is the layout of the Health layout:

And here is what happened when you click on the income icon:

Insights

  • Australia happiness score always stay in top 15 of the most livable country in the world from 2015-2022.
  • In all category (health life expectancy, GDP Per capita, Social support and others), Australia always have a higher score than 75% of other countries in the world.
  • Victoria rate of people with no long-term health condition is around 61%, slightly smaller than Northern Territory but still higher or at least equal to other states.
  • 47% of people working in Victoria will earn $1000-$3000 a week, and the percentage of this group of people are still increasing overtime.
  • Job opportunity are increasing overtime in Australia as well, along with a positive relationship with number of businesses in the same industry.

Conclusion

Returning to the original question: “Is Victoria a good place to live?” The answer is subjective and depends on individual perspectives. I hope that this dashboard will provide different viewpoints and help you come to your own conclusion. Personally, I couldn’t asked for more.

The Data School
Author: The Data School