Revenue Growth KPI Monthly Static

0 ×

This workflow calculates the Revenue Growth KPI, according to the following steps:

- Read journal entries from ERP (debit & credit)
- Get exchange rates from service via REST API by date
- Join the two data tables
- Set debit and credit to 0 if missing
- Multiply amount in original currency by exchange rate of the date
- Calculate monthly sum(credit) as sum(revenues) for 2022
- Calculate Growth Rate KPI
- Visualize Sum(revenues) and Growth rate by period

Here the journal entry data come from an Excel file, but could be imported from SAP, Salesforce, Odoo, or a database. It is enough to change the Excel Reader node into the appropriate node for the data source.

Nodes

• Math Formula3 ×
• Bar Chart2 ×
• Concatenate1 ×
• DB Reader (Labs)1 ×
• DB Table Selector (Labs)1 ×
• Show all 17 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Excel Support
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Views

Links

• No links available