How icecold009/ecommerce-customer-analytics works
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 SQLite tables and views · analysis.py Business queries · validation.sql Validation SQL
Components 14
Data ingestion
- CSV loader
load_database.py - SQLite tables and views
load_database.py
Data quality
- Validation SQL
sql/validation.sql - Validation policy
analysis.py
Business analytics
- Business queries
analysis.py - Delivery and review
analysis.py - Category analysis
analysis.py - Revenue reconciliation
analysis.py - RFM segmentation
analysis.py - Cohort retention
analysis.py
Analysis outputs
- Analysis charts
analysis.py - Analysis summary
analysis.py
Other components
- Analyst
- Olist CSV extracts
Connections 22
- Analyst → Olist CSV extracts: provides
README.md - Olist CSV extracts → CSV loader: loads
load_database.py - CSV loader → SQLite tables and views: writes tables and views
load_database.py - CSV loader → Validation SQL: reads checks
load_database.py - Validation policy → Validation SQL: evaluates summary
README.md - Analyst → Validation policy: runs pipeline
README.md - Validation policy → Business queries: gates analysis
README.md - SQLite tables and views → Business queries: queries
analysis.py - SQLite tables and views → Delivery and review: queries
README.md - SQLite tables and views → Category analysis: queries
README.md - SQLite tables and views → Revenue reconciliation: queries
analysis.py - SQLite tables and views → RFM segmentation: queries
README.md - SQLite tables and views → Cohort retention: queries
README.md - Business queries → Analysis charts: contributes metrics
README.md - Delivery and review → Business queries: reports measures
README.md - Category analysis → Business queries: reports measures
README.md - Revenue reconciliation → Analysis summary: records totals
README.md - RFM segmentation → Analysis charts: generates charts
README.md - Cohort retention → Analysis charts: generates heatmap
README.md - Business queries → Analysis summary: records results
README.md - RFM segmentation → Analysis summary: records segments
README.md - Cohort retention → Analysis summary: records retention
README.md