# ngtrmquang/goodreads-data-project architecture

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

- Interactive diagram: https://gitdiagram.com/ngtrmquang/goodreads-data-project
- Repository: https://github.com/ngtrmquang/goodreads-data-project

## Overview

This repository appears to be a coursework project combining SQL-based warehouse/data-mart scripts with a modeling notebook. The available README describes project deliverables but gives no runtime workflow or component relationships, and no source excerpts are available; the graph therefore shows the documented implementation areas without inferred edges. The explicitly scrapped SQL variant is omitted.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_warehouse["Data Warehouse"]
  node_create_dw[("Create Warehouse<br/>[01_create_dw.sql]")]
  node_load_dw[("Load Warehouse<br/>[02_load_dw.sql]")]
  node_create_dm[("Create Data Mart<br/>[03_create_dm.sql]")]
end

subgraph group_analytics["Modeling"]
  node_model_notebook["Model Notebook<br/>[03_model.ipynb]"]
end

click node_create_dw "https://github.com/ngtrmquang/goodreads-data-project/blob/main/dw/01_create_dw.sql"
click node_load_dw "https://github.com/ngtrmquang/goodreads-data-project/blob/main/dw/02_load_dw.sql"
click node_create_dm "https://github.com/ngtrmquang/goodreads-data-project/blob/main/dw/03_create_dm.sql"
click node_model_notebook "https://github.com/ngtrmquang/goodreads-data-project/blob/main/model/03_model.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_create_dw,node_load_dw,node_create_dm toneBlue
class node_model_notebook toneAmber
```

## Components

### Data Warehouse

- [Create Warehouse](https://github.com/ngtrmquang/goodreads-data-project/blob/main/dw/01_create_dw.sql): `dw/01_create_dw.sql`
- [Load Warehouse](https://github.com/ngtrmquang/goodreads-data-project/blob/main/dw/02_load_dw.sql): `dw/02_load_dw.sql`
- [Create Data Mart](https://github.com/ngtrmquang/goodreads-data-project/blob/main/dw/03_create_dm.sql): `dw/03_create_dm.sql`

### Modeling

- [Model Notebook](https://github.com/ngtrmquang/goodreads-data-project/blob/main/model/03_model.ipynb): `model/03_model.ipynb`
