# nagavasu7777/ecommerce-sales-analysis architecture

> Architecture diagram of the GitHub repository nagavasu7777/ecommerce-sales-analysis, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-22). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/nagavasu7777/ecommerce-sales-analysis
- Repository: https://github.com/nagavasu7777/ecommerce-sales-analysis

## Overview

This is an e-commerce sales analysis project: transaction data is cleaned and transformed in Python, then presented in an interactive Power BI dashboard. The Python workflow also separates cancellations and returns and derives sales, revenue, date, and customer-analysis data. The README describes dashboard measures and analyses, including revenue, orders, customers, products, quantity, average order value, monthly trends, product performance, and country comparisons. The dashboard’s precise data connection is not shown, so that relationship is documented at workflow level rather than inferred from the PBIX file.

Main entry points: [`project1.py`](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py) (Sales metrics and dates), [`cleaned_sales_data.csv`](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/cleaned_sales_data.csv) (Cleaned sales data), [`online retail sales dashboard.pbix`](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/online%20retail%20sales%20dashboard.pbix) (Interactive dashboard), [`online_retail_II.xlsx`](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/online_retail_II.xlsx) (Retail workbook)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_preparation["Data preparation"]
  node_workbook["Retail workbook"]
  node_cleaning["Clean transactions<br/>[project1.py]"]
end

subgraph group_analysis["Sales analysis"]
  node_classification["Classify transactions<br/>[project1.py]"]
  node_sales_features["Sales metrics and dates<br/>[project1.py]"]
  node_customer_subset["Customer analysis subset<br/>[project1.py]"]
  node_cleaned_csv["Cleaned sales data"]
end

subgraph group_presentation["Reporting"]
  node_dashboard["Interactive dashboard"]
end

node_analyst(("Analyst"))

node_workbook -->|"reads sheets"| node_cleaning
node_cleaning -->|"classifies records"| node_classification
node_classification -->|"derives sales"| node_sales_features
node_sales_features -->|"filters customers"| node_customer_subset
node_sales_features -->|"writes sales"| node_cleaned_csv
node_analyst -->|"explores reports"| node_dashboard
node_cleaned_csv -.->|"feeds reporting"| node_dashboard

click node_workbook "https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/online_retail_II.xlsx"
click node_cleaning "https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py"
click node_classification "https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py"
click node_sales_features "https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py"
click node_customer_subset "https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py"
click node_cleaned_csv "https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/cleaned_sales_data.csv"
click node_dashboard "https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/online%20retail%20sales%20dashboard.pbix"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_workbook,node_cleaning toneBlue
class node_classification,node_sales_features,node_customer_subset,node_cleaned_csv toneAmber
class node_dashboard toneMint
class node_analyst toneIndigo
```

## Components

### Data preparation

- [Retail workbook](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/online_retail_II.xlsx): `online_retail_II.xlsx`
- [Clean transactions](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py): `project1.py`

### Sales analysis

- [Classify transactions](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py): `project1.py`
- [Sales metrics and dates](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py): `project1.py`
- [Customer analysis subset](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/project1.py): `project1.py`
- [Cleaned sales data](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/cleaned_sales_data.csv): `cleaned_sales_data.csv`

### Reporting

- [Interactive dashboard](https://github.com/nagavasu7777/ecommerce-sales-analysis/blob/main/online%20retail%20sales%20dashboard.pbix): `online retail sales dashboard.pbix`

### Other components

- **Analyst**

## Connections

- Retail workbook → Clean transactions: reads sheets (evidence: `project1.py`)
- Clean transactions → Classify transactions: classifies records (evidence: `project1.py`)
- Classify transactions → Sales metrics and dates: derives sales (evidence: `project1.py`)
- Sales metrics and dates → Customer analysis subset: filters customers (evidence: `project1.py`)
- Sales metrics and dates → Cleaned sales data: writes sales (evidence: `project1.py`)
- Analyst → Interactive dashboard: explores reports (evidence: `Readme.md`)
- Cleaned sales data → Interactive dashboard: feeds reporting (evidence: `Readme.md`)
