How yasrdev/e-commerce-sales-analytics works
Project type and purpose
• This is an exploratory data-analysis (EDA) project built as a Jupyter notebook ("Viz.ipynb") that reads an Excel dataset, cleans and aggregates it, then produces visualizations and tables to answer business questions about an e-commerce store’s sales performance.
File structure
• Top level:
• Data_Viz/ (presumably contains the raw Excel file or processed CSVs)
• README.md (project description, objectives, methodology)
• Viz.ipynb (the main analysis notebook)
• No separate “frontend” or “backend” components—everything lives in a single notebook that runs data-pipeline code and visualization code.
README for additional insights
• Describes the columns of the dataset, the key business questions, the steps (cleaning → aggregation → visualization), and the Python libraries used (pandas, matplotlib, seaborn) or external tools (Excel, Tableau).
Main components
a. Data Source
• Excel file (or Google Sheets link) located under Data_Viz/
• External dashboard link (Tableau) as an optional downstream consumer
b. Data Ingestion & Cleaning Module
• Represented by Python/pandas code cells in Viz.ipynb
• Tasks: handle missing values, fix negative quantities, parse dates
c. Transformation & Aggregation Module
• Monthly revenue, product-level summaries, country aggregation, customer aggregation
d. Visualization Module
• matplotlib & seaborn code cells producing charts and tables
e. Reporting & Recommendations
• Final output sections in the notebook, plus optional Tableau dashboard
f. Environment & Dependencies
• Jupyter Notebook environment, Python packages (pandas, matplotlib, seaborn)
Architectural patterns & design principles
• Pipeline/ETL pattern: sequential steps of Extract → Transform → Load (into visual objects)
• Modular code cells in the notebook should map to pipeline stages
• Reproducibility: environment specification (e.g., requirements.txt or conda env), versioned data file
Technologies & libraries
• Python 3.x, Jupyter Notebook
• pandas for data handling
• matplotlib/seaborn for visualizations
• Excel/Google Sheets as raw data source
• Tableau for interactive dashboards (external consumer)
Elements
• Processing modules (rectangles)