Welcome to my Airbnb Analytics Engineering project. This pipeline transforms raw Airbnb booking and hosting data into an analytics-ready dimensional model using Snowflake and dbt, culminating in an interactive Tableau dashboard.
This project demonstrates modern analytics engineering best practices by building a scalable, tested, and documented data warehouse pipeline to investigate booking integrity and revenue loss.
Key Technical Highlights:
delete+insert strategies.not_null checks, and custom dbt expectations.The final Gold layer exposes star-schema fact and dimension tables, powering the interactive dashboard to analyze host performance, cancellation rates, and booking trends.