Edit

Revenue Year-Over-Year (Power BI Report)

The Revenue Year-Over-Year report provides valuable insights into your organization's subscription business over time. The report compares monthly recurring revenue for different time periods to the same period in the previous year, providing insight into growth trends and areas for improvement.

Screenshot of the Revenue Year-Over-Year Growth report.

Use the report

The Revenue Year-over-Year report helps you compare monthly recurring revenue (MRR) across months and against the previous year. Alongside revenue trends, the report also shows monthly churn, making it easy to spot when cancellations are affecting growth. If churn rises unexpectedly, you can take action to improve customer retention, adjust renewal strategies, or focus on at-risk accounts.

Key performance indicators

Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.

Tip

You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Data used in the report

The report uses data form the following tables in Business Central:

  • Subscription Contract Analysis Entries

Track your business KPIs with Power BI metrics
Setting up the Subscription Billing Power BI app
Subscription Billing controlling
Subscription Billing overview