10 workflows in this folder and its subfolders
January 2020 · This workflow calculates and visualizes the ARR from contracts data. 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 and analyze it. This workflow demonstrates h…
December 2018 · URL: Seeing the Forest for the Trees - Cohort Analysis http:///blog/seeing-the-forest-for-the-trees-cohort-analysis URL: Measure and Monitor ARR in Two Steps https://www.knime.com/blog/measure-and-monitor-arr-in-2-steps
January 2020 · This workflow creates a budget overview in a data app. 11 projects (with desert names). Each project with total money (in 1000) assigned and used in 2021, 2022, 2023. We calculate the remaining money for each project for each year. The "Budget Summary" component contains three components: one displa…
October 2021 · This workflow shows an example of the verified component "Measure Fractional Years". It calculates the fraction of the year represented by the whole numbers between two dates. It also shows how to use the "Invert Category Sign" component The workflow makes use of a simple example data of an ecommerc…
January 2020 · This workflow calculates the ARR from contracts data. 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 v…
This is a business case example of the use of 3 financial metrics components in order to measure the profitability of some investment projects. The business case: Imagine you are a firm that wants to invest in 3 different ways. One way is to begin building an orchid, and for that you plan 3 differen…
November 2022 · This is a business case example of the use of 2 financial metrics components in order to measure the value of some investment projects. The business case: Imagine you are a firm that wants to invest in 3 different ways. One way is to begin building an orchid, and for that you plan 3 different projec…
October 2020 · This workflow demonstrates a typical variance analysis report created by Finance teams. The process identifies corresponding Excel actions a user may take to perform the same task. Sample data represents raw Finance system accounting information, and budgets arranged in table formats. Following the…
January 2017 · Comparing restaurant revenues month by month for 2022 and 2023, as monthly revenues and as YTD revenues. YTD = Year To Date means the sum of revenues up to the current month. Transactions from 2022 are saved in an Excel file, while transactions from 2023 are saved in a Google spreadsheet (which we m…
January 2020 · This workflow shows the steps involved building a cohort chart. The first step is to split contracts data into recurring values. The second step is to build a cohort chart from the recurring values. In this example, the cohort charts show the annually recurring revenue (ARR) and customer count by ti…