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 unit Primary 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 0
CSV Reader
Import - target 1
CSV Reader
Concatenation
Concatenate
Sort by record_id
Sorter
Replace RowID
RowID
Group by customer id
GroupBy
Exclude complaints variable
Column Filter
Univariate EDA
Univariate
Bivariate EDA
Bivariate
Data cleaning and feature engineering
Data prep
Join tables
Joiner
Post preparation EDA
EDA POST
FIlter out customers with complaints
Row Filter (deprecated)
Complaints
Excel Reader

Nodes

Extensions

Links