# nithinchillara/brazilian-e-commerce-analytics architecture

> Architecture diagram of the GitHub repository nithinchillara/brazilian-e-commerce-analytics, 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/nithinchillara/brazilian-e-commerce-analytics
- Repository: https://github.com/nithinchillara/brazilian-e-commerce-analytics

## Overview

This repository is a notebook-based analysis of the Olist Brazilian e-commerce dataset. An analyst loads the nine CSV files, prepares order-level data, then explores business questions through descriptive, sales, customer, geographic, review, payment, seller, and retention analyses. A separate SQLite section loads data into an in-memory database and runs 15 SQL queries. The README documents these capabilities and the notebook’s section structure; notebook source was not provided, so the links below reflect documented relationships rather than inspected implementation details.

Main entry points: [`Nithin Chillara_BrazilianECommerceAnalytics.ipynb`](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb) (Cleaning and preprocessing)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_preparation["Data preparation"]
  node_loading["Data loading"]
  node_preprocessing["Cleaning and preprocessing"]
end

subgraph group_analytics["Business analytics"]
  node_eda["EDA and statistics"]
  node_kpis["KPI analysis"]
  node_sales_time["Sales and time series"]
  node_customer["Customer and RFM"]
  node_geography["Geographic analysis"]
  node_reviews["Review analysis"]
  node_payments["Payment analysis"]
  node_retention["Retention cohorts"]
  node_sellers["Seller analysis"]
  node_advanced["Advanced analysis"]
end

subgraph group_sql["SQL analysis"]
  node_sqlite[("SQLite database")]
  node_sql_queries["SQL queries"]
end

subgraph group_outputs["Analysis outputs"]
  node_findings["Charts and findings"]
end

node_analyst(("Analyst"))
node_csv_data[("Olist CSV data")]

node_analyst -->|"runs notebook"| node_loading
node_csv_data -->|"loads files"| node_loading
node_loading -->|"prepares data"| node_preprocessing
node_preprocessing -->|"analyzes data"| node_eda
node_preprocessing -->|"computes KPIs"| node_kpis
node_preprocessing -->|"analyzes sales"| node_sales_time
node_preprocessing -->|"segments customers"| node_customer
node_preprocessing -->|"analyzes geography"| node_geography
node_preprocessing -->|"analyzes reviews"| node_reviews
node_preprocessing -->|"analyzes payments"| node_payments
node_preprocessing -->|"builds cohorts"| node_retention
node_preprocessing -->|"analyzes sellers"| node_sellers
node_preprocessing -->|"answers questions"| node_advanced
node_loading -->|"loads data"| node_sqlite
node_sqlite -->|"runs queries"| node_sql_queries
node_eda -->|"produces analysis"| node_findings
node_kpis -->|"reports metrics"| node_findings
node_sales_time -->|"reports trends"| node_findings
node_customer -->|"reports segments"| node_findings
node_geography -->|"reports geography"| node_findings
node_reviews -->|"reports results"| node_findings
node_payments -->|"reports results"| node_findings
node_retention -->|"reports retention"| node_findings
node_sellers -->|"reports results"| node_findings
node_advanced -->|"answers questions"| node_findings
node_sql_queries -->|"returns results"| node_findings

click node_loading "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_preprocessing "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_eda "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_kpis "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_sales_time "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_customer "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_geography "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_reviews "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_payments "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_retention "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_sellers "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_advanced "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_sqlite "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_sql_queries "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"
click node_findings "https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb"

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_loading,node_preprocessing toneBlue
class node_eda,node_kpis,node_sales_time,node_customer,node_geography,node_reviews,node_payments,node_retention,node_sellers,node_advanced,node_csv_data toneAmber
class node_sqlite,node_sql_queries toneMint
class node_findings toneRose
class node_analyst toneIndigo
```

## Components

### Data preparation

- [Data loading](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Cleaning and preprocessing](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`

### Business analytics

- [EDA and statistics](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [KPI analysis](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Sales and time series](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Customer and RFM](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Geographic analysis](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Review analysis](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Payment analysis](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Retention cohorts](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Seller analysis](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [Advanced analysis](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`

### SQL analysis

- [SQLite database](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`
- [SQL queries](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`

### Analysis outputs

- [Charts and findings](https://github.com/nithinchillara/brazilian-e-commerce-analytics/blob/main/Nithin%20Chillara_BrazilianECommerceAnalytics.ipynb): `Nithin Chillara_BrazilianECommerceAnalytics.ipynb`

### Other components

- **Analyst**
- **Olist CSV data**

## Connections

- Analyst → Data loading: runs notebook (evidence: `README.md`)
- Olist CSV data → Data loading: loads files (evidence: `README.md`)
- Data loading → Cleaning and preprocessing: prepares data (evidence: `README.md`)
- Cleaning and preprocessing → EDA and statistics: analyzes data (evidence: `README.md`)
- Cleaning and preprocessing → KPI analysis: computes KPIs (evidence: `README.md`)
- Cleaning and preprocessing → Sales and time series: analyzes sales (evidence: `README.md`)
- Cleaning and preprocessing → Customer and RFM: segments customers (evidence: `README.md`)
- Cleaning and preprocessing → Geographic analysis: analyzes geography (evidence: `README.md`)
- Cleaning and preprocessing → Review analysis: analyzes reviews (evidence: `README.md`)
- Cleaning and preprocessing → Payment analysis: analyzes payments (evidence: `README.md`)
- Cleaning and preprocessing → Retention cohorts: builds cohorts (evidence: `README.md`)
- Cleaning and preprocessing → Seller analysis: analyzes sellers (evidence: `README.md`)
- Cleaning and preprocessing → Advanced analysis: answers questions (evidence: `README.md`)
- Data loading → SQLite database: loads data (evidence: `README.md`)
- SQLite database → SQL queries: runs queries (evidence: `README.md`)
- EDA and statistics → Charts and findings: produces analysis (evidence: `README.md`)
- KPI analysis → Charts and findings: reports metrics (evidence: `README.md`)
- Sales and time series → Charts and findings: reports trends (evidence: `README.md`)
- Customer and RFM → Charts and findings: reports segments (evidence: `README.md`)
- Geographic analysis → Charts and findings: reports geography (evidence: `README.md`)
- Review analysis → Charts and findings: reports results (evidence: `README.md`)
- Payment analysis → Charts and findings: reports results (evidence: `README.md`)
- Retention cohorts → Charts and findings: reports retention (evidence: `README.md`)
- Seller analysis → Charts and findings: reports results (evidence: `README.md`)
- Advanced analysis → Charts and findings: answers questions (evidence: `README.md`)
- SQL queries → Charts and findings: returns results (evidence: `README.md`)
