Power Bi For Crime Analysts

Analyze RMS and CAD data easily with Power BI

What you'll learn

Connect Power BI to common police data sources, including Records Management Systems (RMS) and Computer Assisted Dispatch (CAD)

Create Basic Visualizations in Power BI

Model data to create multidimmensional dashboards

Use AI to write DAX statements to create additional data structures

Requirements

No programming experience needed

Description

This comprehensive course is your ultimate guide to mastering Power BI, tailored specifically for professionals in law enforcement and public safety. Unlike other courses that focus on generic business data, this course is uniquely designed to help you understand and work with data structures commonly found in state and local police departments.Focusing on key datasets such as CAD (Computer-Aided Dispatch) and RMS (Records Management System) data, you’ll learn how to clean, transform, and analyze these complex datasets to generate actionable insights. Whether you're a beginner or looking to advance your skills, this course will equip you with the tools and techniques necessary to create powerful visualizations used in modern crime analysis workflows.Key topics include: Crime Maps and Geospatial Analysis: Learn how to create detailed crime maps using Power BI’s integration with GIS tools, providing spatial insights essential for understanding crime patterns and trends.COMPSTAT Dashboards: Build dynamic visualizations for tracking crime statistics, highlighting year-over-year trends, and supporting COMPSTAT meetings with clear, actionable data.Problem-Oriented Policing Support: Develop visuals that pinpoint hotspots, identify root causes of recurring issues, and monitor the success of problem-oriented interventions.Intelligence-Led Policing Tools: Use Power BI to visualize data that supports intelligence-driven strategies, including linking offenders, locations, and offenses for better resource allocation.Stratified Policing Visualizations: Design reports and dashboards that align with the levels of analysis required in stratified policing frameworks, from tactical to strategic assessments.What you'll learn:Data preparation: Transform CAD and RMS data into clean, usable formats.Crime trend analysis: Visualize patterns in time and geography to identify actionable insights.Spatial analysis: Integrate geospatial tools to map offenses, calls for service, and officer activity.Custom visualizations: Create heat maps, bar charts, scatter plots, and other visuals tailored to law enforcement workflows.Advanced dashboards: Combine visualizations into interactive dashboards for operational, tactical, and strategic crime analysis.This course is ideal for crime analysts, law enforcement officers, and public safety professionals looking to enhance their data analysis capabilities. By the end of the course, you’ll be able to build robust Power BI dashboards and reports that drive informed decision-making and directly support initiatives like COMPSTAT, problem-oriented policing, intelligence-led policing, and stratified policing.Don’t miss the opportunity to revolutionize how you analyze and present crime data—enroll today and start building insights that make your community safer.

Overview

Section 1: Introduction

Lecture 1 Introduction to the course

Lecture 2 Course Materials

Lecture 3 Our end product

Section 2: Section 2: Getting Started

Lecture 4 Connecting to Excel Data

Lecture 5 Other Data Sources

Section 3: Common Data Visualizations in PowerBI

Lecture 6 Text and Pictures

Lecture 7 Cards

Lecture 8 Slicers

Lecture 9 Pie & Ring Graphs

Lecture 10 Bar Graphs

Lecture 11 Matrices

Lecture 12 Line Charts

Lecture 13 Maps: Lat/Long

Lecture 14 My maps won't work! What to do with no mapping permissions

Lecture 15 Maps: Addresses

Lecture 16 Improving address mapping for small jurisdictions

Lecture 17 Maps: ESRI Maps

Lecture 18 Additional Visualizations

Section 4: Introduction to DAX Functions

Lecture 19 Line Graph V2- Year Function

Lecture 20 Grouping NIBRS Offenses using ChatGPT

Section 5: Custom Tooltips

Lecture 21 A dashboard within a dashboard

Lecture 22 Customizing Tooltips - 1

Lecture 23 Customizing Tooltips - 2 Maps

Section 6: Data Modeling

Lecture 24 Introduction to relational databases

Lecture 25 Data Modeling 101

Lecture 26 Filtering CAD + RMS Simultaneously - Zones

Lecture 27 Filtering CAD + RMS Simultaneously - Dates

Lecture 28 Filter CAD + RMS Simultaneously- Officer Names

Lecture 29 Day of Week/ Hour of Day Heat Map - What not to do

Lecture 30 Day of Week / Hour of Day Heat Maps- What to do

Section 7: Measures

Lecture 31 What is a measure?

Lecture 32 Previous 28, 90, YTD Counts

Lecture 33 Formatting your COMPSTAT table

Section 8: Bookmarks and Buttons

Lecture 34 Bookmarks

Lecture 35 Buttons

Section 9: Sharing

Lecture 36 Mobile layouts & Azure

Section 10: Student Scenarios

Lecture 37 Come back with your questions!

Lecture 38 Mapping two layers simultaneously

Crime analysts looking to learn Power BI to improve day-to-day operations within their department