# smumbi5144/jcars_logistics_bi architecture

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

- Interactive diagram: https://gitdiagram.com/smumbi5144/jcars_logistics_bi
- Repository: https://github.com/smumbi5144/jcars_logistics_bi

## Overview

JCars Logistics is a Power BI business-intelligence solution that turns raw vehicle-sale transactions into management reporting. Its documented workflow is to clean and standardize the flat-file data, reshape it into a sales star schema, define DAX measures, and present interactive report pages for performance, revenue, logistics, and customers. The graph preserves the report’s distinct analytical areas and documented interactions. No source excerpts were provided, so implementation details beyond the README are represented at the documented directory level; edges cite the README.

Main entry points: [`dashboard`](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard) (DAX Measures), [`data/Jcars_data.csv`](https://github.com/smumbi5144/jcars_logistics_bi/blob/main/data/Jcars_data.csv) (Vehicle Sales CSV)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_preparation["Data Preparation"]
  node_raw_data["Vehicle Sales CSV<br/>[Jcars_data.csv]"]
  node_power_query["Power Query Cleaning"]
  node_currency["Currency Standardization"]
end

subgraph group_model["Analytics Model"]
  node_star_schema["Sales Star Schema"]
  node_fact_sales[("FactSales")]
  node_dimensions[("Eight Dimensions")]
  node_dax["DAX Measures"]
end

subgraph group_report["Interactive Report"]
  node_interactions["Slicers and Drilldown"]
  node_executive["Executive Dashboard"]
  node_vehicle_branch["Vehicle and Branch"]
  node_sales_leads["SalesRep and Leads"]
  node_revenue_logistics["Revenue and Logistics"]
  node_top_customers["Top Customers"]
end

subgraph group_users["Decision Support"]
end

node_management(("Management"))

node_raw_data -->|"cleans"| node_power_query
node_power_query -->|"standardizes"| node_currency
node_currency -->|"prepares data"| node_star_schema
node_star_schema -->|"defines"| node_fact_sales
node_star_schema -->|"defines"| node_dimensions
node_fact_sales -->|"relates to"| node_dimensions
node_fact_sales -->|"measures"| node_dax
node_interactions -->|"filters"| node_executive
node_interactions -->|"drills down"| node_vehicle_branch
node_interactions -->|"cross-filters"| node_sales_leads
node_interactions -->|"cross-filters"| node_revenue_logistics
node_interactions -->|"cross-filters"| node_top_customers
node_dax -->|"provides KPIs"| node_executive
node_dax -->|"provides measures"| node_vehicle_branch
node_dax -->|"provides measures"| node_sales_leads
node_dax -->|"provides measures"| node_revenue_logistics
node_dax -->|"provides measures"| node_top_customers
node_executive -->|"supports decisions"| node_management
node_vehicle_branch -->|"supports decisions"| node_management
node_sales_leads -->|"supports decisions"| node_management
node_revenue_logistics -->|"supports decisions"| node_management
node_top_customers -->|"supports decisions"| node_management

click node_raw_data "https://github.com/smumbi5144/jcars_logistics_bi/blob/main/data/Jcars_data.csv"
click node_power_query "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_currency "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_star_schema "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_fact_sales "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_dimensions "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_dax "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_interactions "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_executive "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_vehicle_branch "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_sales_leads "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_revenue_logistics "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"
click node_top_customers "https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard"

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_raw_data,node_power_query,node_currency toneBlue
class node_star_schema,node_fact_sales,node_dimensions,node_dax toneAmber
class node_interactions,node_executive,node_vehicle_branch,node_sales_leads,node_revenue_logistics,node_top_customers toneMint
class node_management toneIndigo
```

## Components

### Data Preparation

- [Vehicle Sales CSV](https://github.com/smumbi5144/jcars_logistics_bi/blob/main/data/Jcars_data.csv): `data/Jcars_data.csv`
- [Power Query Cleaning](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [Currency Standardization](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`

### Analytics Model

- [Sales Star Schema](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [FactSales](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [Eight Dimensions](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [DAX Measures](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`

### Interactive Report

- [Slicers and Drilldown](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [Executive Dashboard](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [Vehicle and Branch](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [SalesRep and Leads](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [Revenue and Logistics](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`
- [Top Customers](https://github.com/smumbi5144/jcars_logistics_bi/tree/main/dashboard): `dashboard`

### Other components

- **Management**

## Connections

- Vehicle Sales CSV → Power Query Cleaning: cleans (evidence: `README.md`)
- Power Query Cleaning → Currency Standardization: standardizes (evidence: `README.md`)
- Currency Standardization → Sales Star Schema: prepares data (evidence: `README.md`)
- Sales Star Schema → FactSales: defines (evidence: `README.md`)
- Sales Star Schema → Eight Dimensions: defines (evidence: `README.md`)
- FactSales → Eight Dimensions: relates to (evidence: `README.md`)
- FactSales → DAX Measures: measures (evidence: `README.md`)
- Slicers and Drilldown → Executive Dashboard: filters (evidence: `README.md`)
- Slicers and Drilldown → Vehicle and Branch: drills down (evidence: `README.md`)
- Slicers and Drilldown → SalesRep and Leads: cross-filters (evidence: `README.md`)
- Slicers and Drilldown → Revenue and Logistics: cross-filters (evidence: `README.md`)
- Slicers and Drilldown → Top Customers: cross-filters (evidence: `README.md`)
- DAX Measures → Executive Dashboard: provides KPIs (evidence: `README.md`)
- DAX Measures → Vehicle and Branch: provides measures (evidence: `README.md`)
- DAX Measures → SalesRep and Leads: provides measures (evidence: `README.md`)
- DAX Measures → Revenue and Logistics: provides measures (evidence: `README.md`)
- DAX Measures → Top Customers: provides measures (evidence: `README.md`)
- Executive Dashboard → Management: supports decisions (evidence: `README.md`)
- Vehicle and Branch → Management: supports decisions (evidence: `README.md`)
- SalesRep and Leads → Management: supports decisions (evidence: `README.md`)
- Revenue and Logistics → Management: supports decisions (evidence: `README.md`)
- Top Customers → Management: supports decisions (evidence: `README.md`)
