Fivetran
Case Studies
SpotOn Accelerates Reporting with Fivetran Transformations for dbt Core
Overview
SpotOn Accelerates Reporting with Fivetran Transformations for dbt CoreFivetran |
Infrastructure as a Service (IaaS) - Cloud Databases Platform as a Service (PaaS) - Application Development Platforms | |
Electrical Grids Equipment & Machinery | |
Product Research & Development | |
Leasing Finance Automation Time Sensitive Networking | |
Cloud Planning, Design & Implementation Services | |
Operational Impact
The implementation of Fivetran Transformations for dbt Core resulted in significant operational improvements for SpotOn. The company was able to scale with a lean team as their clients, and their data needs, grew. Automated version control, data lineage graphs, and documentation ensured data integrity. The synchronization of connector load and model runs reduced computational costs and the complexity of the tech stack was significantly reduced. Client-facing reporting was generated faster, ensuring clients had always-on and reliable access to their data, and no opportunities or optimizations were missed. The internal team also benefited, with the ability to collaboratively produce internal analytics and BI faster, expediting the time to insight. | |
Quantitative Benefit
Fivetran helped SpotOn’s team centralize 30+ databases into Snowflake | |
dbt Core helped them reduce thousands of lines of code into scalable data models | |
Fivetran Transformations for dbt Core decreased reporting development time by weeks, while increasing automation | |