Icon

L2-DW Final Assessment Workflow

This workflow contains the final assessment of the L2-DW self-paced course. Solve the workflow and complete the quiz at the end of the course!

URL: KNIME Self-Paced Courses https://www.knime.com/knime-self-paced-courses

Task 2. ComponentsCalculate for each year the average invoice total sum. Some invoice have missing value in theCustomer ID column. Create a component that can be configured to include or exclude those entries.You want to know, for each invoice, if its total sum is above or below the yearly average. Question: How many invoiceschange labels above/belowwhen rows with missing valuesare included/excluded? Task 1. ManipulationGet the total price of each transaction by multiplying the quantity with the unitprice. Get a table containing the following fields for each invoice- Invoice id- Number of Items- Number of Unique Items- Invoice Total Sum- Invoice Date- Customer ID- Invoice Year Question: Howmany invoices arepresent in the table? Question: What are theminimum andmaximum year for theinvoices? Question: Which invoicehas the highest numberof unique items? Question: Including entries withmissing Customer ID, what isthe number of invoices abovethe yearly average? transactions.tableNode 2Node 3Node 4Node 5Node 6Node 7Node 11 Table Reader Math Formula GroupBy Extract Date&TimeFields Column Filter Excel Writer GroupBy Excel Writer Task 2. ComponentsCalculate for each year the average invoice total sum. Some invoice have missing value in theCustomer ID column. Create a component that can be configured to include or exclude those entries.You want to know, for each invoice, if its total sum is above or below the yearly average. Question: How many invoiceschange labels above/belowwhen rows with missing valuesare included/excluded? Task 1. ManipulationGet the total price of each transaction by multiplying the quantity with the unitprice. Get a table containing the following fields for each invoice- Invoice id- Number of Items- Number of Unique Items- Invoice Total Sum- Invoice Date- Customer ID- Invoice Year Question: Howmany invoices arepresent in the table? Question: What are theminimum andmaximum year for theinvoices? Question: Which invoicehas the highest numberof unique items? Question: Including entries withmissing Customer ID, what isthe number of invoices abovethe yearly average? transactions.tableNode 2Node 3Node 4Node 5Node 6Node 7Node 11 Table Reader Math Formula GroupBy Extract Date&TimeFields Column Filter Excel Writer GroupBy Excel Writer

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: emilio.silvestri
Created at: 2022-12-23
On NodePit since: 2025-03-14
Last update: 2025-03-31
Created with KNIME version: v5.2.3
Tags: l2-dweducation

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

Try NodePit Runner!