# nikkran/course architecture

> Architecture diagram of the GitHub repository nikkran/course, 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/nikkran/course
- Repository: https://github.com/nikkran/course

## Overview

This repository is a dbt student project for transforming Airbnb data. Its apparent workflow moves source models into cleansed dimensions and a reviews fact model, with a combined listings-and-hosts model as another output. The tree identifies these domain stages, but the model SQL was not provided, so the connections below are dashed and unverified; exact dbt references and transformation details cannot be confirmed.

Main entry points: [`airbnb/models/dim/dim_hosts_cleansed.sql`](https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_hosts_cleansed.sql) (Cleansed Hosts), [`airbnb/models/dim/dim_listings_cleansed.sql`](https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_listings_cleansed.sql) (Cleansed Listings), [`airbnb/models/dim/dim_listings_w_hosts.sql`](https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_listings_w_hosts.sql) (Listings With Hosts), [`airbnb/models/src/src_hosts.sql`](https://github.com/nikkran/course/blob/main/airbnb/models/src/src_hosts.sql) (Hosts Source)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_sources["Source Models"]
  node_src_hosts["Hosts Source<br/>[src_hosts.sql]"]
  node_src_listings["Listings Source<br/>[src_listings.sql]"]
  node_src_reviews["Reviews Source<br/>[src_reviews.sql]"]
end

subgraph group_dimensions["Cleansed Dimensions"]
  node_dim_hosts["Cleansed Hosts"]
  node_dim_listings["Cleansed Listings"]
end

subgraph group_outputs["Analytics Models"]
  node_listings_hosts["Listings With Hosts"]
  node_fct_reviews["Reviews Fact<br/>[fct_reviews.sql]"]
end

node_src_hosts -.->|"cleanses"| node_dim_hosts
node_src_listings -.->|"cleanses"| node_dim_listings
node_dim_hosts -.->|"combines"| node_listings_hosts
node_dim_listings -.->|"combines"| node_listings_hosts
node_src_reviews -.->|"transforms"| node_fct_reviews

click node_src_hosts "https://github.com/nikkran/course/blob/main/airbnb/models/src/src_hosts.sql"
click node_src_listings "https://github.com/nikkran/course/blob/main/airbnb/models/src/src_listings.sql"
click node_src_reviews "https://github.com/nikkran/course/blob/main/airbnb/models/src/src_reviews.sql"
click node_dim_hosts "https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_hosts_cleansed.sql"
click node_dim_listings "https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_listings_cleansed.sql"
click node_listings_hosts "https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_listings_w_hosts.sql"
click node_fct_reviews "https://github.com/nikkran/course/blob/main/airbnb/models/fct/fct_reviews.sql"

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_src_hosts,node_src_listings,node_src_reviews toneBlue
class node_dim_hosts,node_dim_listings toneAmber
class node_listings_hosts,node_fct_reviews toneMint
```

## Components

### Source Models

- [Hosts Source](https://github.com/nikkran/course/blob/main/airbnb/models/src/src_hosts.sql): `airbnb/models/src/src_hosts.sql`
- [Listings Source](https://github.com/nikkran/course/blob/main/airbnb/models/src/src_listings.sql): `airbnb/models/src/src_listings.sql`
- [Reviews Source](https://github.com/nikkran/course/blob/main/airbnb/models/src/src_reviews.sql): `airbnb/models/src/src_reviews.sql`

### Cleansed Dimensions

- [Cleansed Hosts](https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_hosts_cleansed.sql): `airbnb/models/dim/dim_hosts_cleansed.sql`
- [Cleansed Listings](https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_listings_cleansed.sql): `airbnb/models/dim/dim_listings_cleansed.sql`

### Analytics Models

- [Listings With Hosts](https://github.com/nikkran/course/blob/main/airbnb/models/dim/dim_listings_w_hosts.sql): `airbnb/models/dim/dim_listings_w_hosts.sql`
- [Reviews Fact](https://github.com/nikkran/course/blob/main/airbnb/models/fct/fct_reviews.sql): `airbnb/models/fct/fct_reviews.sql`

## Connections

- Hosts Source → Cleansed Hosts: cleanses
- Listings Source → Cleansed Listings: cleanses
- Cleansed Hosts → Listings With Hosts: combines
- Cleansed Listings → Listings With Hosts: combines
- Reviews Source → Reviews Fact: transforms
