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 is one row for eachperson, plus demographic infoand the income group. Thefile is located in TheData/Basics/ Graphical PropertiesAssign colors by incomegroup. 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 KNIMEAnalytics Platform Reporting extension. This workflow illustrates 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 andaggregate (count) by age- Sort the data (ascending) by workclass Display the results in a ReportExport the results together with work class income tothe report. Try this:Create your own report:1) Execute the entire workflow2) Click the “Open the report” buttonin the toolbar (make sure that theKNIME Report Designer extension isinstalled. If not, go to File, then InstallKNIME Extensions/KNIME ReportDesigner)3) Select “Run” from the Reportenvironment4) Choose your preferred format tosee the final report.Note: If you have changed the KNIMEWorkbench, click View/ResetPerspective to see all panels in theReport 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 File Reader Data ReadingRead the adult data set file.There is one row for eachperson, plus demographic infoand the income group. Thefile is located in TheData/Basics/ Graphical PropertiesAssign colors by incomegroup. 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 KNIMEAnalytics Platform Reporting extension. This workflow illustrates 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 andaggregate (count) by age- Sort the data (ascending) by workclass Display the results in a ReportExport the results together with work class income tothe report. Try this:Create your own report:1) Execute the entire workflow2) Click the “Open the report” buttonin the toolbar (make sure that theKNIME Report Designer extension isinstalled. If not, go to File, then InstallKNIME Extensions/KNIME ReportDesigner)3) Select “Run” from the Reportenvironment4) Choose your preferred format tosee the final report.Note: If you have changed the KNIMEWorkbench, click View/ResetPerspective to see all panels in theReport 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 File Reader

Nodes

Extensions

Links