This Streamlit app showcases a variety of example reports, using simulated data from a fictional office supply company, to demonstrate the types of analyses possible within the Billing domain. These reports are built using different combinations of Fivetran connectors and data models, providing versatile examples of how to leverage Fivetran for billing analytics.
Supported connector and data model combinations include:
- Stripe connector + Stripe data model
- Shopify connector + Shopify data model
- Recurly connector + Recurly data model
- Recharge connector + Recharge data model
- Zuora connector + Zuora data model
Each data model provides a standardized, denormalized *__line_item_enhanced table that ensures consistent reporting across platforms. This means that regardless of your company's billing platform, these reports can be easily replicated using the platform-agnostic *__line_item_enhanced table.
The app includes several example reports generated from the *__line_item_enhanced data model. These reports illustrate how you can analyze different aspects of billing data, with results segmented by product, location, and customer demographics.
| Report | Description |
|---|---|
| Orders and Revenue | Showcases total revenue and orders over time and segmented by product, location, and customer. |
| Subscription Report | Highlights subscription activity and MRR and over time and segmented by subscription type. |
| Churn Analysis | Analyzes churn and retention rate as well as new MRR over time and provides a cohort analysis. |
These reports are designed to demonstrate the analytical capabilities when using Fivetran connectors paired with the corresponding transformation data models. We encourage you to explore these reports and provide feedback. If you find these examples useful or have suggestions for additional content, please share your thoughts via GitHub issues.