Reading about pattern analysis only takes you so far. At some point you have to load the incidents and go find the series yourself.
The exercises below use MICHAEL (Machine Intelligence Complementing Human Analysts on Every Lead), a crime and intelligence analysis workstation from my company, BAIR Systems. So yes, weigh my opinion of it accordingly. It runs on your own Windows computer, works with no internet connection, and comes with a free trial. Request one and the download link comes by email.
Two files with the same structure, built for teaching. Every person, phone number and plate in them is invented (the phones all use the reserved 555 prefix), and there are no photographs. Street names are real Phoenix arterials with made-up block numbers.
The patterns in them were planted on purpose: crews, a series, a fence, an offender's anchor point, and a few data problems. That means there is a right answer to find, and the tool doesn't get the last word. Import either file into MICHAEL as a CSV.
69 records, four crews. Small enough to put on a screen and trace every link by eye. Start here.
michael-teaching-set.csv (18 KB)828 records, the same kinds of structure, many more crews. Too big to eyeball; you'll need the tools. Try it on your own once the teaching set makes sense.
michael-practice-set.csv (210 KB)Each one goes with a chapter. They tell you what to find, not which buttons to press; the software changes faster than the book does, and figuring out how to ask the question is half the job. Work them in this order if you can. Instructors can request the answers (see below).
Load the teaching set and look at it before you analyze anything.
Build a network from the teaching set, linking cases that share a suspect, a vehicle or a phone.
The network from Exercise 2 links cases through people and things. Some series only show up in how the crime was done.
One suspect in the teaching set appears on nothing but a run of residential burglaries.
Chapter 2 mentions Kim Rossmo's work on geographic profiling. One crew in the teaching set was built around a hidden anchor point.
Run a chi-square test twice on the teaching set.
Load the practice set and repeat Exercises 1 to 7 without the training wheels. Then one more:
This one doesn't use the files above. Open the patrol workload view and load the sample dispatch extract that comes with MICHAEL.
If you adopt A.I. in Policing for a course, I can set your class up with MICHAEL licenses. I can also send the answer key for these exercises. It is generated from the same script that planted the findings, so it always matches the data, and it includes a suggested 90-minute session plan.
Chapter 21 is about teaching technology so it sticks. For these exercises, my advice is simple: teach on the small set, where nobody has to take the tool's word for anything, and then hand out the big one.
Free guides on this site that go with the book. The full list of outside tools, training and organizations is in Appendix C.