This course provides hands-on training in the core technical skills used by modern crime analysts to extract, analyze, and present actionable intelligence. Students will develop proficiency in Structured Query Language (SQL) to query law enforcement databases, apply advanced Excel functions for data cleaning and analysis, and build dynamic dashboards in Power BI. The course also covers the creation of paginated reports for professional-grade outputs and introduces link analysis techniques to visualize and interpret relationships in investigative data. Emphasis is placed on real-world applications and workflows used in police departments and criminal justice agencies.
This is a career-focused course designed to equip students with the hard skills needed for real-world jobs as crime analysts. Rather than relying on theory or abstract discussions, students will work with realistic data sets and build practical products similar to those used by working professionals in law enforcement and intelligence roles. By the end of the course, students will be prepared to step into analyst positions with a competitive technical toolkit and the confidence to tackle common challenges faced in the field.
Throughout the course, students will complete practical exercises designed to simulate tasks performed by crime analysts on the job, including querying RMS data, summarizing trends for command staff, and generating case support visuals for investigators. The course also emphasizes technical precision, data integrity, and clear communication of analytical findings. Whether students are preparing for entry-level roles or seeking to modernize their current workflows, this course delivers the essential, job-ready technical competencies needed to thrive in today’s data-driven public safety environment.
- Beginner Crime Analysts!
