This introductory training is designed for analysts at Statistical Analysis Centers. It focused on the fundamentals of SQL to work effectively with FBI National Incident-Based Reporting System (NIBRS) data. No prior experience with SQL or database management is required, and participants will use Microsoft Access as the primary interface for learning.

Throughout the course, participants will gain hands-on experience in:

Basic querying techniques to retrieve specific data from NIBRS datasets
Cleaning, standardizing, and aggregating data to support accurate reporting and analysis
Connecting to relational databases and navigating complex database structures without the use of
codebooks or guides
Automating processes to streamline the creation of recurring analytical reports

By the end of the course, attendees will be equipped with practical skills to efficiently manage and analyze NIBRS data, enabling them to produce timely, data-driven insights with minimal manual effort.

Presenter Bio:

Charley Giberti is a Solution Engineer contracting with the Department of Justice Money Laundering and Asset Recovery Section to implement next-generation data analysis systems. Throughout his private-sector career, he has consulted with the Department of Defense, the Department of Labor, and public and private sector agencies in the US, Canada and Mexico. He provides training and technical assistance to state and local law enforcement through Project Safe Neighborhoods and the Crime Analyst in Residence program. Charley worked as a Crime Analyst for the Cincinnati Police Department and as an Analyst Supervisor for the Wichita Police Department before entering the private sector. He is a long-time contributor to the IACA, presenting at the annual conference since 2018 and winning the 2018 Innovation Award. He has taught Criminal Justice courses at the University of Cincinnati and Marymount University. He holds a Master’s degree from Florida State University and is a certified Microsoft Power Platform Architect.