# rionurfadilah229/e-commerce-data-analyst-project architecture

> Architecture diagram of the GitHub repository rionurfadilah229/e-commerce-data-analyst-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-07). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/rionurfadilah229/e-commerce-data-analyst-project
- Repository: https://github.com/rionurfadilah229/e-commerce-data-analyst-project

## Overview

This portfolio project demonstrates an analyst workflow from generating dummy PostgreSQL data through extraction, cleaning, and exploratory analysis to a Looker Studio dashboard. The README documents the notebook’s cleaning, merge, and analysis stages, while the shown Python excerpt confirms database reads and raw CSV writes. The notebook and SQL contents were not sampled, so their internal implementation details are not represented.

Main entry points: [`cleaning.ipynb`](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/cleaning.ipynb) (Dataset Merge), [`extract.py`](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/extract.py) (Table Extraction), [`sql/02_seed_dummy_data.sql`](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/sql/02_seed_dummy_data.sql) (Dummy Data), [`data/raw`](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/tree/main/data/raw) (Raw CSVs)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_source["Data Source"]
  node_dummy_data["Dummy Data"]
  node_postgres[("PostgreSQL")]
  node_schema["Database Schema<br/>[01_schema.sql]"]
end

subgraph group_prep["Data Preparation"]
  node_extract["Table Extraction<br/>[extract.py]"]
  node_raw_csv["Raw CSVs"]
  node_cleaning["Data Cleaning<br/>[cleaning.ipynb]"]
  node_clean_csv["Clean CSVs"]
end

subgraph group_analysis["Analysis"]
  node_merge["Dataset Merge<br/>[cleaning.ipynb]"]
  node_eda["Exploratory Analysis<br/>[cleaning.ipynb]"]
  node_merged_csv["Analysis CSV"]
end

subgraph group_viz["Visualization"]
  node_sheets["Google Sheets"]
  node_looker["Looker Studio"]
end

node_analyst(("Data Analyst"))

node_analyst -->|"generates data"| node_dummy_data
node_dummy_data -->|"seeds tables"| node_postgres
node_schema -->|"defines tables"| node_postgres
node_extract -->|"reads tables"| node_postgres
node_extract -->|"writes CSVs"| node_raw_csv
node_raw_csv -->|"supplies data"| node_cleaning
node_cleaning -->|"cleans tables"| node_clean_csv
node_clean_csv -->|"provides tables"| node_merge
node_merge -->|"prepares analysis"| node_eda
node_merge -->|"exports dataset"| node_merged_csv
node_merged_csv -->|"uploaded to"| node_sheets
node_sheets -->|"feeds dashboard"| node_looker
node_analyst -->|"explores data"| node_eda

click node_dummy_data "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/sql/02_seed_dummy_data.sql"
click node_schema "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/sql/01_schema.sql"
click node_extract "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/extract.py"
click node_raw_csv "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/tree/main/data/raw"
click node_cleaning "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/cleaning.ipynb"
click node_clean_csv "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/tree/main/data/clean"
click node_merge "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/cleaning.ipynb"
click node_eda "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/cleaning.ipynb"
click node_merged_csv "https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/data/clean/merged_for_looker.csv"

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_dummy_data,node_postgres,node_schema toneBlue
class node_extract,node_raw_csv,node_cleaning,node_clean_csv toneAmber
class node_merge,node_eda,node_merged_csv toneMint
class node_sheets,node_looker toneRose
class node_analyst toneIndigo
```

## Components

### Data Source

- [Dummy Data](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/sql/02_seed_dummy_data.sql): `sql/02_seed_dummy_data.sql`
- **PostgreSQL**
- [Database Schema](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/sql/01_schema.sql): `sql/01_schema.sql`

### Data Preparation

- [Table Extraction](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/extract.py): `extract.py`
- [Raw CSVs](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/tree/main/data/raw): `data/raw`
- [Data Cleaning](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/cleaning.ipynb): `cleaning.ipynb`
- [Clean CSVs](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/tree/main/data/clean): `data/clean`

### Analysis

- [Dataset Merge](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/cleaning.ipynb): `cleaning.ipynb`
- [Exploratory Analysis](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/cleaning.ipynb): `cleaning.ipynb`
- [Analysis CSV](https://github.com/rionurfadilah229/e-commerce-data-analyst-project/blob/main/data/clean/merged_for_looker.csv): `data/clean/merged_for_looker.csv`

### Visualization

- **Google Sheets**
- **Looker Studio**

### Other components

- **Data Analyst**

## Connections

- Data Analyst → Dummy Data: generates data (evidence: `readme.md`)
- Dummy Data → PostgreSQL: seeds tables (evidence: `readme.md`)
- Database Schema → PostgreSQL: defines tables (evidence: `readme.md`)
- Table Extraction → PostgreSQL: reads tables (evidence: `extract.py`)
- Table Extraction → Raw CSVs: writes CSVs (evidence: `extract.py`)
- Raw CSVs → Data Cleaning: supplies data (evidence: `readme.md`)
- Data Cleaning → Clean CSVs: cleans tables (evidence: `readme.md`)
- Clean CSVs → Dataset Merge: provides tables (evidence: `readme.md`)
- Dataset Merge → Exploratory Analysis: prepares analysis (evidence: `readme.md`)
- Dataset Merge → Analysis CSV: exports dataset (evidence: `readme.md`)
- Analysis CSV → Google Sheets: uploaded to (evidence: `readme.md`)
- Google Sheets → Looker Studio: feeds dashboard (evidence: `readme.md`)
- Data Analyst → Exploratory Analysis: explores data (evidence: `readme.md`)
