Icon

JKISeasor2-26_​tomljh_​ver1

There has been no title set for this workflow's metadata.

Challenge 26: Calculating Sales Performance

Challenge 26: Calculating Sales PerformanceLevel: EasyDescription: You work for a company that sells two products: Product A and Product B. As adata analyst, you want to calculate how sales increased or decreased for both products overa period of 12 months, on a monthly basis. In the end, you want to have a table withcolumns indicating the increase/decrease percentages of sales per month, as in theexample below.Month | Percentage_Sales_Product A | Percentage_Sales_Product BFebruary | 45 % | 100%March | 78% | -87%...Author: Sanket Joshiref : @ skybe077 https://hub.knime.com/skybe077/spaces/Public/latest/C26_Calculating%20Sales%20Performance~a3M1eJ-KmJG-vhoR@ sryuhttps://hub.knime.com/sryu/spaces/Public/latest/Just%20KNIME%20It%20season2/JKISeason2-26_sryu~R3PLtD0vw_AOnHr2 挑战26：计算销售业绩水平： 容易描述：您在一家销售两种产品的公司工作：产品 A 和产品 B。作为数据分析师，您希望计算这两种产品的销售额在 12 个月内每月的增加或减少情况。最后，您希望有一个包含指示每月销售额增加/减少百分比的列的表，如下例所示。月份 |Percentage_Sales_Product A |Percentage_Sales_Product B二月 |45 % |100%三月 |78% |-87%...作者： 桑基特·乔希 Read Datasales_data.csvSales_Product_Alag 1Sales_Product_Blag 1Note: delete first rowA%B%int ->string+ %Calculate product A & B sales growth rateNote: advance--checked "Multi-row access"Remove the first row CSV Reader Lag Column Lag Column Math Formula Math Formula Column Filter String Manipulation(Multi Column) Column Expressions Row Filter Challenge 26: Calculating Sales PerformanceLevel: EasyDescription: You work for a company that sells two products: Product A and Product B. As adata analyst, you want to calculate how sales increased or decreased for both products overa period of 12 months, on a monthly basis. In the end, you want to have a table withcolumns indicating the increase/decrease percentages of sales per month, as in theexample below.Month | Percentage_Sales_Product A | Percentage_Sales_Product BFebruary | 45 % | 100%March | 78% | -87%...Author: Sanket Joshiref : @ skybe077 https://hub.knime.com/skybe077/spaces/Public/latest/C26_Calculating%20Sales%20Performance~a3M1eJ-KmJG-vhoR@ sryuhttps://hub.knime.com/sryu/spaces/Public/latest/Just%20KNIME%20It%20season2/JKISeason2-26_sryu~R3PLtD0vw_AOnHr2 挑战26：计算销售业绩水平： 容易描述：您在一家销售两种产品的公司工作：产品 A 和产品 B。作为数据分析师，您希望计算这两种产品的销售额在 12 个月内每月的增加或减少情况。最后，您希望有一个包含指示每月销售额增加/减少百分比的列的表，如下例所示。月份 |Percentage_Sales_Product A |Percentage_Sales_Product B二月 |45 % |100%三月 |78% |-87%...作者： 桑基特·乔希 Read Datasales_data.csvSales_Product_Alag 1Sales_Product_Blag 1Note: delete first rowA%B%int ->string+ %Calculate product A & B sales growth rateNote: advance--checked "Multi-row access"Remove the first row CSV Reader Lag Column Lag Column Math Formula Math Formula Column Filter String Manipulation(Multi Column) Column Expressions Row Filter

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: Admin
Created at: 2023-09-20
On NodePit since: 2023-09-20
Last update: 2024-11-21
Created with KNIME version: v5.1.1
Tags: JKISeason2-26

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

Try NodePit Runner!