Export Data into a BIRT Report

BIRT (Business Intelligence Reporting Tool) is a reporting solution with an open source component. The open source component is integrated within KNIME Analytics Platform via its KNIME Report Designer extension.

In the following video, we demonstrate how to create a simple BIRT report using a table and figure generated within KNIME Analytics Platform. We discuss editing headers, footers, and report layout. We also briefly show how to export the report to a web browser or other preferred file formats.

Exercise

Read the adult.csv file. Then, in a KNIME workflow:

• Create a pivot table, by workclass, that counts the number of records for each income class
• Sort the pivoted table by workclass
• Send the data to BIRT for use in a report
• In the BIRT Report editor, use a grid to layout the following elements:
  • A report title
  • A formatted pivot table
  • BONUS: a bar chart of counts with workclass on the X-axis, and income classes in two different series on the Y-axis