Understanding Campus Crime with A Multi-University Analytics System Academic Article uri icon

Abstract

  • Due to budget challenges, the campus police department of engaged in a data-driven performance management effort. To support this effort, publicly available data from multiple sources was integrated into rigorous data model in a single MS SQL Server database with interactive reporting using MS SQL Server Reporting Services. The data consisted of publicly available crime statistics for 38 universities, as well as characteristics such as Carnegie classification, acreage, budget, number of students, etc. The purpose of the system was to benchmark the campus police department against peer, aspirant, and other similar universities. This paper describes the architecture of the system, the benefits to the police department, and sample analytics.

Publication Date

  • 2019-11-01