# icecold009/ecommerce-customer-analytics architecture

> Architecture diagram of the GitHub repository icecold009/ecommerce-customer-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/icecold009/ecommerce-customer-analytics
- Repository: https://github.com/icecold009/ecommerce-customer-analytics

## Overview

This is a local-first Olist e-commerce analytics pipeline: an analyst supplies the CSV extracts, which are loaded into SQLite and shaped into raw tables and documented analytical views; validation gates business analysis, which produces metrics, charts, and a summary bundle. The graph preserves the documented revenue, delivery, review, category, RFM, and cohort capabilities. Relationships are limited to those shown in excerpts or stated in the README; unsampled analysis internals are not inferred.

Main entry points: [`load_database.py`](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/load_database.py) (SQLite tables and views), [`analysis.py`](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py) (Business queries), [`sql/validation.sql`](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/sql/validation.sql) (Validation SQL)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingestion["Data ingestion"]
  node_loader["CSV loader<br/>[load_database.py]"]
  node_sqlite[("SQLite tables and views<br/>[load_database.py]")]
end

subgraph group_quality["Data quality"]
  node_validation_sql["Validation SQL<br/>[validation.sql]"]
  node_validation_gate["Validation policy<br/>[analysis.py]"]
end

subgraph group_analytics["Business analytics"]
  node_business_queries["Business queries<br/>[analysis.py]"]
  node_delivery_review["Delivery and review<br/>[analysis.py]"]
  node_category_analysis["Category analysis<br/>[analysis.py]"]
  node_reconciliation["Revenue reconciliation<br/>[analysis.py]"]
  node_rfm["RFM segmentation<br/>[analysis.py]"]
  node_cohort["Cohort retention<br/>[analysis.py]"]
end

subgraph group_reporting["Analysis outputs"]
  node_charts["Analysis charts<br/>[analysis.py]"]
  node_summary["Analysis summary<br/>[analysis.py]"]
end

node_analyst(("Analyst"))
node_olist_csvs["Olist CSV extracts"]

node_analyst -->|"provides"| node_olist_csvs
node_olist_csvs -->|"loads"| node_loader
node_loader -->|"writes tables and views"| node_sqlite
node_loader -->|"reads checks"| node_validation_sql
node_validation_gate -->|"evaluates summary"| node_validation_sql
node_analyst -->|"runs pipeline"| node_validation_gate
node_validation_gate -->|"gates analysis"| node_business_queries
node_sqlite -->|"queries"| node_business_queries
node_sqlite -->|"queries"| node_delivery_review
node_sqlite -->|"queries"| node_category_analysis
node_sqlite -->|"queries"| node_reconciliation
node_sqlite -->|"queries"| node_rfm
node_sqlite -->|"queries"| node_cohort
node_business_queries -->|"contributes metrics"| node_charts
node_delivery_review -->|"reports measures"| node_business_queries
node_category_analysis -->|"reports measures"| node_business_queries
node_reconciliation -->|"records totals"| node_summary
node_rfm -->|"generates charts"| node_charts
node_cohort -->|"generates heatmap"| node_charts
node_business_queries -->|"records results"| node_summary
node_rfm -->|"records segments"| node_summary
node_cohort -->|"records retention"| node_summary

click node_loader "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/load_database.py"
click node_sqlite "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/load_database.py"
click node_validation_sql "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/sql/validation.sql"
click node_validation_gate "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"
click node_business_queries "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"
click node_delivery_review "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"
click node_category_analysis "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"
click node_reconciliation "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"
click node_rfm "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"
click node_cohort "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"
click node_charts "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"
click node_summary "https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py"

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_loader,node_sqlite toneBlue
class node_validation_sql,node_validation_gate toneAmber
class node_business_queries,node_delivery_review,node_category_analysis,node_reconciliation,node_rfm,node_cohort toneMint
class node_charts,node_summary toneRose
class node_analyst,node_olist_csvs toneIndigo
```

## Components

### Data ingestion

- [CSV loader](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/load_database.py): `load_database.py`
- [SQLite tables and views](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/load_database.py): `load_database.py`

### Data quality

- [Validation SQL](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/sql/validation.sql): `sql/validation.sql`
- [Validation policy](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`

### Business analytics

- [Business queries](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`
- [Delivery and review](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`
- [Category analysis](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`
- [Revenue reconciliation](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`
- [RFM segmentation](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`
- [Cohort retention](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`

### Analysis outputs

- [Analysis charts](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`
- [Analysis summary](https://github.com/icecold009/ecommerce-customer-analytics/blob/main/analysis.py): `analysis.py`

### Other components

- **Analyst**
- **Olist CSV extracts**

## Connections

- Analyst → Olist CSV extracts: provides (evidence: `README.md`)
- Olist CSV extracts → CSV loader: loads (evidence: `load_database.py`)
- CSV loader → SQLite tables and views: writes tables and views (evidence: `load_database.py`)
- CSV loader → Validation SQL: reads checks (evidence: `load_database.py`)
- Validation policy → Validation SQL: evaluates summary (evidence: `README.md`)
- Analyst → Validation policy: runs pipeline (evidence: `README.md`)
- Validation policy → Business queries: gates analysis (evidence: `README.md`)
- SQLite tables and views → Business queries: queries (evidence: `analysis.py`)
- SQLite tables and views → Delivery and review: queries (evidence: `README.md`)
- SQLite tables and views → Category analysis: queries (evidence: `README.md`)
- SQLite tables and views → Revenue reconciliation: queries (evidence: `analysis.py`)
- SQLite tables and views → RFM segmentation: queries (evidence: `README.md`)
- SQLite tables and views → Cohort retention: queries (evidence: `README.md`)
- Business queries → Analysis charts: contributes metrics (evidence: `README.md`)
- Delivery and review → Business queries: reports measures (evidence: `README.md`)
- Category analysis → Business queries: reports measures (evidence: `README.md`)
- Revenue reconciliation → Analysis summary: records totals (evidence: `README.md`)
- RFM segmentation → Analysis charts: generates charts (evidence: `README.md`)
- Cohort retention → Analysis charts: generates heatmap (evidence: `README.md`)
- Business queries → Analysis summary: records results (evidence: `README.md`)
- RFM segmentation → Analysis summary: records segments (evidence: `README.md`)
- Cohort retention → Analysis summary: records retention (evidence: `README.md`)
