How nikkran/course works
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: dim_hosts_cleansed.sql Cleansed Hosts · dim_listings_cleansed.sql Cleansed Listings · dim_listings_w_hosts.sql Listings With Hosts · src_hosts.sql Hosts Source
Components 7
Source Models
- Hosts Source
airbnb/models/src/src_hosts.sql - Listings Source
airbnb/models/src/src_listings.sql - Reviews Source
airbnb/models/src/src_reviews.sql
Cleansed Dimensions
- Cleansed Hosts
airbnb/models/dim/dim_hosts_cleansed.sql - Cleansed Listings
airbnb/models/dim/dim_listings_cleansed.sql
Analytics Models
- Listings With Hosts
airbnb/models/dim/dim_listings_w_hosts.sql - Reviews Fact
airbnb/models/fct/fct_reviews.sql
Connections 5
- 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