top of page

Exploring Australian Motor Vehicle Census | Tableau Assignment Help


In this blog post, we will explore an exciting dataset from the Australian Bureau of Statistics on Motor Vehicle Census spanning from 2017 to 2018. This dataset is loaded with valuable information, including well-labeled columns, clear definitions, and intriguing data. This dataset offers a plethora of investigative potential.

Initial Data Prep

The dataset required minimal preparation. The columns were already in a format that was easily interpretable, and the data was largely clean. With these minor checks, we set off investigating in Tableau.

Areas of Investigation

We delved into various areas in this dataset, including:

  • Total number of registered vehicles

  • Growth rate of the national vehicle fleet

  • Top vehicle make

  • Diesel vs. petrol vehicles

  • Growth in various vehicle types

  • Average age of vehicles

These areas offered a wealth of insights into trends and patterns in Australian motor vehicle registrations. There's great potential to revisit this dataset at a later point for further exploration.

Building a Dashboard

After exploring the dataset, a summary dashboard was developed to visualize key findings. The plan was to drill down into more detail with actions, filters, and sheets if time allowed. The dashboard featured interactive visualizations and included additional insights in tooltips. A theme of simplicity and clarity was selected, with all instructions, parameters, and controls intuitively designed.

Key Insights

  • As of 31 January 2018, there were 19.2 million registered motor vehicles in Australia, with the national vehicle fleet growing by 2.1 per cent between 2017 and 2018​​.

  • Toyota topped the list of passenger vehicle makes for the 13th consecutive year with 2.9 million registrations​​.

  • Diesel-powered vehicles constitute 23.4 per cent of the national fleet, up from 17.2 per cent in 2013, making it the fastest-growing fuel type​​.

  • Light rigid trucks reported the largest growth rate of any vehicle type, increasing by 5.1 per cent​​.

  • The average age of all vehicles registered in Australia was 10.1 years, unchanged since 2015, with Tasmanian vehicles having the oldest average age at 12.8 years​​.

Future Exploration

There's still a wealth of data left unexplored in this dataset. Future investigations could focus on other aspects like the impact of specific vehicle make on total registrations, the evolution of vehicle types over time, or the correlation between vehicle type and fuel type. This exploration has only scratched the surface of what's possible with this dataset. As with any analysis, the more you dig in, the more insights you'll uncover. So, keep exploring!

For complete solution and expert guidance on Tableau Assignment Help, feel free to contact us

bottom of page