How shazia786715/quick-commerce-sql-analytics works
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 Quick-commerce warehouse · 01_order_funnel_sla.sql Order funnel and SLA · 04_rider_utilisation.sql Rider utilisation · 03_sku_profitability_pareto.sql SKU profitability
Components 7
Warehouse
- Quick-commerce warehouse
mysql_quickcommerce.sql
Operations Analytics
- Order funnel and SLA
01_order_funnel_sla.sql - Rider utilisation
04_rider_utilisation.sql - SKU profitability
03_sku_profitability_pareto.sql
Customer and Growth Analytics
- Cohort retention
02_cohort_retention.sql - CAC, LTV and referrals
05_growth_cac_ltv_referrals.sql
Other components
- Analyst
Connections 11
- Analyst → Quick-commerce warehouse: loads schema and data
README.md - Analyst → Order funnel and SLA: runs analysis
README.md - Analyst → Rider utilisation: runs analysis
README.md - Analyst → SKU profitability: runs analysis
README.md - Analyst → Cohort retention: runs analysis
README.md - Analyst → CAC, LTV and referrals: runs analysis
README.md - Quick-commerce warehouse → Order funnel and SLA: provides shared tables
README.md - Quick-commerce warehouse → Rider utilisation: provides shared tables
README.md - Quick-commerce warehouse → SKU profitability: provides shared tables
README.md - Quick-commerce warehouse → Cohort retention: provides shared tables
README.md - Quick-commerce warehouse → CAC, LTV and referrals: provides shared tables
README.md