# shazia786715/quick-commerce-sql-analytics architecture

> Architecture diagram of the GitHub repository shazia786715/quick-commerce-sql-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-16). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/shazia786715/quick-commerce-sql-analytics
- Repository: https://github.com/shazia786715/quick-commerce-sql-analytics

## Overview

This is a MySQL 8.0 quick-commerce analytics project: an analyst loads the warehouse dataset, then runs independent SQL analyses that turn shared data into business findings. The analyses cover order funnel and delivery SLA, customer retention, SKU profitability, rider utilisation, and acquisition economics with referral chains. The README documents the dataset and each module’s purpose, but no SQL excerpts were provided, so query-level joins and internal execution details are not represented.

Main entry points: [`mysql_quickcommerce.sql`](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/mysql_quickcommerce.sql) (Quick-commerce warehouse), [`01_order_funnel_sla.sql`](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/01_order_funnel_sla.sql) (Order funnel and SLA), [`04_rider_utilisation.sql`](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/04_rider_utilisation.sql) (Rider utilisation), [`03_sku_profitability_pareto.sql`](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/03_sku_profitability_pareto.sql) (SKU profitability)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_warehouse["Warehouse"]
  node_dataset[("Quick-commerce warehouse")]
end

subgraph group_operations["Operations Analytics"]
  node_funnel["Order funnel and SLA"]
  node_riders["Rider utilisation"]
  node_sku["SKU profitability"]
end

subgraph group_growth["Customer and Growth Analytics"]
  node_retention["Cohort retention"]
  node_acquisition["CAC, LTV and referrals"]
end

node_analyst(("Analyst"))

node_analyst -->|"loads schema and data"| node_dataset
node_analyst -->|"runs analysis"| node_funnel
node_analyst -->|"runs analysis"| node_riders
node_analyst -->|"runs analysis"| node_sku
node_analyst -->|"runs analysis"| node_retention
node_analyst -->|"runs analysis"| node_acquisition
node_dataset -->|"provides shared tables"| node_funnel
node_dataset -->|"provides shared tables"| node_riders
node_dataset -->|"provides shared tables"| node_sku
node_dataset -->|"provides shared tables"| node_retention
node_dataset -->|"provides shared tables"| node_acquisition

click node_dataset "https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/mysql_quickcommerce.sql"
click node_funnel "https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/01_order_funnel_sla.sql"
click node_riders "https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/04_rider_utilisation.sql"
click node_sku "https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/03_sku_profitability_pareto.sql"
click node_retention "https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/02_cohort_retention.sql"
click node_acquisition "https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/05_growth_cac_ltv_referrals.sql"

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 toneBlue
class node_funnel,node_riders,node_sku toneAmber
class node_retention,node_acquisition toneMint
class node_analyst toneIndigo
```

## Components

### Warehouse

- [Quick-commerce warehouse](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/mysql_quickcommerce.sql): `mysql_quickcommerce.sql`

### Operations Analytics

- [Order funnel and SLA](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/01_order_funnel_sla.sql): `01_order_funnel_sla.sql`
- [Rider utilisation](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/04_rider_utilisation.sql): `04_rider_utilisation.sql`
- [SKU profitability](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/03_sku_profitability_pareto.sql): `03_sku_profitability_pareto.sql`

### Customer and Growth Analytics

- [Cohort retention](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/02_cohort_retention.sql): `02_cohort_retention.sql`
- [CAC, LTV and referrals](https://github.com/shazia786715/quick-commerce-sql-analytics/blob/main/05_growth_cac_ltv_referrals.sql): `05_growth_cac_ltv_referrals.sql`

### Other components

- **Analyst**

## Connections

- Analyst → Quick-commerce warehouse: loads schema and data (evidence: `README.md`)
- Analyst → Order funnel and SLA: runs analysis (evidence: `README.md`)
- Analyst → Rider utilisation: runs analysis (evidence: `README.md`)
- Analyst → SKU profitability: runs analysis (evidence: `README.md`)
- Analyst → Cohort retention: runs analysis (evidence: `README.md`)
- Analyst → CAC, LTV and referrals: runs analysis (evidence: `README.md`)
- Quick-commerce warehouse → Order funnel and SLA: provides shared tables (evidence: `README.md`)
- Quick-commerce warehouse → Rider utilisation: provides shared tables (evidence: `README.md`)
- Quick-commerce warehouse → SKU profitability: provides shared tables (evidence: `README.md`)
- Quick-commerce warehouse → Cohort retention: provides shared tables (evidence: `README.md`)
- Quick-commerce warehouse → CAC, LTV and referrals: provides shared tables (evidence: `README.md`)
