Public Loss Analysis


During my computer science diploma, I used a data set describing losses of public funds due to crime and property damage from the Canadian Open Government portal. This 5 minute demonstration shows visualizations in Tableau for the Losses of Public Money or Property as per the Public Accounts of Canada 2024 data.


Databricks on Azure offers an end to end data management and processing platform. Data can be pulled using scheduled batches, transformed using Python or SQL, and represented to end users as dashboards and KPIs. This report summarizes a fictional business case for using Databricks to host public loss data and demonstrates possible data process flows.