Icon

Group_​1-Building_​a_​Component

KNIME Pros Learnathon - Group 1 : Financial Analysis

Workshop content for the KNIME Pros Learnathon:

Come to our new Learnathon for Advanced Users of KNIME! Today's topic is... components! Are you ready to learn how to build a component, give it its own configuration window and/or its own composite view? In this session you will learn how to build and share reliable and user friendly components that act just like standard KNIME nodes.
The learnathon will begin with a detailed introduction to components and related KNIME features, then we will split into three groups. Each group will work on a different category of Verified Components, focusing on use cases.

Current Group: Financial Analysis

Maarit Widmann, the author behind the KNIME verified components for financial analysis, will guide you through the process of creating a shared component for calculating and visualizing the annually recurring revenue (ARR), from building the workflow inside it to sharing the component on the KNIME Hub.

Data preparation: Access contracts data and calculate the recurring valuesby month and customer ID. Group 1: Components for Financial Analysis1. Create a workflow that calculates and visualizes ARR2. Encapsulate the workflow into a component3. Create configuration options4. Check the input and write proper error messages5. Add the component's description and share it on the KNIME Hub6. Use your shared componentDetailed instructions for these steps are available inside themetanodes. Each metanode also shows the solution to the tasks inthe previous metanode. From contracts to monthly recurringvalues Demo data Use CaseHow is the business doing? One way of answering the question is to report the annually recurring revenue(ARR), and compare it to previous months or the same month in the previous years.We calculate the ARR from contracts data that report the customer ID, contract period, and contract value. Thefirst step is to calculate the revenue values by month and customer with the Calculate recurring valuescomponent.The second step is your task: Calculate the annually recurring values, and aggregate the data by month (andyear). Visualize the data so that you can see the trend, fluctuations within years, and differences between themjust by a quick look. Read demo dataStep 1: Build the functionality withKNIME nodesStep 2: Create a component. Customize itsinteractive view.Step 3: Add configurationnodes to enable varying input tablesStep 4: Proof the input. Edit the error messages.Step 6: Drag&dropthe component from the KNIME HubStep 5: Edit the description.Share the component on the KNIME Hub. CalculateRecurring Values Excel Reader (XLS) Create the workflow Create a component Create configurationoptions Failing inputs anderror messages Use your sharedcomponent Add descriptionand share Data preparation: Access contracts data and calculate the recurring valuesby month and customer ID. Group 1: Components for Financial Analysis1. Create a workflow that calculates and visualizes ARR2. Encapsulate the workflow into a component3. Create configuration options4. Check the input and write proper error messages5. Add the component's description and share it on the KNIME Hub6. Use your shared componentDetailed instructions for these steps are available inside themetanodes. Each metanode also shows the solution to the tasks inthe previous metanode. From contracts to monthly recurringvalues Demo data Use CaseHow is the business doing? One way of answering the question is to report the annually recurring revenue(ARR), and compare it to previous months or the same month in the previous years.We calculate the ARR from contracts data that report the customer ID, contract period, and contract value. Thefirst step is to calculate the revenue values by month and customer with the Calculate recurring valuescomponent.The second step is your task: Calculate the annually recurring values, and aggregate the data by month (andyear). Visualize the data so that you can see the trend, fluctuations within years, and differences between themjust by a quick look. Read demo dataStep 1: Build the functionality withKNIME nodesStep 2: Create a component. Customize itsinteractive view.Step 3: Add configurationnodes to enable varying input tablesStep 4: Proof the input. Edit the error messages.Step 6: Drag&dropthe component from the KNIME HubStep 5: Edit the description.Share the component on the KNIME Hub. CalculateRecurring Values Excel Reader (XLS) Create the workflow Create a component Create configurationoptions Failing inputs anderror messages Use your sharedcomponent Add descriptionand share

Nodes

Extensions

Links