Icon

L2-DS Final Assessment Workflow

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

Task 1. Date & TimeShift the time zone to Australia/Canberra if the transaction happened in this country.Get the total price of each transaction by multiplying the quantity with the unit price Task 3. LoopsGet a table containing, for each year and month, the amount spent and the number ofitems bought by each customer Task 2. ComponentsCreate a component able to- Filter data according to the Country column- Calculate the daily total sum- Calculate the moving average of the total sum. Make the window size a configurableparameter of the component.- Sort the data according to the date column- Create a line plot in order to monitor the values of the moving average over time. Question: Which customerbought the biggest amount ofitems in April 2010? Question: Which countries arelisted in the country column? Question: Configure thecomponent to filter entries whereCountry= Australia and calculatethe moving average with a windowsize of 7. Does the moving averageever exceeds 2000? Question: Which of thefollowing are possibleoptions offered by theModify Time Zonenode? Question: How many iterationsdoes the Group Loop run? transactions.tableNode 27Node 28Node 38Node 39Node 40Node 41 Table Reader Modify Time Zone Math Formula Component Group Loop Start Loop End Modify Time GroupBy Task 1. Date & TimeShift the time zone to Australia/Canberra if the transaction happened in this country.Get the total price of each transaction by multiplying the quantity with the unit price Task 3. LoopsGet a table containing, for each year and month, the amount spent and the number ofitems bought by each customer Task 2. ComponentsCreate a component able to- Filter data according to the Country column- Calculate the daily total sum- Calculate the moving average of the total sum. Make the window size a configurableparameter of the component.- Sort the data according to the date column- Create a line plot in order to monitor the values of the moving average over time. Question: Which customerbought the biggest amount ofitems in April 2010? Question: Which countries arelisted in the country column? Question: Configure thecomponent to filter entries whereCountry= Australia and calculatethe moving average with a windowsize of 7. Does the moving averageever exceeds 2000? Question: Which of thefollowing are possibleoptions offered by theModify Time Zonenode? Question: How many iterationsdoes the Group Loop run? transactions.tableNode 27Node 28Node 38Node 39Node 40Node 41Table Reader Modify Time Zone Math Formula Component Group Loop Start Loop End Modify Time GroupBy

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-22
On NodePit since: 2023-07-03
Last update: 2024-11-17
Created with KNIME version: v4.7.4
Tags: l2-dseducation

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

Try NodePit Runner!