Chapter 7/Exercise 1
This is a simple reporting exercise using the nodes of the KNIME Reporting extension.
After reading and preprocessing the the Customer_data.xlsx data file, a Pivot table is generated that calculates the revenue for each year and quarter for online and onsite stores. Then, missing values are replaced by zero. Lastly, a category column is created ("Year/Quarter") and the columns are properly named.
After preparing the data for reporting, the data visualized in the "Quarterly Sales Trend" component and exported as static PDF.
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.