EXCELerate Your COMPSTAT
The presentation will provide an overview of how analysts can automate crime statistics using only MS Access and Excel. Attendees will learn the basics of pulling data using SQL, creating engaging and dynamic visualizations in Excel, and fully automating the process using macros and Excel formulas. Using a simulated database, attendees will have the chance to walk through the process of establishing an outside connection to a RMS, writing a simple query, and refreshing the reports. Attendees will leave with Excel templates they can take to their home departments and the skills necessary to adapt them to unique databases.
Amanda K. Bruner works in CNA’s Center for Justice Research Innovation as a crime analysis advisor primarily supporting the Crime Analyst in Residence (CAR) Program, a national training and technical assistance initiative sponsored by the Bureau of Justice Assistance. As a subject matter expert (SME), Bruner also conducts crime analysis assessments and training for the Project Safe Neighborhood (PSN) and Public Safety Partnership (PSP) Programs. She is an adjunct criminal justice professor concentrating in crime analysis at Radford University and the University of North Carolina at Charlotte and has presented on various analytical topics at conferences across the United States. Bruner is the President of the Carolinas Crime Analysis Association (CCAA) and a Membership Committee volunteer for the International Association of Crime Analysts (IACA).
