This project demonstrates a complete analytics engineering workflow using Snowflake, dbt, and Streamlit. It loads Inside Airbnb open data into Snowflake, transforms it through a layered dbt architecture (staging → intermediate → marts), validates data quality with tests, and serves insights via a Streamlit dashboard.
What This Project Does
Raw data ingestion
Loads CSV/GZIP files from Inside Airbnb into Snowflake internal stages
Layered transformations
Implements staging (clean/cast), intermediate (joins/enrichment), and mart (dimensions/facts) layers
Incremental modeling
Uses Snowflake merge strategy for fact tables
Data quality
Generic and singular dbt tests validate uniqueness, relationships, and business rules
Analytics dashboard
Streamlit app queries marts for neighbourhood and listing performance
Data sources
:
listings.csv.gz
,
calendar.csv.gz
,
reviews.csv.gz
,
neighbourhoods.csv
from
Inside Airbnb
Installation
Show more
Installs
628
Repository
aradotso/data-skills
GitHub Stars
2
First Seen
May 30, 2026
Security Audits
Gen Agent Trust Hub
Pass
Socket
Pass
Snyk
Warn