Merging and aggregating data

Case Study: Financial Analysis in KNIME

Andrew Logan

Data Scientist, 4&8 Ltd

Back to the plan

• Cleaned and transformed data

• Merging: combining into one consistent table

• Aggregating: summarizing data as defined in the business case

All in one

• Most common nodes:
  • Value Lookup, Concatenate, Joiner
• Deduplicate
• Annotate!

Summarizing it all

• Most common nodes:
  • Row Aggregator, GroupBy, Pivot
• Keep it simple and check

Using the right aggregations

• Business case

Using the right aggregations

• Business case
• Row Aggregator

Using the right aggregations

• Business case
• Row Aggregator
• Groupby

Using the right aggregations

• Business case
• Row Aggregator
• Groupby
• Pivot

Using the right aggregations

• Business case
• Row Aggregator
• Groupby
• Pivot
• Experiment

Let's practice!

Case Study: Financial Analysis in KNIME