How trantanphat0811/e--commerce-sales works
This repository is an end-to-end e-commerce sales analysis project. Its user-to-result workflow prepares sales data, analyzes business performance with SQL and Python, then presents findings in a Power BI dashboard. The map preserves the documented SQL analysis areas and Python capabilities, including statistical tests, order segmentation, forecasting, and predictive modeling. The README documents the workflow; Python implementation evidence is sampled from analysis_script.py, while notebook and dashboard internals were not sampled.
Main entry points: Ecommerce_Sales_Cleaned.csv Cleaned sales data · Data_Cleaning.ipynb Data cleaning · E- Commerce Sales.pbix Power BI dashboard · analysis_script.py Order segmentation
Components 15
Data preparation
- Sales source data
data/Ecommerce_Sales_Data_2024_2025.csv - Data cleaning
00_Cleaning/Data_Cleaning.ipynb - Cleaned sales data
data/Ecommerce_Sales_Cleaned.csv
SQL analysis
- Overview analysis
01_SQL/01_Tong_Quan_Du_Lieu.ipynb - Time analysis
01_SQL/02_Phan_Tich_Thoi_Gian.ipynb - Geography analysis
01_SQL/03_Phan_Tich_Dia_Ly.ipynb - Category analysis
01_SQL/04_Phan_Tich_Category.ipynb - Payment and customers
01_SQL/05_Phan_Tich_Payment_KhachHang.ipynb
Python analysis
- EDA and tests
02_Python/analysis_script.py - Order segmentation
02_Python/analysis_script.py - Sales forecasting
02_Python/analysis_script.py - Margin modeling
02_Python/analysis_script.py - Segmented sales data
data/Ecommerce_Sales_with_Segments.csv
Decision dashboard
- Power BI dashboard
03_PowerBI/E- Commerce Sales.pbix
Other components
- Analyst
Connections 16
- Analyst → Data cleaning: prepares data
README.md - Sales source data → Data cleaning: cleaned into
README.md - Data cleaning → Cleaned sales data: produces
README.md - Analyst → Overview analysis: queries KPIs
README.md - Analyst → Time analysis: examines trends
README.md - Analyst → Geography analysis: compares regions
README.md - Analyst → Category analysis: compares categories
README.md - Analyst → Payment and customers: examines customers
README.md - Cleaned sales data → EDA and tests: analyzed by
README.md - Cleaned sales data → Order segmentation: clustered by order
README.md - Cleaned sales data → Sales forecasting: feeds forecast
README.md - Cleaned sales data → Margin modeling: models margin
README.md - Order segmentation → Segmented sales data: exports segments
README.md - Cleaned sales data → Power BI dashboard: visualized in
README.md - Segmented sales data → Power BI dashboard: supplies segments
README.md - Analyst → Power BI dashboard: reviews insights
README.md