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.table1389Min Max Table Reader GroupBy GroupBy GroupBy 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.table1389Min Max Table Reader GroupBy GroupBy GroupBy

Nodes

Extensions

Links