Financial analysis in KNIME

Case Study: Financial Analysis in KNIME

Andrew Logan

Data Scientist, 4&8 Ltd

Welcome!

Photo of the instructor, Andrew Logan

Screenshot of KNIME workflow that represents a completed financial analysis workflow

Case Study: Financial Analysis in KNIME

On the case

Business case

  • You're a financial analyst for the London Fire Brigade

Photo of fire engines and firefighters in a London street

Case Study: Financial Analysis in KNIME

On the case

Business case

  • You're a financial analyst for the London Fire Brigade
  • 3 months purchase data
  • View overall trends
  • View VAT data
  • Export detailed aggregations (for re-use and archive)

Generic photo of someone reviewing financial reports

Case Study: Financial Analysis in KNIME

On the case

Business case

  • You're a financial analyst for the London Fire Brigade
  • 3 months purchase data
  • View overall trends
  • View VAT data
  • Export detailed aggregations for re-use and archive

Considerations

  • Re-usable by non-technical users
  • Easy to understand automated process
Case Study: Financial Analysis in KNIME

What's the plan?

How do we get to where we want to go?

  • Plan a route
  • Use the business case as the destination
  • Plan out the process steps
  • Use annotations as signposts
  • Think of metanodes as towns

Image of a road map with a highlighted route

1 Photo by Stephen Monroe
Case Study: Financial Analysis in KNIME

One step at a time

Process Steps

  • Read the business case
  • Data access
  • Data cleaning and transformation
  • Data merging and aggregation
  • Data visualization and export
  • Confirm results answer business case

Illustration of a path in the air with some location tags. A figure is at the start of the path and moving along it

Case Study: Financial Analysis in KNIME

Getting started

Canvas outline KNIME workflow screenshot showing the relevant process steps

Case Study: Financial Analysis in KNIME

Getting started

KNIME canvas screenshot showing how to edit the workflow description

Case Study: Financial Analysis in KNIME

Summary

  • Financial analyst using KNIME to answer a business case
  • Data and business requirements
  • Plan
  • Check

Illustration of a path in the air with some location tags. A figure is at the start of the path and moving along it

Case Study: Financial Analysis in KNIME

Summary

  • Business case answered
  • Automated, re-usable and understandable
  • Re-use

KNIME workflow screenshot showing the relevant process steps

Case Study: Financial Analysis in KNIME

Let's practice!

Case Study: Financial Analysis in KNIME

Preparing Video For Download...