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.

Workflow: 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.

Reading data

Preparing data for reporting

Create report and export as static PDF

Customer_data.xlsx
Excel Reader
Create a new column as a combination:"Year/Quarter"
Expression
Groups: Quarter, YearPivot: StoreTypeAggregation: sum of Price
Pivot
Replace missing valueswith zeros
Missing Value
Generating a reportwith a header anda stacked area chart
Quarterly Sale Trend
Processing the transactiondate column
Date&Time Processing
Renaming pivotcolumns
Column Renamer
Setting the size andthe orientation ofthe report
Report Template Creator
Saving the reportas a PDF file
Report PDF Writer

Nodes

Extensions

Links