- Building a Data Warehouse from scratch
- Designing data models following Kimball's Dimensional Modeling techniques
- Implementing end-to-end data pipeline using DBT and SQL
- Implementing data quality checks using DBT test and Greate Expectation
- Raw dataset: Wide World Importers
- Database: BigQuery
- Visualization: Looker Studio
To serve docs, using command:
dbt docs generate
dbt docs serve
To test model, using command:
dbt test