Welcome to our Dashboard Week, Day 1. The task today is to analyse the City of Melbourne’s Customer Service Requests dataset and gain some insights.
About the dataset:
The customer Service Requests dataset is an open-source dataset from the City of Melbourne website. It is about 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. This dataset has 7 fields: Request status, Date received, Date completed, Suburb, Category, Service description, and Days to complete.
A detailed description and dataset can be obtained from: https://data.melbourne.vic.gov.au/City-Council/Customer-service-requests-with-resolution-time/ht4h-vqbu
Additional dataset used for analysis:
I have used an additional dataset from the City of Melbourne website to enrich the above data, which contains data about the population distribution based on age groups.
This additional dataset can be obtained from: Residents Profiles by CLUE Small Area | Tyler Data & Insights (melbourne.vic.gov.au)
Analysis:
Below is an image of my dashboard: Customer Service Request Analysis
City of Melbourne have received more than 75,000 sevice requests between 2014-2016. Out of which, they have successfully closed more than 98% of the requests which is pretty impressive. This shows that they are not keeping many backlogs and are operating efficiently. Also that it takes 11 days on an average to complete a service request.
The overall trend for the number of requests looks like rising with a steep fall in requests from Oct 2016 to Nov 2016. This might be because the data is last updated on 20 Nov 2016, so it might not be complete.
If we look at the service request categories, for most of the suburbs waste, street cleaning and litter constitute the majority of the requests. However, if we take a closer look at the categories along with the population distribution by age, we can see a pattern of an increased percentage of graffiti-related requests in the suburbs with a higher youth population like Parkville and Carlton.
From the above analysis, we can take a step towards spreading more awareness among the youths, and develop some graffiti art walls in parks dedicated for the creative youths to harness their creativity by taking council permitted wall space.