# pranjalkadu662/ecommerce_sales_analytics architecture

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

- Interactive diagram: https://gitdiagram.com/pranjalkadu662/ecommerce_sales_analytics
- Repository: https://github.com/pranjalkadu662/ecommerce_sales_analytics

## Overview

This repository is a Superstore sales analytics project: it cleans the source dataset, explores sales and profit patterns, loads cleaned data into SQLite for business queries, and presents headline metrics and breakdowns in a Power BI dashboard. The principal workflow is dataset preparation through analysis and reporting; the SQL scripts also support customer, product, discount, regional, and time-based questions. README documentation describes the overall workflow, while the dashboard’s specific data inputs are not shown in the sampled files.

Main entry points: [`Excel/Dataset/Superstore_Cleaned.csv`](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Excel/Dataset/Superstore_Cleaned.csv) (Cleaned Dataset), [`Python/cleaning.py`](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Python/cleaning.py) (Data Cleaning), [`SQL/create_db.py`](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/SQL/create_db.py) (Database Loader), [`SQL/superstore.db`](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/SQL/superstore.db) (Orders Database)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data Preparation"]
  node_source_data["Source Dataset"]
  node_cleaning["Data Cleaning<br/>[cleaning.py]"]
  node_cleaned_data["Cleaned Dataset"]
end

subgraph group_analysis["Analytics"]
  node_eda["Exploratory Analysis<br/>[eda.py]"]
  node_db_loader["Database Loader<br/>[create_db.py]"]
  node_orders_db[("Orders Database<br/>[superstore.db]")]
  node_sql_queries["Business Queries<br/>[run_queries.py]"]
end

subgraph group_reporting["Reporting"]
  node_dashboard["Power BI Dashboard"]
end

node_analyst(("Analyst"))

node_analyst -->|"runs"| node_cleaning
node_source_data -->|"reads"| node_cleaning
node_cleaning -->|"writes"| node_cleaned_data
node_cleaned_data -->|"reads"| node_eda
node_cleaned_data -->|"reads"| node_db_loader
node_db_loader -->|"writes"| node_orders_db
node_sql_queries -->|"queries"| node_orders_db
node_analyst -->|"views"| node_dashboard

click node_source_data "https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Excel/Dataset/Sample%20-%20Superstore.csv"
click node_cleaning "https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Python/cleaning.py"
click node_cleaned_data "https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Excel/Dataset/Superstore_Cleaned.csv"
click node_eda "https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Python/eda.py"
click node_db_loader "https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/SQL/create_db.py"
click node_orders_db "https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/SQL/superstore.db"
click node_sql_queries "https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/SQL/run_queries.py"
click node_dashboard "https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/PowerBI/Ecommerce_Sales_Analytics.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_source_data,node_cleaning,node_cleaned_data toneBlue
class node_eda,node_db_loader,node_orders_db,node_sql_queries toneAmber
class node_dashboard toneMint
class node_analyst toneIndigo
```

## Components

### Data Preparation

- [Source Dataset](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Excel/Dataset/Sample%20-%20Superstore.csv): `Excel/Dataset/Sample - Superstore.csv`
- [Data Cleaning](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Python/cleaning.py): `Python/cleaning.py`
- [Cleaned Dataset](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Excel/Dataset/Superstore_Cleaned.csv): `Excel/Dataset/Superstore_Cleaned.csv`

### Analytics

- [Exploratory Analysis](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/Python/eda.py): `Python/eda.py`
- [Database Loader](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/SQL/create_db.py): `SQL/create_db.py`
- [Orders Database](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/SQL/superstore.db): `SQL/superstore.db`
- [Business Queries](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/SQL/run_queries.py): `SQL/run_queries.py`

### Reporting

- [Power BI Dashboard](https://github.com/pranjalkadu662/ecommerce_sales_analytics/blob/main/PowerBI/Ecommerce_Sales_Analytics.pbix): `PowerBI/Ecommerce_Sales_Analytics.pbix`

### Other components

- **Analyst**

## Connections

- Analyst → Data Cleaning: runs (evidence: `README.md`)
- Source Dataset → Data Cleaning: reads (evidence: `Python/cleaning.py`)
- Data Cleaning → Cleaned Dataset: writes (evidence: `Python/cleaning.py`)
- Cleaned Dataset → Exploratory Analysis: reads (evidence: `Python/eda.py`)
- Cleaned Dataset → Database Loader: reads (evidence: `SQL/create_db.py`)
- Database Loader → Orders Database: writes (evidence: `SQL/create_db.py`)
- Business Queries → Orders Database: queries (evidence: `SQL/run_queries.py`)
- Analyst → Power BI Dashboard: views (evidence: `README.md`)