# adarshkumar-analyst/amazon-sales-sql-analysis-project architecture

> Architecture diagram of the GitHub repository adarshkumar-analyst/amazon-sales-sql-analysis-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/adarshkumar-analyst/amazon-sales-sql-analysis-project
- Repository: https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project

## Overview

This is a MySQL sales-analysis project, not an application service: the user loads the CSV into MySQL, then runs a SQL script that prepares and analyzes the data. The graph separates the documented analysis domains while keeping their shared implementation path. The README documents the workflow and capabilities; no source excerpts were provided, so internal query-level relationships are not inferred.

Main entry points: [`amazon_sales_analysis.sql`](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql) (Analysis SQL), [`Amazon.csv`](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/Amazon.csv) (Order dataset)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data and storage"]
  node_csv["Order dataset<br/>[Amazon.csv]"]
  node_mysql[("MySQL database")]
end

subgraph group_analysis["Sales analysis"]
  node_sql["Analysis SQL"]
  node_prep["Data preparation"]
  node_performance["Business performance"]
  node_products["Product analysis"]
end

subgraph group_operations["Customers and operations"]
  node_customers["Customer analysis"]
  node_sellers["Seller analysis"]
  node_fulfillment["Order fulfillment"]
  node_payments["Payment analysis"]
  node_geography["Geographic analysis"]
end

node_analyst(("Analyst"))

node_analyst -->|"loads CSV"| node_mysql
node_csv -->|"imported into"| node_mysql
node_analyst -->|"runs script"| node_sql
node_sql -->|"creates and queries"| node_mysql
node_sql -->|"checks data"| node_prep
node_sql -->|"analyzes trends"| node_performance
node_sql -->|"analyzes products"| node_products
node_sql -->|"analyzes customers"| node_customers
node_sql -->|"analyzes sellers"| node_sellers
node_sql -->|"analyzes statuses"| node_fulfillment
node_sql -->|"analyzes payments"| node_payments
node_sql -->|"analyzes geography"| node_geography

click node_csv "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/Amazon.csv"
click node_sql "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"
click node_prep "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"
click node_performance "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"
click node_products "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"
click node_customers "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"
click node_sellers "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"
click node_fulfillment "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"
click node_payments "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"
click node_geography "https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql"

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_csv,node_mysql toneBlue
class node_sql,node_prep,node_performance,node_products toneAmber
class node_customers,node_sellers,node_fulfillment,node_payments,node_geography toneMint
class node_analyst toneIndigo
```

## Components

### Data and storage

- [Order dataset](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/Amazon.csv): `Amazon.csv`
- **MySQL database**

### Sales analysis

- [Analysis SQL](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`
- [Data preparation](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`
- [Business performance](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`
- [Product analysis](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`

### Customers and operations

- [Customer analysis](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`
- [Seller analysis](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`
- [Order fulfillment](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`
- [Payment analysis](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`
- [Geographic analysis](https://github.com/adarshkumar-analyst/amazon-sales-sql-analysis-project/blob/main/amazon_sales_analysis.sql): `amazon_sales_analysis.sql`

### Other components

- **Analyst**

## Connections

- Analyst → MySQL database: loads CSV (evidence: `README.md`)
- Order dataset → MySQL database: imported into (evidence: `README.md`)
- Analyst → Analysis SQL: runs script (evidence: `README.md`)
- Analysis SQL → MySQL database: creates and queries (evidence: `README.md`)
- Analysis SQL → Data preparation: checks data (evidence: `README.md`)
- Analysis SQL → Business performance: analyzes trends (evidence: `README.md`)
- Analysis SQL → Product analysis: analyzes products (evidence: `README.md`)
- Analysis SQL → Customer analysis: analyzes customers (evidence: `README.md`)
- Analysis SQL → Seller analysis: analyzes sellers (evidence: `README.md`)
- Analysis SQL → Order fulfillment: analyzes statuses (evidence: `README.md`)
- Analysis SQL → Payment analysis: analyzes payments (evidence: `README.md`)
- Analysis SQL → Geographic analysis: analyzes geography (evidence: `README.md`)
