# astroyash143/los-angeles-crime-analytics architecture

> Architecture diagram of the GitHub repository astroyash143/los-angeles-crime-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/astroyash143/los-angeles-crime-analytics
- Repository: https://github.com/astroyash143/los-angeles-crime-analytics

## Overview

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`](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix) (Interactive Report), [`Cleaned Dataset/cleaned crime data 2020-24.xlsx`](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Cleaned%20Dataset/cleaned%20crime%20data%202020-24.xlsx) (Cleaned Dataset)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Crime Data"]
  node_dataset[("Cleaned Dataset")]
end

subgraph group_analytics["Power BI Analysis"]
  node_powerquery["Power Query"]
  node_dax["DAX Measures"]
end

subgraph group_exploration["Dashboard Exploration"]
  node_report["Interactive Report"]
  node_time["Crime Trends"]
  node_geography["Geographic Patterns"]
  node_crime["Crime Categories"]
  node_victims["Victim Demographics"]
  node_delays["Reporting Delays"]
  node_cases["Case Status"]
  node_quality["Data Quality"]
end

node_user(("Dashboard User"))

node_dataset -->|"transforms"| node_powerquery
node_powerquery -->|"prepares data"| node_report
node_dax -->|"provides measures"| node_report
node_user -->|"explores"| node_report
node_report -->|"shows trends"| node_time
node_report -->|"shows patterns"| node_geography
node_report -->|"shows categories"| node_crime
node_report -->|"shows demographics"| node_victims
node_report -->|"shows delays"| node_delays
node_report -->|"shows status"| node_cases
node_report -->|"shows quality"| node_quality

click node_dataset "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Cleaned%20Dataset/cleaned%20crime%20data%202020-24.xlsx"
click node_powerquery "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_dax "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_report "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_time "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_geography "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_crime "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_victims "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_delays "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_cases "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"
click node_quality "https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_dataset,node_user toneBlue
class node_powerquery,node_dax toneAmber
class node_report,node_time,node_geography,node_crime,node_victims,node_delays,node_cases,node_quality toneMint
```

## Components

### Crime Data

- [Cleaned Dataset](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Cleaned%20Dataset/cleaned%20crime%20data%202020-24.xlsx): `Cleaned Dataset/cleaned crime data 2020-24.xlsx`

### Power BI Analysis

- [Power Query](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`
- [DAX Measures](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`

### Dashboard Exploration

- [Interactive Report](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`
- [Crime Trends](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`
- [Geographic Patterns](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`
- [Crime Categories](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`
- [Victim Demographics](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`
- [Reporting Delays](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`
- [Case Status](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`
- [Data Quality](https://github.com/astroyash143/los-angeles-crime-analytics/blob/main/Los_Angeles_Crime_Analytics.pbix): `Los_Angeles_Crime_Analytics.pbix`

### Other components

- **Dashboard User**

## Connections

- Cleaned Dataset → Power Query: transforms (evidence: `README.md`)
- Power Query → Interactive Report: prepares data (evidence: `README.md`)
- DAX Measures → Interactive Report: provides measures (evidence: `README.md`)
- Dashboard User → Interactive Report: explores (evidence: `README.md`)
- Interactive Report → Crime Trends: shows trends (evidence: `README.md`)
- Interactive Report → Geographic Patterns: shows patterns (evidence: `README.md`)
- Interactive Report → Crime Categories: shows categories (evidence: `README.md`)
- Interactive Report → Victim Demographics: shows demographics (evidence: `README.md`)
- Interactive Report → Reporting Delays: shows delays (evidence: `README.md`)
- Interactive Report → Case Status: shows status (evidence: `README.md`)
- Interactive Report → Data Quality: shows quality (evidence: `README.md`)
