In this Project, a fully fledged Airbnb Analytics Engineering Workflow is simulated using Data Build Tool(Dbt), Snowflake and Preset. In the first Stage, Data from Airbnb Listings, Reviews and Hosts is integrated into a Staging Area in Snowflake. Dbt Models are then utilized to clean, transform and prepare this Data for Dimensional Modeling and Fact Table creation. Slowly Changing Dimensions are handled by implementing Snapshots of the Raw Tables. Data Quality Checks are handled by implementing Tests with Dbt.
In the last Layer, a Seeds File containing Dates about Full Moon Occurances is aggregated with the Review Data and transformed into a Mart, in order to examine if Full Moon Occurances might lead to different Reviews.
In the last Stage, Preset is used to create an "Executive Dashboard" for Business Intelligence.
- Snowflake
- Dbt
- Preset