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

KNIME workflow process with Merge and Aggregate highlighted

Case Study: Financial Analysis in KNIME

All in one

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

KNIME Merging nodes

Case Study: Financial Analysis in KNIME

Summarizing it all

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

KNIME Aggregation nodes

Case Study: Financial Analysis in KNIME

Using the right aggregations

  • Business case
Case Study: Financial Analysis in KNIME

Using the right aggregations

Row Aggregation illustration

Case Study: Financial Analysis in KNIME

Using the right aggregations

  • Business case
  • Row Aggregator
  • Groupby

GroupBy illustration

Case Study: Financial Analysis in KNIME

Using the right aggregations

  • Business case
  • Row Aggregator
  • Groupby
  • Pivot

Pivot illustration

Case Study: Financial Analysis in KNIME

Using the right aggregations

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

Illustration of chemistry experiment results

Case Study: Financial Analysis in KNIME

Let's practice!

Case Study: Financial Analysis in KNIME

Preparing Video For Download...