KNIME Essentials -- Table of Contents -- KNIME Essentials -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Installing and Using KNIME -- Few words about KNIME -- Installing KNIME -- Installation using the archive -- KNIME for Windows -- KNIME for Linux -- KNIME for Mac OS X -- Troubleshooting -- KNIME terminologies -- Organizing your work -- Nodes -- Node lifecycle -- Meta nodes -- Ports -- Data tables -- Port view -- Flow variables -- Node views -- HiLite -- Eclipse concepts -- Preferences -- Logging -- User interface -- Getting started -- Setting preferences -- KNIME -- Other preferences -- Installing extensions -- Workbench -- Workflow handling -- Node controls -- HiLite -- Variable flows -- Meta nodes -- Workflow lifecycle -- Other views -- Summary -- 2. Data Preprocessing -- Importing data -- Importing data from a database -- Starting Java DB -- Importing data from tabular files -- Importing data from web services -- REST services -- Importing XML files -- Importing models -- Other formats -- Public data sources -- Regular expressions -- Basic syntax -- Partial versus whole match -- Usage from Java -- References and tools -- Alternative pattern description -- Transforming the shape -- Filtering rows -- Sampling -- Appending tables -- Less columns -- Dimension reduction -- More columns -- GroupBy -- Pivoting and Unpivoting -- One2Many and Many2One -- Cosmetic transformations -- Renames -- Changing the column order -- Reordering the rows -- The row ID -- Transpose -- Transforming values.

Generic transformations -- Java snippets -- The Math Formula node -- Conversion between types -- Binning -- Normalization -- Text normalization -- Regular expressions -- Multiple columns -- XML transformation -- Time transformation -- Smoothing -- Data generation -- Generating the grid -- Constraints -- Loops -- Workflow customization -- Case study - finding min-max in the next n rows -- Case study - ranks within groups -- Summary -- 3. Data Exploration -- Computing statistics -- Overview of visualizations -- Visual guide for the views -- Distance matrix -- Using visual properties -- Color -- Size -- Shape -- KNIME views -- HiLite -- Use cases for HiLite -- Row IDs -- Extreme values -- Basic KNIME views -- The Box plots -- Hierarchical clustering -- Histograms -- Interactive Table -- The Lift chart -- Lines -- Pie charts -- The Scatter plots -- Spark Line Appender -- Radar Plot Appender -- The Scorer views -- JFreeChart -- The Bar charts -- The Bubble chart -- Heatmap -- The Histogram chart -- The Interval chart -- The Line chart -- The Pie chart -- The Scatter plot -- Open Street Map -- 3D Scatterplot -- Other visualization nodes -- The R plot, Python plot, and Matlab plot -- The official R plots -- The RapidMiner view -- The HiTS visualization -- Tips for HiLiting -- Using Interactive HiLite Collector -- Finding connections -- Visualizing models -- Further ideas -- Summary -- 4. Reporting -- Installation of the reporting extensions -- Reporting concepts -- Importing data -- Sending data and images to a report -- Importing from other sources -- Joining data sets -- Preferences -- Using the designer -- In visible views -- Report properties -- Report items -- Label -- Text -- Binding -- Dynamic text -- Data -- Image -- Grid -- List -- Groups -- Sorting -- Filters -- Table -- Chart -- Cross Tab -- Setting up -- Changing -- Using data cubes.

Quick Tools -- Aggregation -- Relative time period -- Generating reports -- Using colors -- Using HiLite -- Using workflow variables -- Suggested readings -- Summary -- Index.