🎉 This is the initial release of this package! 🎉
- Produces modeled tables that leverage Zuora data from Fivetran's connector in the format described by this ERD and build off the output of our Zuora source package.
- The above mentioned models enable you to better understand your Zuora performance metrics at different granularities. It achieves this by:
- Providing intuitive reporting at the account and the subscription levels.
- Creates a billing history model at the invoice level and a line item history model to evaluate data at the invoice item level.
- Builds a daily overview of account balance activity using the billing history data.
- Generates a monthly recurring revenue table at the account level.
- A churn analysis model is also available in the analysis folder to evaluate account churn at the monthly level. More details area available in the DECISIONLOG.
- Generates a comprehensive data dictionary of your source and modeled Zuora data through the dbt docs site.
For more information, refer to the README.