Data & analytics
A marketing agency moves its reporting warehouse from SQL Server to Snowflake
- Client
- Marketing agency serving several enterprise brands
- Services
- Fractional CIO, Data & analytics
- Engagement
- Fractional retainer plus a migration project
The situation
Client reporting ran on an ageing SQL Server virtual machine reached over VPN. Every dashboard depended on one server and a set of hand-maintained views, and no one could say with confidence that the numbers were right.
What we did
- Chose dbt running inside Snowflake, with Power BI reading governed reporting tables
- Rebuilt every staging and reporting view as a tested dbt model
- Reconciled each model against the legacy system on every row and column, then turned the checks into automated tests
- Built a cost model and a phased plan with a parallel run before cutover
Stack
- SQL Server
- Azure Blob Storage
- Snowflake
- dbt
- Power BI