Icon

Revenue Growth KPI

<p><strong>Revenue Growth KPI</strong></p><p>This Data App helps businesses measure the Revenue Growth KPI, that is the percentage increase (or decrease) in a company's revenues over time, providing insights into business performance and market momentum. Monitoring this KPI helps identify trends, spot opportunities, and assess the impact of strategic initiatives.</p><p>The workflow calculates the Revenue Growth KPI of a fictitious company, for the years 2021-2023. The workflow reads journal entries (debit and credit) from an Excel file (or other sources like SAP, Salesforce, Odoo, or databases) and handles missing debit and credit values for data consistency. Next, it sums monthly credit amounts as revenues for the selected year and computes the monthly revenue growth rate. Lastly, it visualizes revenue totals and growth rates interactively.</p>

URL: Discover more data apps https://www.knime.com/data-app-examples
URL: KNIME Blog: Revenue Growth KPI https://www.knime.com/blog/calculate-revenue-growth-kpi

Revenue Growth KPI


This Data App helps businesses measure the Revenue Growth KPI, that is the percentage increase (or decrease) in a company's revenues over time, providing insights into business performance and market momentum. Monitoring this KPI helps identify trends, spot opportunities, and assess the impact of strategic initiatives.

The workflow calculates the Revenue Growth KPI of a fictitious company, for the years 2021-2023. The workflow reads journal entries (debit and credit) from an Excel file (or other sources like SAP, Salesforce, Odoo, or databases) and handles missing debit and credit values for data consistency. Next, it sums monthly credit amounts as revenues for the selected year and computes the monthly revenue growth rate. Lastly, it visualizes revenue totals and growth rates interactively.

Visualize KPI

  • Sum of revenues

  • Growth Rate

Read journal entry data

Compute Revenue Growth KPI

Reading ERPdata - hereExcel file simulates datafrom ERP like SAP
Excel Reader
Debit & credit &amount in orig currency to 0if missing
Missing Value
revenue(t) - revenue(t-1)--------------------------------------revenue(t-1)
Compute growth rate
Calculatesum(revenues) &growth rate& visualize in bar charts
Revenue Growth KPI
Sum Revenues over period(monthly)
Sum over period

Nodes

Extensions

Links