Hello! I'm {your_name}, and this is my project to show my data warehouse skills.
- 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
You can find the diagrams at diagrams.
You can find data models at models/analytics.
You can find data quality tests inside the yml files at models/analytics.
- Sales Orders
- Purchase Orders
- Raw dataset: Wide World Importers
- Database: BigQuery
- Course: Data Warehouse by Vitlamdata