Today our challenge is to design a dashboard and tell a story about Australian Taxation Data.
Data Preparation
Today’s data set can be downloaded from https://data.gov.au/data/dataset/taxation-statistics-2018-19. The data set has many categories such as Individual Index, Company Index, Superannuation, etc. Even though it is tempting to look at many of the data I decided to stick with Individual tax data. I decided to use tables 6 and 7 as I can do some spatial analysis. Data was in a good format that only needed a little cleaning and some filtering. I decided to analyze Victorian tax data. I have added a postal code with suburbs names dataset as supplementary data.
The workflow for original data is as shown below,
Once Preparation is ready, I brought the data into Tableau and used the relationship to connect data.
Dashboard
After spending some time finding data, I started working on my Dashboard. My main goal is to identify the wealthiest postal areas and analyze donation amounts to locate areas to conduct a charity campaign.
Most of the wealthiest postal areas are located near Melbourne CBD and Toorak has the highest median tax paid amount and most donated.
You can find my Dashboard in Tableau Public – Wealthy Victorians and Donations. Hope you enjoy my Viz.