Book Image

KNIME Essentials

By : Gábor Bakos
Book Image

KNIME Essentials

By: Gábor Bakos

Overview of this book

KNIME is an open source data analytics, reporting, and integration platform, which allows you to analyze a small or large amount of data without having to reach out to programming languages like R. "KNIME Essentials" teaches you all you need to know to start processing your first data sets using KNIME. It covers topics like installation, data processing, and data visualization including the KNIME reporting features. Data processing forms a fundamental part of KNIME, and KNIME Essentials ensures that you are fully comfortable with this aspect of KNIME before showing you how to visualize this data and generate reports. "KNIME Essentials" guides you through the process of the installation of KNIME through to the generation of reports based on data. The main parts between these two phases are the data processing and the visualization. The KNIME variants of data analysis concepts are introduced, and after the configuration and installation description comes the data processing which has many options to convert or extend it. Visualization makes it easier to get an overview for parts of the data, while reporting offers a way to summarize them in a nice way.
Table of Contents (11 chapters)

Importing data


There are many options to import data to a report. For example, you can use SQL databases and access them through JDBC; however, you can also use this feature to import KNIME nodes' exported tabular content with a proper JDBC driver, although this is not the recommended way.

The Data menu can be used to create a new data set, data cube, or data source.

Sending data and images to a report

The first thing you might notice after the install is that you have a new category named Reporting with two new nodes within Node Repository. The Data to Report node brings a table to the report as a data source and creates a data set for it.

There are not many configuration options here; one is where you can set how images within the table should be handled. For example, an image can be resized to a fixed size. Here, ideally the best option would be to use SVG, although using SVG is a bit harder. The node description gives a detailed description on how to use them; however, unfortunately, the...