Industry
SaaS
Healthcare
Financial Services
2 more industry(es)Visualizing Self-Service Revenue Analytics Using Fivetran, dbt, and BigQuery
Summary
This case study describes how Preset uses Fivetran, dbt, and BigQuery to automate, transform, and visualize self-service revenue analytics based on data from Recurly. The approach centralizes revenue ...
Products
Software
Fivetran
A data extraction and loading tool used for ingesting Recurly subscription and billing data into BigQuery.
Sample Category
Sample Product 2
Sample product description for demonstration purposes.
Sample Category
Sample Product 3
Sample product description for demonstration purposes.
2 more products available
Challenges
- Difficulty in tracking and visualizing self-service revenue metrics over time using raw, untransformed data.
- Lack of real-time visibility into operations
- Difficulty in scaling current infrastructure
2 more challenges available
Solutions
- Automated ingestion of Recurly data into BigQuery using Fivetran.
- Deployed real-time monitoring and analytics platform
- Migrated to cloud-based scalable infrastructure
- Modernized legacy systems with new technology stack
3 more solutions available
Outcomes
- Automated, repeatable pipeline for ingesting and transforming revenue data.
- Achieved 24/7 real-time visibility and monitoring
- Successfully scaled operations to support 3x growth
- Decreased operational costs by 40% annually
3 more outcomes available