Icon

06 Data Export and Reporting - Solution

Data Export and Reporting - Exercise (Solution)

This workflow shows a solution to a hands-on exercise in the L1-DS Introduction to KNIME Analytics Platform for Data Scientists - Basics course

Increase the image size in the Image to Reportnode if the image quality is poor in the report Task 2: Reporting1. Execute the prebuilt workflow. It preprocesses and visualizes the adult dataset. 2. Send the sorted data and bar chart image to BIRT for use in a report3. Open the BIRT Report editor and place the pivot table and the bar chart image in the preformatted template. Customize the layoutof the report if you want.4. Generate the report in one of the available formats Task 1: Write Data to a File1. Read the adult_joined.table file by executing the Table Reader node2. Calculate the total number of rows and average age by gender and income class3. Write the resulting table as a CSV file into the data folder Create a pivot table, byworkclass, that counts the number of recordsfor each income classSort the pivoted tableby workclassAssign colors toincome classes A bar chart of countswith workclassBar chartPivot tableRename missingworkclass as "Unknown" Read data adult_joined.table Write the resultingtable as a CSV file The total number of rows and average agePivoting Sorter Color Manager Bar Chart ExtractColumn Header Transpose Image to Report Data to Report Rule Engine Table Reader CSV Writer GroupBy Increase the image size in the Image to Reportnode if the image quality is poor in the report Task 2: Reporting1. Execute the prebuilt workflow. It preprocesses and visualizes the adult dataset. 2. Send the sorted data and bar chart image to BIRT for use in a report3. Open the BIRT Report editor and place the pivot table and the bar chart image in the preformatted template. Customize the layoutof the report if you want.4. Generate the report in one of the available formats Task 1: Write Data to a File1. Read the adult_joined.table file by executing the Table Reader node2. Calculate the total number of rows and average age by gender and income class3. Write the resulting table as a CSV file into the data folder Create a pivot table, byworkclass, that counts the number of recordsfor each income classSort the pivoted tableby workclassAssign colors toincome classes A bar chart of countswith workclassBar chartPivot tableRename missingworkclass as "Unknown" Read data adult_joined.table Write the resultingtable as a CSV file The total number of rows and average agePivoting Sorter Color Manager Bar Chart ExtractColumn Header Transpose Image to Report Data to Report Rule Engine Table Reader CSV Writer GroupBy

Nodes

Extensions

Links