Icon

Exercise1

<p><strong>Chapter 7/Exercise 1</strong></p><p>This is a simple reporting exercise using the nodes of the KNIME Reporting extension.</p><p>After reading and preprocessing the the <em>Customer_data.xlsx</em> 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.</p><p>After preparing the data for reporting, the data visualized in the "Quarterly Sales Trend" component and exported as static PDF.</p>

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.

Nodes

Extensions

Links