Case Study: SpotOn serves 5x faster reporting with Fivetran Transformations for dbt Core

SpotOn serves 5x faster reporting with Fivetran Transformations for dbt Core™

SpotOn, a North America-based B2B technology company, needed a better way to turn customer transaction and internal growth data into reliable reporting as it scaled. Before working with **Fivetran**, it was managing data across 30+ unconnected MySQL databases, relying on complex Snowflake stored procedures with more than 2,000 lines of code, and spending up to 15 hours a week on QA and manual monitoring.

Using **Fivetran** with Snowflake and dbt Core through Fivetran Transformations, SpotOn centralized data, automated orchestration, and modularized its transformation logic into scalable models. The result was reporting development time cut by several weeks, internal analytics delivered 5x faster, reduced computational costs, and a simpler, more scalable ELT pipeline managed by a lean 2-person data engineering team.

SpotOn

Tom Gilbertson

Product Manager, Data & Analytics