# sayash42/ecommerce-sales-powerbi-dashboard architecture

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

- Interactive diagram: https://gitdiagram.com/sayash42/ecommerce-sales-powerbi-dashboard
- Repository: https://github.com/sayash42/ecommerce-sales-powerbi-dashboard

## Overview

This repository is a Brazilian e-commerce analytics project: raw sales data is prepared and explored in a Jupyter notebook, then presented as a Power BI dashboard. The documented report covers executive performance, sales and product behavior, and delivery and customer analysis. The graph follows the README’s stated workflow and capabilities; no source excerpts were available, so implementation details and undocumented connections are omitted.

Main entry points: [`powerbi/ecommerce_sales_dashboard.pbix`](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.pbix) (DAX Measures), [`notebooks/ecommerce_sales_analysis.ipynb`](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/notebooks/ecommerce_sales_analysis.ipynb) (Data Cleaning), [`data/cleaned/Sales.csv`](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/data/cleaned/Sales.csv) (Prepared Sales Data), [`data/raw/ecommerce_sales.csv`](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/data/raw/ecommerce_sales.csv) (Raw Sales Data)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data_prep["Data Preparation"]
  node_raw_sales[("Raw Sales Data")]
  node_prep["Data Cleaning"]
  node_clean_sales[("Prepared Sales Data<br/>[Sales.csv]")]
end

subgraph group_analysis["Business Analysis"]
  node_eda["Exploratory Analysis"]
end

subgraph group_reporting["Power BI Reporting"]
  node_bi_measures["DAX Measures"]
  node_executive["Executive Overview"]
  node_sales_product["Sales and Products"]
  node_delivery_customer["Delivery and Customers"]
end

node_dashboard_user(("Dashboard User"))

node_raw_sales -->|"prepares"| node_prep
node_prep -->|"produces"| node_clean_sales
node_prep -->|"explores"| node_eda
node_clean_sales -->|"feeds report"| node_bi_measures
node_bi_measures -->|"measures"| node_executive
node_bi_measures -->|"measures"| node_sales_product
node_bi_measures -->|"measures"| node_delivery_customer
node_dashboard_user -.->|"views"| node_executive
node_dashboard_user -.->|"explores"| node_sales_product
node_dashboard_user -.->|"explores"| node_delivery_customer

click node_raw_sales "https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/data/raw/ecommerce_sales.csv"
click node_prep "https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/notebooks/ecommerce_sales_analysis.ipynb"
click node_clean_sales "https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/data/cleaned/Sales.csv"
click node_eda "https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/notebooks/ecommerce_sales_analysis.ipynb"
click node_bi_measures "https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.pbix"
click node_executive "https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.pbix"
click node_sales_product "https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.pbix"
click node_delivery_customer "https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.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_raw_sales,node_prep,node_clean_sales,node_dashboard_user toneBlue
class node_eda toneAmber
class node_bi_measures,node_executive,node_sales_product,node_delivery_customer toneMint
```

## Components

### Data Preparation

- [Raw Sales Data](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/data/raw/ecommerce_sales.csv): `data/raw/ecommerce_sales.csv`
- [Data Cleaning](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/notebooks/ecommerce_sales_analysis.ipynb): `notebooks/ecommerce_sales_analysis.ipynb`
- [Prepared Sales Data](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/data/cleaned/Sales.csv): `data/cleaned/Sales.csv`

### Business Analysis

- [Exploratory Analysis](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/notebooks/ecommerce_sales_analysis.ipynb): `notebooks/ecommerce_sales_analysis.ipynb`

### Power BI Reporting

- [DAX Measures](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.pbix): `powerbi/ecommerce_sales_dashboard.pbix`
- [Executive Overview](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.pbix): `powerbi/ecommerce_sales_dashboard.pbix`
- [Sales and Products](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.pbix): `powerbi/ecommerce_sales_dashboard.pbix`
- [Delivery and Customers](https://github.com/sayash42/ecommerce-sales-powerbi-dashboard/blob/main/powerbi/ecommerce_sales_dashboard.pbix): `powerbi/ecommerce_sales_dashboard.pbix`

### Other components

- **Dashboard User**

## Connections

- Raw Sales Data → Data Cleaning: prepares (evidence: `README.md`)
- Data Cleaning → Prepared Sales Data: produces (evidence: `README.md`)
- Data Cleaning → Exploratory Analysis: explores (evidence: `README.md`)
- Prepared Sales Data → DAX Measures: feeds report (evidence: `README.md`)
- DAX Measures → Executive Overview: measures (evidence: `README.md`)
- DAX Measures → Sales and Products: measures (evidence: `README.md`)
- DAX Measures → Delivery and Customers: measures (evidence: `README.md`)
- Dashboard User → Executive Overview: views
- Dashboard User → Sales and Products: explores
- Dashboard User → Delivery and Customers: explores
