How trantanphat0811/globalsuperstore_analysis works
This repository is an end-to-end Global Superstore analytics portfolio: order data is prepared and queried with SQLite, explored through Python analysis, and presented in dashboards. The README documents EDA, discount, RFM, geographic, and forecasting analyses; the tree includes the notebooks and a Streamlit dashboard. The excerpts confirm SQLite ingestion and the Streamlit dashboard’s reads. Other analysis links and Power BI data flows are based on README descriptions, not inspected notebook or dashboard internals.
Main entry points: superstore.db Orders database · charts Analysis charts · 03_PowerBI Power BI dashboard · 03_RFM_Segmentation.ipynb RFM segmentation
Components 18
Data foundation
- Order dataset
data/Global_Superstore2.csv - SQLite ingestion
01_SQL/python/01_import_to_sqlite.py - Orders database
data/superstore.db - RFM results
data/rfm_segments.csv - Geography results
data/geo_summary.csv - Forecast results
data/forecast_result.csv
SQL analysis
- SQL cleaning
01_SQL/01_cleaning.sql - Business queries
01_SQL/02_business_queries.sql - Power BI views
01_SQL/03_views_for_powerbi.sql
Python analysis
- EDA
02_Python/01_EDA.ipynb - Discount analysis
02_Python/02_Discount_Analysis.ipynb - RFM segmentation
02_Python/03_RFM_Segmentation.ipynb - Geographic analysis
02_Python/04_Geo_Analysis.ipynb - Sales forecast
02_Python/05_Forecast.ipynb - Analysis charts
02_Python/charts
Dashboards
- Streamlit dashboard
01_SQL/python/app.py - Power BI dashboard
03_PowerBI
Other components
- Analyst
Connections 25
- Order dataset → SQLite ingestion: provides input
- SQLite ingestion → Orders database: writes orders
01_SQL/python/01_import_to_sqlite.py - Orders database → SQL cleaning: cleans data
README.md - Orders database → Business queries: queries orders
README.md - Orders database → EDA: analyzes data
README.md - Orders database → Discount analysis: analyzes discounts
README.md - Orders database → RFM segmentation: segments customers
README.md - Orders database → Geographic analysis: analyzes regions
README.md - Orders database → Sales forecast: forecasts sales
README.md - RFM segmentation → RFM results: exports segments
README.md - Geographic analysis → Geography results: exports summary
README.md - Sales forecast → Forecast results: exports forecast
README.md - EDA → Analysis charts: produces charts
README.md - Discount analysis → Analysis charts: produces charts
README.md - RFM segmentation → Analysis charts: produces charts
README.md - Geographic analysis → Analysis charts: produces charts
README.md - Sales forecast → Analysis charts: produces charts
README.md - Analyst → Streamlit dashboard: views metrics
01_SQL/python/app.py - Streamlit dashboard → Orders database: reads orders
01_SQL/python/app.py - Streamlit dashboard → RFM results: reads segments
01_SQL/python/app.py - Business queries → Power BI views: feeds views
README.md - Power BI views → Power BI dashboard: provides SQL views
README.md - RFM results → Power BI dashboard: imports segments
README.md - Forecast results → Power BI dashboard: imports forecast
README.md - Analyst → Power BI dashboard: explores dashboards
README.md