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.
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.
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