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:
December 9-11, 2024 (Open)
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: January 13-15, 2025
LOCATION: Commerce, CA
COST: $450
ArcGIS Pro for Crime Mapping - Intermediate
This in-person hands-on course provides students with an intermediate understanding of crime mapping techniques and is designed for students who have some experience in crime mapping. Students will learn to use GIS technology to create new datasets, make thematic maps, and create and interpret hot spots. Topics include working within different coordinate systems, editing data fields and geometry, creating thematic and kernel density hot spot maps, and troubleshooting issues. Students who complete this course are able to create new area boundaries, produce several types of hot spot maps, and understand influences that are correlated with crime clustering. Prerequisite: Intro course or permission of instructor.
DATES: February 10-12, 2025
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: March 24-26, 2025
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
Copyright ©2015 California Crime and Intelligence Analysts Association. All Rights Reserved