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!

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 3Node 5Node 6Node 8Node 9Node 10Node 11Node 13 Table Reader Column Rename Math Formula Column Filter String to Date&Time Date&Time to String Extract Date&TimeFields GroupBy GroupBy Component 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 3Node 5Node 6Node 8Node 9Node 10Node 11Node 13Table Reader Column Rename Math Formula Column Filter String to Date&Time Date&Time to String Extract Date&TimeFields GroupBy GroupBy Component

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: 2023-06-06
Last update: 2024-04-28
Created with KNIME version: v4.7.2
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!