Virtual Analytical Training

Self-Paced Online Training:

 

 Multi-Part Online Analytical Training Series

This free training series is designed for new and seasoned analysts to learn the key primary skills needed to practice effective and efficient analytical processes. This series explores the benefits of data-driven strategies, the process of connecting databases and analyzing in Microsoft Access®, applying statistical significance techniques in Microsoft Excel®, and developing key mapping and analytical skills in ArcGIS. 

Although each segment is a stand-alone "course," each builds off the subsequent segment. Further, attendees completing all 13 segments can apply to the International Association of Crime Analysts (IACA) to receive credit and recognition as Certified DDACTS Analyst.

NOTE: All 13 parts have received the seal of excellence from the National Certification Program (NCP) and therefore qualify to be submitted for TCOLE credit hours.

The training series can be found on the First Forward web page by going to First Forward and searching "Market Place" for all training or you can access each class by utilizing the links below:

Part One: Data Driven Strategy Basics

Part Two:  DDACTS in Action

Part Three:  Connectivity Why Do I Need It?

Part Four: Helpful Queries, Reports, Macros Part Five: Creating Master Tables Part Six: Data Quality and Cleaning Tips
Part Seven:  Making Analytics Easier with Expressions Part Eight:  How to Identify Top Locations, Offenders, and More Part Nine: How to Create Rocking Reports and Automation Processes
Part Ten:  Z-Score and Statistical Significance Made Easy (Excel) Part Eleven:  Introduction to ArcGIS Pro for DDACTS Part Twelve:  Dots on the Map: Plotting and Querying Crash and Crime Data from a Variety of Data Sources
Part Thirteen:  Hot Spot Identification and Analysis    

Virtual Analytical Training Series

IADLEST in cooperation with TXDOT is offering a FREE virtual analytical training series that focuses on the principles regarding data quality, data analysis, reporting, and evaluation using Microsoft Excel®. It is designed for analysts to learn the key data and analytical skills needed to establish effective and efficient data-driven processes. This training provides detailed instruction and practical exercises regarding the process of organizing quality police data and performing quality analyses.

 

Microsoft EXCEL for Data Driven Strategies - BASIC

This 21-hour virtual workshop is presented over four weeks in a multi-faceted learning platform that includes both live and recorded training sessions, self-paced activities, and one-on-one live remote tutorial sessions throughout the four weeks.

 

Workshop Schedule

Date 2024 Session Skills Development

Registration / Archive

February 1st Self-Study Assignment - Basic See Objectives

Registration via email

February 8th Virtual Training Session - #1   View Recording
February 15th Virtual Training Session - #2   View Recording
February 22nd Virtual Training Session - #3   View Recording
February 29th Virtual Training Session - #4   View Recording

 

To register contact Daniel A. Howard at danhoward@iadlest.org.

 

Completed Training

Thursday, July 27, 2023                    Self-Paced and Live Segments

Thursday, February 2, 2023             Self-Paced and Live Segments

Tuesday, June 22, 2021                     Self-Paced and Live Segments

Wednesday, October 14, 2020         Self-Paced and Live Segments

Thursday, August 27, 2020               Self-Paced  and Live Segments

Thursday, June 11, 2020                   Self-Paced  and Live Segments

Wednesday, June 10, 2020               Self-Paced  and Live Segments

Tuesday, June 9, 2020                       Self-Paced and Live Segments

 

Microsoft EXCEL for Data Driven Strategies - INTERMEDIATE

This 14-hour virtual workshop is the next step in the training series and builds on the Basic-Excel Workshop. The workshop includes threshold analysis and critical thinking, application with complex formulas, and 3D mapping in Excel. The workshop is presented over three weeks in a multi-faceted learning platform that includes both live and recorded training sessions, self-paced activities, and one-on-one live remote tutorial sessions throughout the 3 weeks.

Workshop Schedule:

Date 2024

Session

Skills Development

Registration / Archive

March 14th

Self-Study Assignment - Intermediate

See Objectives

Registration

March 21st

Virtual Training Session - #1

 

 

March 28th

Virtual Training Session - #2

 

 

April 4th

Virtual Training Session - #3

 

 

 

To register contact Daniel A. Howard at danhoward@iadlest.org.

 

Completed Training Sessions

Thursday, March 16, 2023                 Self-Pased and Live Segments

Tuesday, January 11, 2022                 Self-Pased and Live Segments

Tuesday, July 27, 2021                        Self-Pased and Live Segments

Wednesday, October 14, 2020          Self-Pased and Live Segments

 

Creating Analytical Capacity:  Analysis in Action

This is a 14-hour virtual workshop is next in the continuing online analytical training series and focuses on the concepts of tactical analysis as a means to provide field personnel with actionable information to reduce crashes, crimes and other social harms. The training is presented over 4 weeks in a multi-faceted learning platform that includes live and recorded training sessions, self-paced activities, and one-on-one live remote tutorial sessions. This workshop will assist students with putting analytical knowledge and skills into action in support the agency in strategic and effective analysis-driven operations.
 

Workshop Schedule:

Date 2024

Session

Skills Development

Registration / Archive

April 18th

Self-Study Assignment - Basic

See Objectives

Registration

April  25th

Virtual Training Session - #1

 

 

May 2nd

Virtual Training Session - #2

 

 

May 9th

Virtual Training Session - #3

 

 

 

To register contact Daniel A. Howard at danhoward@iadlest.org.

 

Completed Training Sessions

Thursday, April 20, 2023            Self-Paced and Live Segments

 

Tactical Analysis for Crashes & Crime

This is a 14-hour virtual workshop is next in the continuing online analytical training series. The training is presented over 4 weeks in a multi-faceted learning platform that includes live and recorded training sessions, self-paced activities, and one-on-one live remote tutorial sessions throughout 3 week period.

 

Workshop Schedule:

Thursday, November 2, 2021   Self-Paced and Live Segments

Thursday, August 26, 2021       Self-Paced and Live Segments

Wednesday, January 27, 2021  Self-Paced and Live Segments


Microsoft ACCESS for Data Driven Strategies - BASIC

This 24-hour virtual workshop builds off the 10-part online training analytical training series. The training is presented over four weeks in a multi-faceted learning platform that includes both live and recorded training sessions, self-paced activities, and one-on-one live remote tutorial sessions throughout three week period.

Workshop Schedule:

Tuesday, April 20, 2021           Self-Paced and Live Segments

Tuesday, October 13, 2020     Self-Paced  and Live Segments

Tuesday, July 28, 2020             Self-Paced and Live Segments

Thursday, May 21, 2020          Self-Paced and Live Segments

Wednesday, May 20, 2020      Self-Paced  and Live Segments

Tuesday, May 19, 2020            Self-Paced  and Live Segments

 

Microsoft ACCESS for Data-Driven Strategies - INTERMEDIATE

This 14-hour virtual workshop is the next step in the training series and builds on the Basic-Access Workshop. The workshop includes the topics of creating master databases and forms, mastering complex queries, and designing complex reporting and macros. The workshop is presented over three weeks in a multi-faceted learning platform that includes both live and recorded training sessions, self-paced activities, and one-on-one live remote tutorial sessions throughout the three weeks.

Workshop Schedule:

Tuesday, May 25, 2021                 Self-Paced and Live Segments

Tuesday, October 13, 2020          Self-Paced and Live Segments

 

 

To register for this training contact Daniel A. Howard at:  danhoward@iadlest.org

 


Analyst Mastermind Webinar Series:

 

In this past webinar series, crime and crash analysts shared advanced techniques and best practices to help departments reduce traffic crashes and crime in their jurisdiction.  Note: The February 19, 2020 session was a Chief's Roundtable answering questions about how to promote buy-in for evidence-based policing in a department.

 

Date Preview Video Register to view recorded webinar

January 8, 2020

Preview Video (2-min)

Identify Crash and Crime Patterns
February 19, 2020 Preview Video (2-min) Chief's Roundtable: Tips on Creating a Data-Driven Culture
March 18, 2020 Preview Video (2-min) Creating Quality Maps
April 15, 2020 Preview Video (2-min) What I Should Know as an Analyst
May 6, 2020 Preview Video (2-min) Supervisor's Roundtable:  How to Motivate, Inspire and Train your Team
June 11, 2020 Preview Video (2-min) Productivity: Get More Quality Work Done in Less Time
July 22, 2020 Preview Video (2-min) Creating an Actionable Bulletin

BJA Building Analytical Capacity: Crime and Crash Analysis Webinar Recordings 

(Previously Recorded)

These are a series of twenty webinars produced by IADLEST in cooperation with the Bureau of Justice Assistance covering various aspects of data analysis.  View to find out how you can help your department reduce the number of traffic crashes and crime incidents in your community.

Building Analytical Capacity


 

Multi-Part Webinar series.

A multi-part nationally recognized Data Analysis Using Microsoft Access and GIS on-line series consisting of 60 to 90-minute webinars previously conducted.

 

The Webinar Recordings are accessible for review purposes only and can be found at the below links:

 

 

 

Data Analysis Using Microsoft Access series: GIS: Mapping and Hot Spot Identification series: