# sangwanamit621/sales-and-revenue-analysis architecture

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

- Interactive diagram: https://gitdiagram.com/sangwanamit621/sales-and-revenue-analysis
- Repository: https://github.com/sangwanamit621/sales-and-revenue-analysis

## Overview

This repository is a 2019 Amazon sales-and-revenue analysis project. Its principal workflow is to prepare monthly sales data, explore and consolidate it, then present sales and revenue insights in Power BI dashboards. The README documents the dashboard capabilities; artifact names indicate the data and analysis stages. Source excerpts were unavailable, so the graph omits uncertain implementation details and links.

Main entry points: [`Analyzing Amazon Sales Dashboard.pbix`](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Analyzing%20Amazon%20Sales%20Dashboard.pbix) (Sales analysis dashboard), [`Amazon Sales Analysis Data Transformation and Basic EDA.ipynb`](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Amazon%20Sales%20Analysis%20Data%20Transformation%20and%20Basic%20EDA.ipynb) (Transformation and EDA), [`AllYearSales.csv`](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/AllYearSales.csv) (Consolidated sales data), [`amazon sales raw data`](https://github.com/sangwanamit621/sales-and-revenue-analysis/tree/main/amazon%20sales%20raw%20data) (Monthly sales CSVs)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_monthly["Monthly sales CSVs"]
  node_annual["Consolidated sales data<br/>[AllYearSales.csv]"]
end

subgraph group_analysis["Analysis"]
  node_notebook["Transformation and EDA"]
end

subgraph group_outputs["Reporting"]
  node_powerbi["Sales analysis dashboard"]
  node_sales_view["Sales dashboard"]
  node_revenue_view["Revenue dashboard"]
  node_revenue_report["Sales and revenue report"]
  node_presentation["Sales and revenue presentation"]
end

node_analyst(("Analyst"))

node_monthly -->|"input data"| node_notebook
node_notebook -->|"consolidates"| node_annual
node_annual -->|"analysis data"| node_powerbi
node_powerbi -->|"shows sales"| node_sales_view
node_powerbi -->|"shows revenue"| node_revenue_view
node_analyst -->|"explores data"| node_notebook
node_analyst -->|"reviews insights"| node_powerbi

click node_monthly "https://github.com/sangwanamit621/sales-and-revenue-analysis/tree/main/amazon%20sales%20raw%20data"
click node_notebook "https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Amazon%20Sales%20Analysis%20Data%20Transformation%20and%20Basic%20EDA.ipynb"
click node_annual "https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/AllYearSales.csv"
click node_powerbi "https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Analyzing%20Amazon%20Sales%20Dashboard.pbix"
click node_sales_view "https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Analyzing%20Amazon%20Sales%20Dashboard.pbix"
click node_revenue_view "https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Analyzing%20Amazon%20Sales%20Dashboard.pbix"
click node_revenue_report "https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Amazon%20Sales%20and%20revenue%20DPR.pdf"
click node_presentation "https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Amazon%20Sales%20and%20revenue%20Presentation.pptx"

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_monthly,node_annual toneBlue
class node_notebook toneAmber
class node_powerbi,node_sales_view,node_revenue_view,node_revenue_report,node_presentation toneMint
class node_analyst toneIndigo
```

## Components

### Data preparation

- [Monthly sales CSVs](https://github.com/sangwanamit621/sales-and-revenue-analysis/tree/main/amazon%20sales%20raw%20data): `amazon sales raw data`
- [Consolidated sales data](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/AllYearSales.csv): `AllYearSales.csv`

### Analysis

- [Transformation and EDA](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Amazon%20Sales%20Analysis%20Data%20Transformation%20and%20Basic%20EDA.ipynb): `Amazon Sales Analysis Data Transformation and Basic EDA.ipynb`

### Reporting

- [Sales analysis dashboard](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Analyzing%20Amazon%20Sales%20Dashboard.pbix): `Analyzing Amazon Sales Dashboard.pbix`
- [Sales dashboard](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Analyzing%20Amazon%20Sales%20Dashboard.pbix): `Analyzing Amazon Sales Dashboard.pbix`
- [Revenue dashboard](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Analyzing%20Amazon%20Sales%20Dashboard.pbix): `Analyzing Amazon Sales Dashboard.pbix`
- [Sales and revenue report](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Amazon%20Sales%20and%20revenue%20DPR.pdf): `Amazon Sales and revenue DPR.pdf`
- [Sales and revenue presentation](https://github.com/sangwanamit621/sales-and-revenue-analysis/blob/main/Amazon%20Sales%20and%20revenue%20Presentation.pptx): `Amazon Sales and revenue Presentation.pptx`

### Other components

- **Analyst**

## Connections

- Monthly sales CSVs → Transformation and EDA: input data
- Transformation and EDA → Consolidated sales data: consolidates
- Consolidated sales data → Sales analysis dashboard: analysis data
- Sales analysis dashboard → Sales dashboard: shows sales
- Sales analysis dashboard → Revenue dashboard: shows revenue
- Analyst → Transformation and EDA: explores data
- Analyst → Sales analysis dashboard: reviews insights