ANALYTICS ENGINEERING WITH AIRBNB:

• Simulating the life of an Analytics Engineer in Airbnb
• Loading, Cleansing, Exposing data
• Writing test, automations and documentation
• Data source: Inside Airbnb: Berlin

PROJECT:

In this project, I will go through a real-world Airbnb project where I will use several of the dbt functionalities. Snowflake will be used as the Data Warehouse.

The dbt functionalities used in this project:

• dbt Models
• dbt Materializations
• dbt Tests
• dbt Documentation
• dbt Sources, Seeds, Snapshots
• dbt Hooks and Operations
• Jinja and Macros
• Analyses, Exposures
• dbt Seeds
• Data Visualization (Preset)

PROJECT REQUIREMENTS

• Modeling changes are easy to follow and revert
• Explicit dependencies between models
• Explore dependencies between models
• Data quality tests
• Error reporting
• Incremental load of fact tables
• Track history of dimension tables
• Easy-to-access documentation

DATA MODEL

DIRECTED ACYCLIC GRAPH

DATA FLOW STAGING LAYERS

BI DASHBOARD