snowflake-dbt-airbnb-analytics

What problem does it solve?

This Skill automates complex data analytics workflows with Snowflake, dbt, and Streamlit, streamlining data ingestion, transformation, quality assurance, and visualization.

Core Features & Use Cases

• Data Ingestion: Automates the loading of data from various sources into Snowflake.
• Data Transformation: Implements a robust dbt architecture with staging, intermediate, and mart layers for data transformation.
• Data Quality: Validates data quality with comprehensive dbt tests and schema checks.
• Visualization: Serves insights through a Streamlit dashboard for neighborhood and listing performance.
• Use Case: Ideal for data analysts and engineers looking to automate the end-to-end data analytics workflow for large datasets like Airbnb listings and calendar data.

Quick Start

Set up a Snowflake and dbt project with Inside Airbnb data, transform it using dbt, and visualize performance with the Streamlit dashboard.