Learning objective: In this exercise you will learn how to handle date&time data types and practice in-database data aggregation techniques.
Workflow description:
In Activity I, Date&Time nodes are used for filtering and extracting date information. The total sale amount is aggregated for each quarter then the resulting time series data is plotted.
In Activity II, the data processed in Activity I is written to a database. This data is then read from a database, and the total sale amount is aggregated for each quarter within the database.
Activity III demonstrates other database-related nodes and focuses on a use case of a DB Joiner node to filter data.
You will find the instructions to the exercises in the yellow annotations.