How astroyash143/los-angeles-crime-analytics works
This repository packages a Power BI dashboard and its cleaned Los Angeles crime dataset. The documented workflow is to explore the dataset through the interactive report, which presents analysis across time, geography, crime types, victims, reporting delays, case status, and data quality. The README identifies Power Query transformations and DAX measures, but no source excerpts expose the PBIX internals; those internal relationships are therefore limited to what the README documents.
Main entry points: Los_Angeles_Crime_Analytics.pbix Interactive Report · cleaned crime data 2020-24.xlsx Cleaned Dataset
Components 12
Crime Data
- Cleaned Dataset
Cleaned Dataset/cleaned crime data 2020-24.xlsx
Power BI Analysis
- Power Query
Los_Angeles_Crime_Analytics.pbix - DAX Measures
Los_Angeles_Crime_Analytics.pbix
Dashboard Exploration
- Interactive Report
Los_Angeles_Crime_Analytics.pbix - Crime Trends
Los_Angeles_Crime_Analytics.pbix - Geographic Patterns
Los_Angeles_Crime_Analytics.pbix - Crime Categories
Los_Angeles_Crime_Analytics.pbix - Victim Demographics
Los_Angeles_Crime_Analytics.pbix - Reporting Delays
Los_Angeles_Crime_Analytics.pbix - Case Status
Los_Angeles_Crime_Analytics.pbix - Data Quality
Los_Angeles_Crime_Analytics.pbix
Other components
- Dashboard User
Connections 11
- Cleaned Dataset → Power Query: transforms
README.md - Power Query → Interactive Report: prepares data
README.md - DAX Measures → Interactive Report: provides measures
README.md - Dashboard User → Interactive Report: explores
README.md - Interactive Report → Crime Trends: shows trends
README.md - Interactive Report → Geographic Patterns: shows patterns
README.md - Interactive Report → Crime Categories: shows categories
README.md - Interactive Report → Victim Demographics: shows demographics
README.md - Interactive Report → Reporting Delays: shows delays
README.md - Interactive Report → Case Status: shows status
README.md - Interactive Report → Data Quality: shows quality
README.md