Vancouver is a city in Western Canada, in the province of British Columbia. Vancouver Police Department (VPD) regularly publishes crime data for the public to view.
- View the dashboard
- SQLite script used to clean and prepare the data set
- Walkthrough of the SQLite script and a small bit of Python code
- Vancouver crime data set can be found on VPD Open Data
- Vancouver population data is conveniently on Wikipedia
The goal in this project is to create a dashboard where we can display crime trends in Vancouver in the last decade.
- SQL: SQLite
- Tableau
- Python: Utm
- Jupyter Notebook
- Data Cleaning, Data Visualization, Creating Dashboard, Coordinate Systems, Statistics