Icon

Web Application for the ARR Analysis Power BI

Web Application for the ARR Analysis

This workflow creates a small web application for the ARR calculation and analysis from contracts data. The contracts data can be uploaded as an Excel file containing contracts IDs, values, and terms.

The first step is to calculate the recurring values in each month based on the contract period and contract value. The second step is to calculate the ARR. The third step is to visualize it. Here we show three different ways for calculating and visualizing the ARR:
1. calculating the total ARR in each month and visualizing it in a line plot
2. calculating the total ARR in each month and year, and comparing the years in a line plot
3. calculating the total ARR in a selected month, e.g. the current month









This workflow calculates and visualizes ARR From contracts to monthlyrecurring values Demo data Table 1: ARR per dayTable 2: Pivot Table ARR per Month and Year Files Upload CalculateRecurring Values ARR Analysis Settings View Settings View Send to Power BI Select Columnsfor Power BI MicrosoftAuthentication This workflow calculates and visualizes ARR From contracts to monthlyrecurring values Demo data Table 1: ARR per dayTable 2: Pivot Table ARR per Month and Year Files Upload CalculateRecurring Values ARR Analysis Settings View Settings View Send to Power BI Select Columnsfor Power BI MicrosoftAuthentication

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: KNIME
Created at: 2018-12-03
On NodePit since: 2021-09-15
Last update: 2024-04-26
Created with KNIME version: v4.4.1
Tags: financeARR

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!