Excel reporting took 45 minutes to refresh and was error-prone. No version control. No data quality tests.
I migrated to dbt + Snowflake.
What I Built
- 15 Excel reports → dbt models
- Star schema design
- Incremental models for 2.3M+ rows
- 40+ automated data quality tests
- CI/CD with GitHub Actions
Results
| Metric | Before | After |
|---|---|---|
| Refresh time | 45 minutes | 3 minutes |
| Data quality | Manual | 40+ tests |
| Anomalies caught | 0% | 12% |
Top comments (0)