# thuynh323/sql-olist-e-commerce architecture

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

- Interactive diagram: https://gitdiagram.com/thuynh323/sql-olist-e-commerce
- Repository: https://github.com/thuynh323/sql-olist-e-commerce

## Overview

This repository is a set of SQL-practice notebooks for retrieving Olist e-commerce data and calculating KPIs. The workflow is: a user runs a topic-specific notebook, it queries the Olist database on the author’s local desktop, and the notebook presents the result. The seven topics cover customer growth and repeat rates, shipping, seller reviews, payments, products and revenue, merchant conversion, and first orders and order value. The CSV files are documented as data assets, but the README does not establish that the notebooks load or query those copies; notebook internals were not available for inspection.

Main entry points: [`Practice 1 - Customers growth rate and repeating rate.ipynb`](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%201%20-%20Customers%20growth%20rate%20and%20repeating%20rate.ipynb) (Customer growth), [`Practice 2 - Shipping and on-time delivery rate.ipynb`](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%202%20-%20Shipping%20and%20on-time%20delivery%20rate.ipynb) (Shipping performance), [`Practice 3 - Average review score per seller.ipynb`](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%203%20-%20Average%20review%20score%20per%20seller.ipynb) (Seller reviews), [`Practice 4 - Payment types and median number of installments.ipynb`](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%204%20-%20Payment%20types%20and%20median%20number%20of%20installments.ipynb) (Payment patterns)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_notebooks["KPI notebooks"]
  node_customers["Customer growth"]
  node_shipping["Shipping performance"]
  node_reviews["Seller reviews"]
  node_payments["Payment patterns"]
  node_products["Product revenue"]
  node_conversion["Merchant conversion"]
  node_orders["First order value"]
end

subgraph group_data["Data assets"]
  node_database[("Local Olist database")]
  node_csv["CSV datasets"]
end

node_user(("Notebook user"))

node_user -->|"runs"| node_customers
node_user -->|"runs"| node_shipping
node_user -->|"runs"| node_reviews
node_user -->|"runs"| node_payments
node_user -->|"runs"| node_products
node_user -->|"runs"| node_conversion
node_user -->|"runs"| node_orders
node_customers -->|"queries"| node_database
node_shipping -->|"queries"| node_database
node_reviews -->|"queries"| node_database
node_payments -->|"queries"| node_database
node_products -->|"queries"| node_database
node_conversion -->|"queries"| node_database
node_orders -->|"queries"| node_database
node_customers -->|"presents KPI"| node_user
node_shipping -->|"presents KPI"| node_user
node_reviews -->|"presents KPI"| node_user
node_payments -->|"presents KPI"| node_user
node_products -->|"presents KPI"| node_user
node_conversion -->|"presents KPI"| node_user
node_orders -->|"presents KPI"| node_user

click node_customers "https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%201%20-%20Customers%20growth%20rate%20and%20repeating%20rate.ipynb"
click node_shipping "https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%202%20-%20Shipping%20and%20on-time%20delivery%20rate.ipynb"
click node_reviews "https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%203%20-%20Average%20review%20score%20per%20seller.ipynb"
click node_payments "https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%204%20-%20Payment%20types%20and%20median%20number%20of%20installments.ipynb"
click node_products "https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%205%20-%20Products%20and%20revenue.ipynb"
click node_conversion "https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%206%20-%20Merchants%20conversion%20rate.ipynb"
click node_orders "https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%207%20-%20First%20order%20and%20average%20order%20value.ipynb"
click node_csv "https://github.com/thuynh323/sql-olist-e-commerce/tree/master/csv%20data%20files"

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_customers,node_shipping,node_reviews,node_payments,node_products,node_conversion,node_orders,node_user toneBlue
class node_database,node_csv toneAmber
```

## Components

### KPI notebooks

- [Customer growth](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%201%20-%20Customers%20growth%20rate%20and%20repeating%20rate.ipynb): `Practice 1 - Customers growth rate and repeating rate.ipynb`
- [Shipping performance](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%202%20-%20Shipping%20and%20on-time%20delivery%20rate.ipynb): `Practice 2 - Shipping and on-time delivery rate.ipynb`
- [Seller reviews](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%203%20-%20Average%20review%20score%20per%20seller.ipynb): `Practice 3 - Average review score per seller.ipynb`
- [Payment patterns](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%204%20-%20Payment%20types%20and%20median%20number%20of%20installments.ipynb): `Practice 4 - Payment types and median number of installments.ipynb`
- [Product revenue](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%205%20-%20Products%20and%20revenue.ipynb): `Practice 5 - Products and revenue.ipynb`
- [Merchant conversion](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%206%20-%20Merchants%20conversion%20rate.ipynb): `Practice 6 - Merchants conversion rate.ipynb`
- [First order value](https://github.com/thuynh323/sql-olist-e-commerce/blob/master/Practice%207%20-%20First%20order%20and%20average%20order%20value.ipynb): `Practice 7 - First order and average order value.ipynb`

### Data assets

- **Local Olist database**
- [CSV datasets](https://github.com/thuynh323/sql-olist-e-commerce/tree/master/csv%20data%20files): `csv data files`

### Other components

- **Notebook user**

## Connections

- Notebook user → Customer growth: runs
- Notebook user → Shipping performance: runs
- Notebook user → Seller reviews: runs
- Notebook user → Payment patterns: runs
- Notebook user → Product revenue: runs
- Notebook user → Merchant conversion: runs
- Notebook user → First order value: runs
- Customer growth → Local Olist database: queries
- Shipping performance → Local Olist database: queries
- Seller reviews → Local Olist database: queries
- Payment patterns → Local Olist database: queries
- Product revenue → Local Olist database: queries
- Merchant conversion → Local Olist database: queries
- First order value → Local Olist database: queries
- Customer growth → Notebook user: presents KPI
- Shipping performance → Notebook user: presents KPI
- Seller reviews → Notebook user: presents KPI
- Payment patterns → Notebook user: presents KPI
- Product revenue → Notebook user: presents KPI
- Merchant conversion → Notebook user: presents KPI
- First order value → Notebook user: presents KPI