Power BI Advanced for Public Safety Agencies
Data holds immense potential as a transformative tool in the dynamic world of criminal justice. It provides valuable insights that can enhance public safety and improve overall community welfare. However, harnessing the true power of data requires more than just an understanding of its significance. It demands proficiency in utilizing the right tools. That's where Power BI Advanced for Public Safety Agencies comes in.
This advanced course takes a hands-on approach, immersing law enforcement professionals in practical exercises that unlock the capabilities of the free Microsoft Power BI Desktop software. Specifically tailored to aid criminal justice practitioners, commanders, managers, officers, and analysts, this course equips participants with the expertise they need to comprehend and present data for both internal agency usage and external community consumption.
Throughout the course, you'll embark on a transformative journey, mastering the advanced features of Microsoft Power BI Desktop. This expertise will enable you to elevate data visualizations, intelligence analysis, threat identification, and risk communications to new heights. It's not just about presenting data—it's about converting it into actionable intelligence that has the potential to profoundly impact law enforcement operations and outcomes.
We believe in learning by doing. That's why this course emphasizes a hands-on approach, empowering you to immediately apply your newfound knowledge. Through practical exercises, you'll gain proficiency in transforming raw data into visually compelling and interactive representations. These dynamic visualizations enhance your ability to analyze complex datasets, identify patterns, and uncover hotspots, contributing to proactive policing and optimized resource allocation.
The course delves into the art of effective communication through data-driven presentations and reports. You'll learn how to craft compelling narratives, communicate risks, statistics, and findings to both internal stakeholders and the wider community. By leveraging Power BI Desktop, you'll create impactful reports that facilitate informed decision-making, foster transparency, and enhance public trust in law enforcement agencies.
By investing in your professional growth through this course, you'll unlock the full potential of Power BI Desktop for law enforcement agencies. Gain specialized expertise in data analysis and visualization, equipping yourself with the tools to make data-driven decisions that significantly improve public safety. Furthermore, you'll have the opportunity to network and collaborate with like-minded professionals, expanding your knowledge and sharing best practices.
Harness the power of Microsoft Power BI Desktop, elevate your data skills, become a catalyst for positive change in law enforcement operations, and let's transform data into actionable intelligence for safer and more secure communities.
Course Details
- Level: Advanced
- Recommended Background: Attendees should have completed one or more of the following CJDS courses:
- Leveraging Call Detail Records for Criminal Investigations
- Power BI Basics for Law Enforcement Agencies
- Using Data to Solve Crime Within Criminal Investigations
- Crime Analysis Fundamentals Using Data Driven Modalities
- Or have a strong working knowledge of Microsoft Power BI Desktop and Windows computers.
- Prerequisites: Must have Microsoft Power BI Desktop installed prior to the first day of class.
- Technology Requirements: Students must bring a Windows laptop (personal or employer-issued). Host agency does not provide devices.
- Additional Requirements: A Power BI Pro, G5, or E5 license assigned by the agency is required for access to the Power BI Cloud Service. Students must bring the required course textbook (see below) at their own expense.
- Duration: 32 Hours (4 Days)
- Method: In Person
- Restrictions: Open only to criminal justice employees in Full or Light Duty status.
- Disclosures: None
- Fee: Course is free, but students are responsible for material costs.
- Cancellation Policy: If fewer than 50% of seats are filled 72 hours before the course start date, the instructor may cancel the course.
Course Objectives
After successfully completing the course, attendees will be able to:
- Use multidimensional data models to convey complex criminal justice information
- Explore various SQL server data connections
- Discuss ethics within criminal justice data visualizations
- Apply data cardinality within data models
- Use advanced bookmarks and Z ordering to build dynamic slicers, cards, and visuals
- Identify and avoid Type I and Type II errors in visualizations
- Apply dashboard themes, colors, and custom imagery
- Use M Code as a secondary data source
- Understand and utilize the Microsoft Power BI Web Service:
- Workspaces
- Gateways
- Dashboard Refresh Scheduling
Course Outline
Module 1
- Introduction and Class Structure
- Connections into SQL Servers
- Planning Power BI Reports
- Report Planning Process
- Identify the Audience
- Define the Question
- Confirm Data Supports Questions
- Determine Interactivity
- Define Access and Distribution
- Report Architecture Diagram
- Visualization Best Practices
- Clutter, Simple, Position, Soft, Backgrounds, Common Design, Selections
- Visualization Anti-Patterns
- Data Modeling and Star Schema
- Relationships
- Unidirectional / Bidirectional
- Ambiguity / Shared Dimensions
- M-Query Master Date Creation
- Data Source Settings and Binning
- Hands-on Module 1 Project
Module 2
- Workspaces and Data Gateways
- Dashboard Publication and Data Refresh
- Scheduled Refresh and Email Subscriptions
- Website Integration (iFrame)
- DAX Measures Introduction
- Security Overview (CJIS Requirements)
- Hands-on Module 2 Project
Module 3
- Advanced Analytics
- AI Visuals, Key Influencers, Decomposition Tree, Q&A, Smart Narrative
- R and Python Visuals
- Microsoft Visual Studio Code Integration
- DAX Calendar Auto Statements
- Style Templates and Individual Agency Dashboards
Required Text
 |
Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition Authors: Greg Deckler, Brett Powell, Leon Gordon |