Icon

A) Example - EDA and Data Prep (Credit Card Upselling)

Lezione_01_v2

Data Wrangling in KNIME

Importing Data Data integration, selection & transformation EXPLORATORY DATA ANALYSIS DATA CLEANING & PREPARATION Framework: We are a Data Scientist team working in the Bank's Advanced Analytics & Customer Intelligence unitPrimary Business Goal: Create a Marketing Campaign to increase the upselling of a particular type of Credit Card ("Premium/Exclusive Credit Card").Analytical Goal: Analyse the collected data to define to develop a ML Scoring model to classify customers more prone to activate the service (i.e. the premium Credit Card). Import - target 0Import - target 1ConcatenationSort by record_idData cleaning and feature engineeringPost preparationEDAUnivariate EDABivariate EDAFIlter outcustomerswith complaintsComplaintsGroup by customer idExcludecomplaintsvariableReplace RowIDJoin tables CSV Reader CSV Reader Concatenate Sorter Data prep EDA POST Univariate Bivariate Row Filter Excel Reader GroupBy Column Filter RowID Joiner Importing Data Data integration, selection & transformation EXPLORATORY DATA ANALYSIS DATA CLEANING & PREPARATION Framework: We are a Data Scientist team working in the Bank's Advanced Analytics & Customer Intelligence unitPrimary Business Goal: Create a Marketing Campaign to increase the upselling of a particular type of Credit Card ("Premium/Exclusive Credit Card").Analytical Goal: Analyse the collected data to define to develop a ML Scoring model to classify customers more prone to activate the service (i.e. the premium Credit Card). Import - target 0Import - target 1ConcatenationSort by record_idData cleaning and feature engineeringPost preparationEDAUnivariate EDABivariate EDAFIlter outcustomerswith complaintsComplaintsGroup by customer idExcludecomplaintsvariableReplace RowIDJoin tables CSV Reader CSV Reader Concatenate Sorter Data prep EDA POST Univariate Bivariate Row Filter Excel Reader GroupBy Column Filter RowID Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: leonardo.trivelli
Created at: 2021-02-16
On NodePit since: 2026-03-05
Last update: 2026-03-05
Created with KNIME version: v5.2.1
Tags: CSV ReaderConcatenateJoinerMissing ValuesUnivariate StatisticsCorrelationsMissing ImputationOutliersANOVAKruskall-Wallis

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!