How thuynh323/sql-olist-e-commerce works
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 Customer growth · Practice 2 - Shipping and on-time delivery rate.ipynb Shipping performance · Practice 3 - Average review score per seller.ipynb Seller reviews · Practice 4 - Payment types and median number of installments.ipynb Payment patterns
Components 10
KPI notebooks
- Customer growth
Practice 1 - Customers growth rate and repeating rate.ipynb - Shipping performance
Practice 2 - Shipping and on-time delivery rate.ipynb - Seller reviews
Practice 3 - Average review score per seller.ipynb - Payment patterns
Practice 4 - Payment types and median number of installments.ipynb - Product revenue
Practice 5 - Products and revenue.ipynb - Merchant conversion
Practice 6 - Merchants conversion rate.ipynb - First order value
Practice 7 - First order and average order value.ipynb
Data assets
- Local Olist database
- CSV datasets
csv data files
Other components
- Notebook user
Connections 21
- 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