Icon

JKISeason2-26_​tark

JKISeason2-26

Challenge 26: Calculating Sales Performance
Level: Easy

Description: You work for a company that sells two products: Product A and Product B. As a data analyst, you want to calculate how sales increased or decreased for both products over a period of 12 months, on a monthly basis. In the end, you want to have a table with columns indicating the increase/decrease percentages of sales per month, as in the example below.

Month | Percentage_Sales_Product A | Percentage_Sales_Product B

February | 45 % | 100%

March | 78% | -87%

...

Author: Sanket Joshi

Dataset: Sales Data in the KNIME Hub

This workflow will work even if the number of product columnsincreases. The product names should be prefixed with "Sales_".Connect the modified data to column list loop start and check theoperation and result. original data(2 products)Node 2calculateincrease % MoMNode 5Replace"Sales_xxxxx"to "dummy"Node 7Replace"dummy"to the originalcolumn nameExcludethe lag columnNode 10Excludeunnecessary columnsby using regular expression.*Iter.*|^Sales.*visualizemodified data(26 products)Connect to column list loop startCSV Reader Lag Column Math Formula Column ListLoop Start Column Rename(Regex) Round Double Column Rename(Regex) Column Filter Loop End (ColumnAppend) Column Filter Table View CSV Reader This workflow will work even if the number of product columnsincreases. The product names should be prefixed with "Sales_".Connect the modified data to column list loop start and check theoperation and result. original data(2 products)Node 2calculateincrease % MoMNode 5Replace"Sales_xxxxx"to "dummy"Node 7Replace"dummy"to the originalcolumn nameExcludethe lag columnNode 10Excludeunnecessary columnsby using regular expression.*Iter.*|^Sales.*visualizemodified data(26 products)Connect to column list loop startCSV Reader Lag Column Math Formula Column ListLoop Start Column Rename(Regex) Round Double Column Rename(Regex) Column Filter Loop End (ColumnAppend) Column Filter Table View CSV Reader

Nodes

Extensions

Links