ATWJE - Lenny Leedy, the Excel Guru

Leapodcasts

English - July 18, 2022 11:37 - 1 hour - 76.2 MB
Government Homepage Download Google Podcasts Overcast Castro Pocket Casts RSS feed

Previous Episode: ATWJE - Kyle McFatridge - The SNA SME

Next Episode: ATWJE - Nicolas Smith - The Analyst That Never Gives Up

Episode: 00116

Release Date: July 18, 2022

Description: Don’t ask our next guest his favorite Excel formula (there’s too many to choose); in this week’s episode Leonard (Lenny) Leedy tells us all bout how Excel can make your analysis easier and how his skills made him an invaluable addition to any team he was on. Lenny’s badge stories include phone analysis for embezzlement cases and drug trafficking organizations as well as providing lead tasking assistance on the Boston Marathon Bombing investigation. Lenny has twenty-five years of varied Law Enforcement experience including Uniform, K-9, SWAT, Vice and Narcotics. Lenny has gone onto be an instructor and course developer for multiple groups (Federal Law Enforcement Training Center and Multijurisdictional Counterdrug Task Force Training, among others). In addition to being an instructor, Lenny is an authorized reseller for Law Enforcement Investigative software developed by ACISS Systems.

We have a new segment called The Analysts of Tomorrow where we highlight up-and-coming analysts with exceptional potential in the field of law enforcement analysis. Got someone you'd like us to highlight? Let us know in the comments, or if you’d like to be featured in a future episode, please send us a recording (no more than 30 seconds) of who you think is an "Analyst of Tomorrow" and why to [email protected].

CHALLENGE: There are Easter eggs in one of the tables of the chapter that Jason wrote for the IACA textbook. First-person to email us at [email protected] about what the Easter eggs are will receive a $20 gift card from us. Happy hunting!

Name Drops: Chief Curt Zinger/Mickey Stepinoff (00:16:33), Steve Gottlieb (00:26:51), Cindy Leedy (01:17:55)

Public Service Announcements:
Small Steps with Seth Potts (https://www.youtube.com/playlist?list=PLqQ0bCMYfEp5-ma42q5SQVlwcFOMD5byv

Association(s) Mentioned: IALEIA, National Fusion Center Association, LEIU

Vendor(s) Mentioned: ACISS, RF Flow, I2

Contact: 727-397-6882 Desk, [email protected]

Transcript: https://mcdn.podbean.com/mf/web/xd3vkh/Lenny_Leedy_transcript.pdf

Podcast Writer: Mindy Duong

Podcast Researcher:

Theme Song: Written and Recorded by The Rough & Tumble. Find more of their music at www.theroughandtumble.com.

Logo: Designed by Kyle McMullen. Please visit www.moderntype.com for any printable business forms and planners.

Podcast Email: [email protected]

Podcast Webpage: www.leapodcasts.com

Podcast Twitter: @leapodcasts

YouTube Version: https://youtu.be/qTUxtafqI8s

00:00:17 – Introducing Lenny
00:06:36 – Bringing Computers to Investigations
00:08:25 – Discovering Pivot Tables
00:21:46 – Link Charting with RF Flow
00:23:46 – Analyzing with Excel
00:32:30 – Break: Small Steps with Seth Potts
00:34:29 – Calculating Age in Excel
00:50:21 – Multi-Target Analysis: Henry Lyons Case
00:55:22 – Using ACISS in Boston Marathon Bombing Case
01:06:35 – Studying a 1,000 calls a day: Romeo Mathis Case
01:13:14 – Personal Interests: Banjo & Wilderness Trainer
01:21:01 – Words to the World