Icon

Simple Reporting Example

This is a simple example of a KNIME workflow as source for a report.

The report shows the distribution of income over the work class.

Requirements:
- KNIME Report Designer

Data ReadingRead the adult data set file. There isone row for each person, plusdemographic info and the incomegroup. The file is located in TheData/Basics/ Graphical PropertiesAssign colors by income group. Simple Reporting ExampleReports are a great way to describe, visualize, and share KPIs (Key Performance Indicators). The open source version of BIRT is installed as a reporting tool with KNIME Analytics Platform Reporting extension. This workflowillustrates a basic reporting example from the adult data set.Task Based on values from the adult data set (census data), this workflow builds a report to show the distribution of income over the workclass.Learning Hub http://www.knime.org/learning-hub contains useful links, e.g. tutorials, videos, books, slides, etc... for each kind of data analytics topic. Pre-processing - Pivot the variable income, group per work class and aggregate (count) byage- Sort the data (ascending) by workclass Display the results in a ReportExport the results together with work class income to the report. Try this:Create your own report:1) Execute the entire workflow2) Click the “Open the report” button in thetoolbar (make sure that the KNIME ReportDesigner extension is installed. If not, go to File,then Install KNIME Extensions/KNIME ReportDesigner)3) Select “Run” from the Report environment4) Choose your preferred format to see the finalreport.Note: If you have changed the KNIMEWorkbench, click View/Reset Perspective to seeall panels in the Report Designer. Red for income "<=50K"Blue for income ">50K"By work classWork class - incomePivot the variable incomeReading adult.csv Color Manager Sorter Data to Report Pivoting CSV Reader Data ReadingRead the adult data set file. There isone row for each person, plusdemographic info and the incomegroup. The file is located in TheData/Basics/ Graphical PropertiesAssign colors by income group. Simple Reporting ExampleReports are a great way to describe, visualize, and share KPIs (Key Performance Indicators). The open source version of BIRT is installed as a reporting tool with KNIME Analytics Platform Reporting extension. This workflowillustrates a basic reporting example from the adult data set.Task Based on values from the adult data set (census data), this workflow builds a report to show the distribution of income over the workclass.Learning Hub http://www.knime.org/learning-hub contains useful links, e.g. tutorials, videos, books, slides, etc... for each kind of data analytics topic. Pre-processing - Pivot the variable income, group per work class and aggregate (count) byage- Sort the data (ascending) by workclass Display the results in a ReportExport the results together with work class income to the report. Try this:Create your own report:1) Execute the entire workflow2) Click the “Open the report” button in thetoolbar (make sure that the KNIME ReportDesigner extension is installed. If not, go to File,then Install KNIME Extensions/KNIME ReportDesigner)3) Select “Run” from the Report environment4) Choose your preferred format to see the finalreport.Note: If you have changed the KNIMEWorkbench, click View/Reset Perspective to seeall panels in the Report Designer. Red for income "<=50K"Blue for income ">50K"By work classWork class - incomePivot the variable incomeReading adult.csv Color Manager Sorter Data to Report Pivoting CSV Reader

Nodes

Extensions

Links