# sahbimlesh007/end-to-end-e-commerce-analytics-project architecture

> Architecture diagram of the GitHub repository sahbimlesh007/end-to-end-e-commerce-analytics-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/sahbimlesh007/end-to-end-e-commerce-analytics-project
- Repository: https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project

## Overview

This repository documents an e-commerce analytics workflow: Olist CSV data is loaded into PostgreSQL, modeled and analyzed with SQL, then exposed to Power BI for measures and interactive reporting. The dashboard covers executive, sales, customer, product, logistics, seller, payment, and review analysis; reported insights support business decisions. The graph follows the README’s stated workflow and the available file tree. No source excerpts were provided, so detailed SQL calls, Power BI internals, and wiring beyond documented transfers are not inferred.

Main entry points: [`Project PowerBI.pbix`](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix) (Interactive dashboards), [`SQL queries/import_query.sql`](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/import_query.sql) (CSV loading), [`SQL queries/import_geo.sql`](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/import_geo.sql) (Geolocation loading), [`SQL queries/view.sql`](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/view.sql) (SQL views)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_database["PostgreSQL Data"]
  node_load["CSV loading<br/>[import_query.sql]"]
  node_geo["Geolocation loading<br/>[import_geo.sql]"]
  node_schema["Relational schema<br/>[create_table.sql]"]
  node_constraints["Key constraints"]
  node_db[("PostgreSQL database")]
  node_indexes["Query indexes<br/>[index.sql]"]
end

subgraph group_analytics["SQL Analytics"]
  node_views["SQL views<br/>[view.sql]"]
  node_querynotes["Analysis queries<br/>[BIViews.txt]"]
end

subgraph group_bi["Power BI Reporting"]
  node_modelnotes["Data model<br/>[Tables.txt]"]
  node_datedim["Date dimension<br/>[DateDim.txt]"]
  node_measures["DAX measures<br/>[DAX Measures.txt]"]
  node_dashboard["Interactive dashboards"]
  node_executive["Executive overview"]
  node_sales["Sales analytics"]
  node_customers["Customer analytics"]
  node_products["Product analytics"]
  node_logistics["Logistics performance"]
  node_sellers["Seller performance"]
  node_payments["Payment analytics"]
  node_reviews["Review analytics"]
end

subgraph group_outcomes["Business Outcomes"]
  node_report["Business insights<br/>[Report.pdf]"]
end

node_dataset["Olist CSV data"]
node_stakeholders(("Business stakeholders"))

node_dataset -->|"loads CSV"| node_load
node_dataset -->|"loads geography"| node_geo
node_load -->|"writes rows"| node_db
node_geo -->|"writes rows"| node_db
node_schema -->|"creates tables"| node_db
node_constraints -->|"adds keys"| node_db
node_indexes -->|"indexes columns"| node_db
node_db -->|"reads data"| node_views
node_views -->|"imports views"| node_dashboard
node_modelnotes -->|"documents model"| node_dashboard
node_datedim -->|"documents dates"| node_dashboard
node_measures -->|"defines measures"| node_dashboard
node_querynotes -->|"documents analysis"| node_db
node_dashboard -->|"presents KPIs"| node_executive
node_dashboard -->|"reports sales"| node_sales
node_dashboard -->|"reports customers"| node_customers
node_dashboard -->|"reports products"| node_products
node_dashboard -->|"reports delivery"| node_logistics
node_dashboard -->|"reports sellers"| node_sellers
node_dashboard -->|"reports payments"| node_payments
node_dashboard -->|"reports reviews"| node_reviews
node_dashboard -->|"serves reports"| node_stakeholders
node_report -->|"communicates insights"| node_stakeholders

click node_load "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/import_query.sql"
click node_geo "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/import_geo.sql"
click node_schema "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/create_table.sql"
click node_constraints "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/add_constraints.sql"
click node_indexes "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/index.sql"
click node_views "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/view.sql"
click node_querynotes "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/project%20assets/BIViews.txt"
click node_modelnotes "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/project%20assets/Tables.txt"
click node_datedim "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/project%20assets/DateDim.txt"
click node_measures "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/project%20assets/DAX%20Measures.txt"
click node_dashboard "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_executive "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_sales "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_customers "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_products "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_logistics "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_sellers "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_payments "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_reviews "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix"
click node_report "https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Report.pdf"

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_load,node_geo,node_schema,node_constraints,node_db,node_indexes toneBlue
class node_views,node_querynotes toneAmber
class node_modelnotes,node_datedim,node_measures,node_dashboard,node_executive,node_sales,node_customers,node_products,node_logistics,node_sellers,node_payments,node_reviews toneMint
class node_report toneRose
class node_dataset,node_stakeholders toneIndigo
```

## Components

### PostgreSQL Data

- [CSV loading](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/import_query.sql): `SQL queries/import_query.sql`
- [Geolocation loading](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/import_geo.sql): `SQL queries/import_geo.sql`
- [Relational schema](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/create_table.sql): `SQL queries/create_table.sql`
- [Key constraints](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/add_constraints.sql): `SQL queries/add_constraints.sql`
- **PostgreSQL database**
- [Query indexes](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/index.sql): `SQL queries/index.sql`

### SQL Analytics

- [SQL views](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/SQL%20queries/view.sql): `SQL queries/view.sql`
- [Analysis queries](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/project%20assets/BIViews.txt): `project assets/BIViews.txt`

### Power BI Reporting

- [Data model](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/project%20assets/Tables.txt): `project assets/Tables.txt`
- [Date dimension](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/project%20assets/DateDim.txt): `project assets/DateDim.txt`
- [DAX measures](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/project%20assets/DAX%20Measures.txt): `project assets/DAX Measures.txt`
- [Interactive dashboards](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`
- [Executive overview](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`
- [Sales analytics](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`
- [Customer analytics](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`
- [Product analytics](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`
- [Logistics performance](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`
- [Seller performance](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`
- [Payment analytics](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`
- [Review analytics](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Project%20PowerBI.pbix): `Project PowerBI.pbix`

### Business Outcomes

- [Business insights](https://github.com/sahbimlesh007/end-to-end-e-commerce-analytics-project/blob/main/Report.pdf): `Report.pdf`

### Other components

- **Olist CSV data**
- **Business stakeholders**

## Connections

- Olist CSV data → CSV loading: loads CSV
- Olist CSV data → Geolocation loading: loads geography
- CSV loading → PostgreSQL database: writes rows
- Geolocation loading → PostgreSQL database: writes rows
- Relational schema → PostgreSQL database: creates tables
- Key constraints → PostgreSQL database: adds keys
- Query indexes → PostgreSQL database: indexes columns
- PostgreSQL database → SQL views: reads data
- SQL views → Interactive dashboards: imports views
- Data model → Interactive dashboards: documents model
- Date dimension → Interactive dashboards: documents dates
- DAX measures → Interactive dashboards: defines measures
- Analysis queries → PostgreSQL database: documents analysis
- Interactive dashboards → Executive overview: presents KPIs
- Interactive dashboards → Sales analytics: reports sales
- Interactive dashboards → Customer analytics: reports customers
- Interactive dashboards → Product analytics: reports products
- Interactive dashboards → Logistics performance: reports delivery
- Interactive dashboards → Seller performance: reports sellers
- Interactive dashboards → Payment analytics: reports payments
- Interactive dashboards → Review analytics: reports reviews
- Interactive dashboards → Business stakeholders: serves reports
- Business insights → Business stakeholders: communicates insights