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