"SAS Institute, in partnership with Geotab Inc. and the Toronto Police Services, is hosting the fourth annual Safe Roads Competition, a virtual analytics competition for university and college students in Canada and Mexico.
Finals projects must be submitted by 5:00 p.m. ET on Friday, March 4, 2022. Final presentations will be assessed by a panel of industry judges on Friday, March 11, 2022."
For my project, I have chosen the Toronto case and also been using Python, SAS, Power BI, Azure to conduct analysis and visualize dashboards which are inspired by the Toronto Police Service's Annual Statistical Report Interactive Dashboards.
The content of this project is published on HackMD and shared with only my future recruiters via a private hyperlink on my resume for job application purpose. This is to not disclose my progress and results in this project to other participants as I will also join in this competition again in 2023 with more insights.
-
SAS: explore data & generate main reports in A/B Testing
-
Power BI: visualize descriptive & diagnostic analysis
-
SQL: query to deliver results on both SAS & AzureML (for descriptive analysis)
-
AzureML: store datasets, conduct descriptive analysis in SQL queries, examine diagnostics analysis and predictive analysis
(disclosed within the Case Study and the SAS Institute's registered Virtual Learning Environment only)
https://www.sas.com/en_ca/events/2021/q4/safe-roads-competition.html
7 datasets for the Toronto cases retrieved from Toronto Police Service, Geotab and City of Toronto. In the Phase 1, I am using the Toronto Police Services Killed or Seriously Injured Dataset. In the Phase 2, I will narrow down to 3 datasets (2 from Toronto Police Services and 1 from geotab) for further analysis.