Finally, it’s dashboard week!

For our day 1 dashboard, we got this dataset from City of Melbourne website, and it shows the requests for service logged by members of the public relating to waste, graffiti, parking, roads and traffic, parks and trees and assets in a public space.

Data Preparation

This dataset is clean, nothing needs to be done apart from changing a few data types from string type to date type. So, I used Tableau Prep to do the data cleaning. Below is my Tableau Prep Workflow.

Dashboard (Interactive Viz)

I used VIC Suburb/Locality Boundaries to join the provided dataset get the polygon of all the suburbs in City of Melbourne to build the map.

Below are 3 core components to my dashboard:

Map by suburb (coloured by the number of requests lodged)

Service requests efficiency Analysis (evaluated by the average complete days)

Service requests by Category and Subcategory (you can drill down and drill up)

Interesting findings:
  • There are no parking compliance service requests on Sundays. Mainly because all the popular parking service areas (Melbourne CBD, Docklands and Southbank) are free to park in on Sundays.

  • In Kensington, from April 2015 to October 2015, there are 3 requests which all took more than 390 days to complete. There are a few things we need to dig deeper into



Good aspects:

Nice colour choices to match City of Melbourne logo colours and the dashboard looks clean;

Good timeboxing, I finished the dashboard earlier than expected.

Things to improve:

Use supplementary dataset and bring more layers to the map;

Date filter can be added to make this Viz more interactive.


Zoe Lu
Author: Zoe Lu

Zoe is a graduate of the University of Queensland, majoring in professional accounting and applied finance, she always strives to learn and enjoys applying her skills to manage any challenge. She moved from Brisbane to Melbourne three years ago and she believes that all change is good change. When Zoe is not creating dashboards, you will see her at Pilates or enjoying the good restaurants around Melbourne with her family and friends. If you ever get a chance to eat hot pot with her, she will share the recipe for her delicious secret dipping sauce.