Icon

06 Data Export and Reporting LAB

Data Export and Reporting - Exercise

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

Increase the image size in theImage to Report node if the imagequality 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 thepreformatted template. Customize the layout of 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 I am unsure as of how to complete thistask if the prebuilt workflow doesn't applyto this data for the lab. I do plan on scheduling a time with you inhopes of doing some of these taskstogether that I am struggling with Create a pivot table, byGender, that counts the number of median monthly chargesfor churnSort the pivoted tableby workclassAssign colors toincome classesA bar chart of countswith workclassBar chartPivot table Write the resultingtable as a CSV fileMedian Total charges based on device protection and monthly chargesProvided FilePivoting Sorter Color Manager Bar Chart ExtractColumn Header Transpose Image to Report Data to Report CSV Writer GroupBy Excel Reader Increase the image size in theImage to Report node if the imagequality 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 thepreformatted template. Customize the layout of 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 I am unsure as of how to complete thistask if the prebuilt workflow doesn't applyto this data for the lab. I do plan on scheduling a time with you inhopes of doing some of these taskstogether that I am struggling with Create a pivot table, byGender, that counts the number of median monthly chargesfor churnSort the pivoted tableby workclassAssign colors toincome classesA bar chart of countswith workclassBar chartPivot table Write the resultingtable as a CSV fileMedian Total charges based on device protection and monthly chargesProvided FilePivoting Sorter Color Manager Bar Chart ExtractColumn Header Transpose Image to Report Data to Report CSV Writer GroupBy Excel Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2023-02-26
Last update: 2024-04-28
Created with KNIME version: v4.7.0
Tags: BIRTreporteducationwrite

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!