Finally, the last challenge of Dashboard Week!! Today we have less time to complete the dashboard and blog because we need to present at 3 pm. We were given the BASIX certificate data for single dwellings from 2011-12 to 2018-19.
Data wrangling:
The data is very clean, so I loaded it directly to Tableau to build the dashboard. I did use Alteryx to generate a separate dataset in which I pivoted the type of water usage to a single column to build a bubble chart.
What did I build?
Due to time constraints, I chose to focus on the dwellings’ usage of rainwater. Here is a screenshot of my dashboard.
Some insights:
- Around August and September 2015, the volume of rainwater tanks for newly certified dwellings dropped to the lowest level.
- Rainwater was mainly used for gardening and lawns, laundry, and toilet flushing.
- Household water and hot water mainly relied on the town water supply.
- Dwellings that do not use rainwater for laundry and toilet flushing also relied mainly on the town water supply.
- For gardening and lawns, reticulated alternative water was the second-largest source of water after rainwater.
Click here to access the dashboard.
Author: Binbin Chen
Binbin came to Australia and studied mechanical engineering at Monash University. After earning a bachelor's degree, he pursued a PhD degree and worked as a part-time teaching associate at Monash University during the period. When analysing data in research projects involving human eye movements, he discovered his enthusiasm for data. He was delighted to learn about Data School Down Under as it provides a unique opportunity to start a career as a data analyst through a thoughtful training program. Outside of work, Binbin enjoys watching historical and political videos. He is also an anime fan!