SnowflakedbtSQLPython
Retail Analytics Data Warehouse
An end-to-end ELT project that loads retail order data into Snowflake, transforms it with dbt, and produces analytics-ready sales metrics by product category.
Key Accomplishments
- Built a Snowflake cloud data warehouse for retail analytics.
- Created dbt staging transformations and a category-level sales fact table.
- Implemented data quality checks for uniqueness, null values, and revenue metrics.
- Passed all 7 dbt data tests.
- Generated dbt documentation to explore models and data lineage.
7/7
Data tests passing
2
dbt transformation models
10
Sample retail order records