🎯 Data Modeling and Analytic Engineering

• 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

Resource

• 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