How Preset Uses dbt and Fivetran to Visualize Recurly Revenue
Blog post from Preset
Preset's blog post explores the application of modern data stack tools like Fivetran and dbt within a BigQuery data warehouse to enhance self-service revenue analytics derived from Recurly data. Fivetran facilitates seamless data ingestion from Recurly into BigQuery, where dbt is employed to transform raw data into specific datasets crucial for visualizing Preset's revenue metrics. The process involves multiple layers of data transformation: initially, raw data tables are refined to enhance clarity by renaming fields and tracking effective dates, followed by creating daily snapshots for comprehensive time-series analysis. The final layer aggregates these datasets into a comprehensive account_subscription_history table, enabling the calculation of key metrics such as Monthly Recurring Revenue (MRR) and Annual Recurring Revenue (ARR). Preset highlights its dataset-centric approach to visualization, providing insights into how these metrics are tracked over time and offering SQL transformation templates to aid in revenue tracking. The blog underscores the utility of these tools in producing detailed visualizations and metrics to monitor revenue growth, demonstrating their practical application in real-world data analytics.
No tracked trend matches for this post yet.
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.