Return to Training Schedule

Cell Phone Data and Mapping

Early (3 Months Left) $450.00 ENDS JANUARY 25
Regular $475.00 ENDS MARCH 25
Late $495.00 ENDS APRIL 25

Host: Eastern Missouri Police Academy
Location: Eastern Missouri Police Academy 11 Meadows Circle Dr 422 Lake St. Louis, MO 63367
Dates: April 25, 2022 - April 26, 2022
Times: 8:00am - 4:00pm
Fee: $450.00

Course Description
Travel Information

Managing and Mapping Cell Phone Data for Case Management and Prosecution

Course Overview
The amount of data retrieved during a cell phone investigation can be staggering.  Call records and tower data generate hundreds of records in just a few days from a single phone, tens of thousands of records are not unusual.  Managing this data (and visually depicting it) showing criminality, and making it “make sense” to others is the purpose of this course.

The course covers methods to view, analyze and present cell phone (and related data sets) data generated from current investigations.  Through the use of specific case studies and prepared sample sets of data (generated from actual cases) students learn how to analyze and present data found in typical investigations.  Special data sets (non-cell phone) are also presented as potential sources for evidence.

By the end of the course, students will be confident in their ability to manage and present digital data sets (cell and others) as evidence in court and in special hearings.

This class is designed for law enforcement officers at any stage in their career.  Experience or training in cell phone investigations is not required.  Students will be receive samples of data for use in the classroom during hands-on sessions.  A laptop with Microsoft Excel, Word and PowerPoint (version 2003 or higher) is required.


Day One

  1. Youv'e got the data now what?
  2. If/ Then Statements - Looking at the Data, Outside Call Lists, Who is calling who?, Distinct Call Lists For Use in V-Lookups
  3. V-Lookups - Getting the facts from the Data, Linking Numbers to People, Tower Locations, Human Readable, Intermediate Code
  4. Pivot Tables - Finding the important clues in the Data, Call Frequency, Tower Frequency, Sum of Calls, Sum of Minutes



Day Two

  1. Evidence Continuity - Making the Data Make Sense (to everybody)
  2. Color Coding - Adding SMS, Combining Data
  3. Mapping Call Data - Showing the relationship between the data, reality and location, Basic Google Earth KML Creation, KML Creator, Google Docs
  4. Gephi - Data Analysis, powerful, simple, and free, Importing Data, Manipulating Data, Combining Data
  5. PowerPoint - Presenting the results in a format everyone can see and believe, Presenting Cell Data in Court and Hearing, Screen Captures, Splash Screen, Linking to Outside Documents