10 workflows in this folder and its subfolders
July 2019 · Importing Data Exercise 1 for KNIME User Training Import data from three different file formats (table, csv, xls) Import data from SQLite database VIDEO: Data Access https://youtu.be/VhGqECY1yNg VIDEO: File Reader https://youtu.be/flaHQw-Qhlg VIDEO: Table Reader https://youtu.be/tid1qi2HAOo VIDEO: E…
July 2019 · Data Manipulation Exercise 2 for KNIME User Training Concatenate data from two different sources Bring values from a reference table to the actual table using the Cell Replacer node Modify String values Join data from multiple tables Remove duplicates in the data VIDEO: Advaced ETL Functionalities a…
July 2019 · Visualization Exercise 3 for KNIME User Training Use different colors for different products in the data Visualize data in a Scatter Plot Pivot data by time and product Visualize data in a Line Plot and Stacked Area Chart Visualize data in a Bar Chart and Histogram and combine these views into a com…
July 2019 · Data Mining Exercise 4 for KNIME User Training Training a Decision Tree to predict a nominal target column Evaluate the model performance using scoring metrics for a classification model and an ROC Curve Train a linear regression model to predict a numeric target column Evaluate the performance of t…
July 2019 · Exporting Data Exercise 6 for KNIME User Training Writing data to a file Writing a model to a PMML model file Creating a BIRT report Exporting the report as pdf VIDEO: Deployment Options in KNIME https://youtu.be/Og7VZOJhsOc VIDEO: Producing a Simple Report with BIRT https://youtu.be/mLq6hgH9LS0 URL…
July 2019 · Flow Variables Exercise 7 for KNIME User Training Filtering rows by an attribute value Filtering rows by an attribute value that fulfils a condition and that is updated automatically Filtering rows based on a user selection Creating a component VIDEO: Flow Variables https://youtu.be/Y8hVkTvHR9I VIDE…
July 2019 · Date and Time Analysis Exercise 8 for KNIME User Training Constructing a timestamp from String values Converting String to Date&Time Filtering rows by a timestamp Extracting granularities from a timestamp Aggregating by time granularities Calculating moving average Calculating moving aggregation URL…
July 2019 · Workflow Control Exercise 9 for KNIME User Training Handling groups of data in separate iterations where the groups are defined by values in one or more columns Reading and concatenating many files Activating a workflow branch based on a user selection VIDEO: What is a Loop? https://youtu.be/h1uDSRX…
July 2019 · Advanced Data Mining Exercise 10 for KNIME User Training Training a Random Forest model to predict a nominal target column Evaluating the performance of a classification model Optimizing parameters of the Random Forest model Performing the classification multiple times in a cross validation loop VID…
July 2019 · Database Exercise 11 for KNIME User Training Writing data into a database Reading data from a database Aggregating data in a database Filtering data in a database Joining data in a database Reading data in a database into a KNIME table URL: Slides (KNIME Analytics Platform Course) https://www.knime.…