How zhanghongqi1/ganxiaopang-agri-data-analysis works
甘小胖 is a reproducible, simulated-data business analytics project spanning livestream commerce, e-commerce, B2B supply, warehousing, delivery, and stores. Its documented workflow generates data, cleans it, loads MySQL, runs five SQL analyses with Pandas cross-checks, then produces figures, an Excel dashboard, and a Markdown report. The graph follows the documented pipeline and sampled script behavior; details of unsampled SQL and scripts are represented only where the README or runner establishes their role.
Main entry points: 05_run_queries.py SQL analysis runner · run_all.py Pipeline runner · 07_make_dashboard.py Dashboard generator · 08_make_report.py Report generator
Components 26
Data pipeline
- Pipeline runner
scripts/run_all.py - Data generator
scripts/01_generate_data.py - Raw CSV data
data/raw - Data cleaner
scripts/02_clean_data.py - Processed CSV data
data/processed - Sample exporter
scripts/04_export_samples.py - Sample CSV data
data/sample
MySQL analytics
- MySQL loader
scripts/03_load_to_mysql.py - Database schema
sql/00_create_database.sql - MySQL database
- Metric views
sql/01_metric_views.sql
Business analysis
- SQL analysis runner
scripts/05_run_queries.py - Category ROI
sql/a_category_roi.sql - User RFM
sql/b_user_rfm.sql - Livestream funnel
sql/c_live_funnel.sql - Supply chain
sql/d_supply_chain.sql - Store profitability
sql/e_store_pnl.sql - Analysis results
logs/analysis_results.json - Analysis tables
data/processed
Analysis deliverables
- Figure generator
scripts/06_make_figures.py - Analysis figures
reports/figures - Dashboard generator
scripts/07_make_dashboard.py - Excel dashboard
dashboard/甘小胖经营分析看板.xlsx - Report generator
scripts/08_make_report.py - Analysis report
reports/甘小胖经营数据分析报告.md
Other components
- Operator
Connections 37
- Operator → Pipeline runner: starts
- Pipeline runner → Data generator: runs
- Pipeline runner → Data cleaner: runs
- Pipeline runner → MySQL loader: runs
- Pipeline runner → Sample exporter: runs
- Pipeline runner → SQL analysis runner: runs
- Pipeline runner → Figure generator: runs
- Pipeline runner → Dashboard generator: runs
- Pipeline runner → Report generator: runs
- Data generator → Raw CSV data: writes
- Data cleaner → Raw CSV data: reads
- Data cleaner → Processed CSV data: writes
- Sample exporter → Raw CSV data: reads
- Sample exporter → Sample CSV data: writes
- MySQL loader → Processed CSV data: loads
- MySQL loader → Database schema: executes
- MySQL loader → MySQL database: creates and loads
- SQL analysis runner → Category ROI: executes
- SQL analysis runner → User RFM: executes
- SQL analysis runner → Livestream funnel: executes
- SQL analysis runner → Supply chain: executes
- SQL analysis runner → Store profitability: executes
- SQL analysis runner → MySQL database: queries
- SQL analysis runner → Metric views: queries
- SQL analysis runner → Analysis tables: writes
- SQL analysis runner → Analysis results: writes
- Figure generator → Analysis results: reads
- Figure generator → Analysis tables: reads
- Figure generator → Analysis figures: writes
- Dashboard generator → Analysis results: reads
- Dashboard generator → Analysis tables: reads
- Dashboard generator → Analysis figures: embeds
- Dashboard generator → Excel dashboard: writes
- Report generator → Analysis results: reads
- Report generator → Analysis tables: reads
- Report generator → Analysis figures: references
- Report generator → Analysis report: writes