# m03jam14/visualizethisdata architecture

> Architecture diagram of the GitHub repository m03jam14/visualizethisdata, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-07-15). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/m03jam14/visualizethisdata
- Repository: https://github.com/m03jam14/visualizethisdata

## Overview

##### Project type and purpose
- This is a data‐analytics / BI dashboard project built on the Power BI Desktop/Service platform.
- Purpose: Visually analyze, compare, and forecast robbery incidents across three Canadian provinces (Alberta, Manitoba, Ontario) using multi-source crime data and advanced time-series/statistical models.

##### File structure
- Top-level files:
- README.md – full project description, features, architecture
- Canadian Provincial Robbery Patterns.pdf – supplemental documentation
- Robbery Incidents Study across Alberta, Manitoba and Ontario.pbix – the Power BI report file containing data model, queries, visuals
- No explicit “src” or “backend” code folders—logic is inside the .pbix (Power Query queries, DAX measures).

##### README for additional insights
- ETL pipelines (Power Query) ingest multi‐source provincial and municipal crime data.
- Data model uses DAX measures for forecasting and trend analysis.
- Deployment: published to Power BI Service with scheduled refresh.
- Key external data sources: Alberta Justice DB, Manitoba Justice DB, Ontario Police Records, Statistics Canada.

##### Main components & relationships
a. Data Sources Layer (External Services)
- Alberta Crime DB
- Manitoba Crime DB
- Ontario Crime Systems
- Municipal Police Dept. Records
- Statistics Canada API/Files
b. Ingestion & ETL Layer (Power Query)
- Extract scripts (Power Query queries in .pbix)
- Transform/normalize data (standard schemas for cross-province)
- Load into Power BI Data Model
c. Data Model Layer
- Fact tables: robbery incidents, crime rates, forecasting outputs
- Dimension tables: Date, Province, City, Crime Severity Index
- Relationships (star schema pattern)
d. Analytics Layer
- DAX Measures: time-series forecasts, trend calculations, city rankings
- Calculated columns for crime rates per 100k population
e. Visualization Layer (Power BI Report)
- Temporal trend charts (2014–2022)
- Provincial comparison visuals (maps, bar charts)
- City-level top-5 rankings
- Forecasting plot with confidence intervals
- Interactive filters and drill-downs
f. Deployment & Access
- Power BI Service workspace
- Scheduled data refresh (weekly)
- End users: Law enforcement dashboards, policy analysts

##### Architectural patterns & design principles
- Star Schema for high-performance querying in Power BI
- ETL separation: data ingestion vs. modeling vs. visualization
- Modular DAX design: reusable measures for forecasting & metrics
- Responsive dashboard design for drill-through and cross-filtering

##### Detail level
- You capture each provincial data source as a separate node
- Power BI Desktop (.pbix) as the container for ETL queries, Data Model, and Visuals
- Power BI Service for published reports and scheduled refresh

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Data Sources Layer
    subgraph "Data Sources" 
        direction TB
        A["Alberta Crime DB"]:::db
        B["Manitoba Crime DB"]:::db
        C["Ontario Crime Systems"]:::db
        D["Municipal Police Dept. Records"]:::db
        E["Statistics Canada API/Files"]:::db
    end

    %% Power BI Desktop Container
    subgraph "Power BI Desktop (.pbix)"
        direction TB
        subgraph "Ingestion & ETL (Power Query)"
            ETL["Power Query: Extract & Transform"]:::etl
        end
        subgraph "Data Model"
            Fact["Fact Tables"]:::dm
            Dim["Dimension Tables"]:::dm
            Fact --- Dim
        end
        subgraph "Analytics (DAX Measures)"
            DAX["Time-series Forecasts & Metrics"]:::analytics
        end
        subgraph "Visualization (Report)"
            Viz["Charts & Interactive Dashboard"]:::viz
        end
    end

    %% Deployment Layer
    subgraph "Deployment & Access"
        Service["Power BI Service Workspace"]:::service
    end

    %% Documentation
    subgraph "Project Documentation"
        README["README.md"]:::doc
        PDF["Canadian Provincial Robbery Patterns.pdf"]:::doc
        License["LICENSE"]:::doc
    end

    %% Data Flows
    A -->|Extract| ETL
    B -->|Extract| ETL
    C -->|Extract| ETL
    D -->|Extract| ETL
    E -->|Extract| ETL

    ETL -->|Load| Fact
    ETL -->|Load| Dim

    Fact -->|Query| DAX
    Dim -->|Query| DAX

    DAX -->|Render| Viz

    Viz -->|Publish| Service
    Service -->|Scheduled Refresh| ETL

    %% Click Events for Component Mappings
    click ETL "https://github.com/m03jam14/visualizethisdata/blob/main/Robbery Incidents Study across Alberta, Manitoba and Ontario.pbix"
    click Fact "https://github.com/m03jam14/visualizethisdata/blob/main/Robbery Incidents Study across Alberta, Manitoba and Ontario.pbix"
    click Dim "https://github.com/m03jam14/visualizethisdata/blob/main/Robbery Incidents Study across Alberta, Manitoba and Ontario.pbix"
    click DAX "https://github.com/m03jam14/visualizethisdata/blob/main/Robbery Incidents Study across Alberta, Manitoba and Ontario.pbix"
    click Viz "https://github.com/m03jam14/visualizethisdata/blob/main/Robbery Incidents Study across Alberta, Manitoba and Ontario.pbix"
    click README "https://github.com/m03jam14/visualizethisdata/blob/main/README.md"
    click PDF "https://github.com/m03jam14/visualizethisdata/blob/main/Canadian Provincial Robbery Patterns.pdf"
    click License "https://github.com/m03jam14/visualizethisdata/tree/main/LICENSE"

    %% Styles
    classDef db fill:#ADD8E6,stroke:#000,stroke-width:1px
    classDef etl fill:#98FB98,stroke:#000,stroke-width:1px
    classDef dm fill:#90EE90,stroke:#000,stroke-width:1px
    classDef analytics fill:#FFA500,stroke:#000,stroke-width:1px
    classDef viz fill:#DA70D6,stroke:#000,stroke-width:1px
    classDef service fill:#DDA0DD,stroke:#000,stroke-width:1px
    classDef doc fill:#F5F5F5,stroke:#333,stroke-width:1px
```
