Microsoft Excel for Crime Analysis - Intro
Learn to format cells, work with formulas, create charts and graphs, work with pivot tables and slicers, and more! This in-person hands-on course provides students with an introduction to using Microsoft Excel for Law Enforcement, a program most agencies already have. Students will learn how to use Microsoft Excel to manipulate and analyze crime data, create charts and graphs, make a next hit forecast, calculate rates and percentages, find patterns using pivot tables and slicers, and work with workbooks. Students who complete this course are able to clean and manipulate large data sets, calculate the most common statistics used in analysis, use various tools and functions to find patterns in crime, and create meaningful layouts.
DATES: April 23-25, 2025
LOCATION: Commerce, CA
COST: $450
Space is limited and these courses will fill up quickly! Register ASAP to reserve your spot. Spots are secured on a first come, first served basis. Register at https://spatialanalysisetc.com/courses/
ArcGIS Pro for Crime Mapping - Intro
This hands-on course provides students with an introduction to crime mapping techniques and is designed for students with little or no experience in crime mapping. Students use GIS technology analyze crime and known offender data by adding this data to a base map, querying data by attribute, identifying spatial patterns, and creating completed maps. Topics include working with ArcGIS and ArcCatalog, learning coordinate system basics, exploring layer properties, reviewing data fields and records, querying data using several different methods, and designing map layouts. Students who complete this course are able to add crime and offender data to a map, find patterns, and produce meaningful maps.
DATES: May 5-7, 2025
Interested in learning crime mapping and/or MS Access? Join us for one of our 3 day courses:
Microsoft Access for Crime Analysis - Intro
Microsoft Access is a powerful database management program that many crime analysts already have. This hands-on course provides students with an introduction to using Microsoft Access for Crime Analysis. Students will use Microsoft Access to create and import tables, perform several different types of filters and queries, and create useful reports. Students who complete this course are able to import crime and offender data into Access, query the data to find patterns, and produce meaningful reports. This course is offered as a 3 days in-person course from 8 am to 4 pm.
DATES: May 13-15, 2025
Space is limited and these courses will fill up quickly! Register ASAP to reserve your spot. Spots are secured on a first come, first served basis. Register at https://spatialanalysisetc.com
Join us in sunny San Diego for Geographic Profiling training this spring. Geographic Profiling is an analytical technique that uses crime locations to locate an offender’s home. Geographic profiling fits nicely at agencies looking to advance into predictive policing. This course gives analysts, detectives, and other information about how to use geographic factors to find serial offenders. Attendees who successfully complete this course are eligible to attend the Geographic Profiling Analysis II course and become certified in geographic profiling.
Students learn through the study of real cases, group dialogue, and hands-on exercises. This course is based on the work of noted expert in the field, Dr. Kim Rossmo. Dr. Rossmo and geographic profiling have been featured in Dateline NBC, Reader's Digest, the London Sunday Times, the Il Tempo (Italy), Popular Science, TV Guide, De Limburger (The Netherlands), and hit drama NUMB3RS on CBS. This course is timed with the release of the second edition of Dr. Rossmo’s ground-breaking book “Geographic Profiling”. This methodology was a contributor to the criminal investigation that received an International Association of Chiefs of Police (IACP)/ChoicePoint Award for Excellence in Criminal Investigation and was an IACP Webber Seavey Finalist.
Date: May 19-23, 2025 (40 hours)
Location: San Diego, CaliforniaCost: $625 (California POST Plan IV)
More course information is available here: https://spatialanalysisetc.com/gpa1/
Click here for more information and to register.
Power BI for Crime Analysis - Intro
This hands-on course provides students with an introduction to Microsoft Power BI and is designed for students with little or no experience with this tool. Power BI is an excellent tool to chart crime data and make interactive dashboards. Students learn how to use Microsoft Power BI to manipulate and group crime data, create new columns of data, calculate counts, question the data, create charts and graphs, add maps to their layout, combine data from multiple sources, and create a dashboard. Students who complete this course are able to interact with large data sets, create new fields from existing data fields, make calculations, find patterns in crime, and publish meaningful dashboards.
DATES: July 21-23, 2025
2025 CCIAA State Conference- Click for more details!
Copyright ©2015 California Crime and Intelligence Analysts Association. All Rights Reserved
