Power Class: Using Power Query and Power BI for Crime Analysis 

This 12-week online course introduces students to the foundational tools and techniques used in Microsoft Power Query and Power BI for crime analysis. As agencies increasingly rely on data-driven insights to inform operations and strategy, this course helps analysts develop the practical skills needed to extract, transform, and visualize data from multiple sources into meaningful analytical products.

Throughout the course, students will learn how to clean and structure raw data using Power Query, build relationships and data models, and create interactive dashboards in Power BI that support decision-making. The lessons are designed to help analysts move beyond static reports by developing dynamic, accessible visualizations that communicate actionable insights to law enforcement stakeholders.

Instructor: Stacy Belledin

At a Glance

No textbook is required for this course.

Required Skills

This is an intermediate course. No prior experience with Power Query or Power BI is required; however, students should have a basic understanding of Microsoft Excel and working with structured or relational data.

Upcoming Sessions

Select the session that works best for your schedule. Once a session has passed or is already in progress, registration is disabled.

Note: availability labels are updated manually as seats fill. For the most accurate information, refer to the registration form. If a class does not appear on the form, it should be treated as sold out.

Class Format

Students should expect a time commitment of 3-5 hours per week to gain a passing grade. The course is graded as pass/fail and follows a weekly-structured online format, meaning the class advances through each topic together week by week. The final assignment must be completed to receive a passing grade, as well as at least 80% of the assignments.

Students can log in whenever it fits their schedule, and there are no live sessions. Participation throughout the course is required for a passing grade. As a rule, bulk submissions during the last week of class are not accepted unless prior authorization has been granted by the instructor.

Invitations to the learning platform are sent the weekend before class begins.

Course Outline

This course is organized into 12 weekly modules that introduce the foundations of data extraction, transformation, and visualization, building toward creating structured data models and interactive dashboards that support crime analysis and law enforcement decision-making.

Ready to Enroll?

Choose an upcoming session and complete your registration. If a session fills, students may contact [email protected] to ask about availability, the waitlist, or future offerings.