Hello again readers! Today’s challenge is to analyse the Victorian crime history, where the data is publicly available here. The twist here is we have to use PowerBI instead. While this is a great opportunity to learn PowerBI, we have only been exposed to PowerBI for 2 days during our training, and we lost an hour as we had to evacuate our building due to fire alarm! Thankfully, we were allowed to use Alteryx to manipulate the data and skip using the in-built power query.

After spending time with the data, we have found that they are already aggregated, and it is impossible to join the tables together if we want to drill down to those specific fields (e.g., they recorded incident reports by gender in one table, and age group in another table, while the total number matches, we can’t find out the age group distribution of female reporters). So we just have to work with that!

Some data prep that I have done this time involves creating a date type field from a string type year field, dropping non-metropolitan Melbourne LGAs to lessen the data processing time in powerBI, as well as changing 2 LGA names that have changed overtime to ensure it matches ArcGIS mapping system.

Now off to PowerBI! It was a challenging experience, but I have learned A LOT! Doing simple things like calculating previous year’s metric is much simpler in Tableau, but in powerBI, a new calculated field must be prepared to do so. And I actually spent a lot of time trying to figure this bit, only to realise later that the ‘Year’ data type was a string, and previous year comparison is only possible if they are in ‘date’ format.

I have also spent quite a bit of time figuring out the interactivity of my dashboard, in particular, how to show-hide charts using navigation buttons. This is necessary to do as I have data from 3 different tables, and they cannot be joined. Since I ran out of time, I did not get the chance to beautify my dashboard, but it works and it has a story!

Some insights that I have found are;

  • The crime rate has increased overall in 2023
  • All crimes are more common in South West and Central Melbourne area.
  • Thievery is very common, whereas burglary, assault, and property damage are less common. But assault crimes has increased over the year.
  • 50% of the cases are unsolved, which is concerning!
  • Private dwelling cases are significantly higher compared to non-private dwelling cases.
  • Crimes on streets and surrounding grounds are common as well.
  • Crimes on public transports are not that common.

And that is about it for this blog! Thank you for reading! 😊

The Data School
Author: The Data School