Icon

Premier League Analysis

Dataset B: team positions
CSV Reader
Dataset A: wages
CSV Reader
to identify the team names on the scatter plot
RowID
matching team names to dataset B
String Manipulation
filtering to only 2023
Row Filter
making one dataset from team position + wages
Joiner
red (high risk) to green (low risk)
Color Manager
total wage bill for each team
Bar Chart
each player's weekly wage * 52 for an annual estimate
Math Formula
descending order
Sorter
sum of each player's wage combined with official wage bill
Joiner
total wage bill - each player's wage bill combined / 10000
Math Formula
filtering out the only two columns we need: team and annual sum of all players per team
GroupBy
abbreviation to full number
Math Formula
weekly wage inequality in each team
Box Plot
making the values smaller
Math Formula
amount of unaccounted costs in each team
Bar Chart
removing pound symbol and commas
String Manipulation
dataset C: financials
CSV Reader
turning text (wage) into real value
String to Number
filtering out the teams that were not playing that season
Row Filter
sort teams in descending order (based on season points)
Sorter
removes the three teams that were relegated (no data on the individual wages)
Row Filter
Bubble Chart (JFreeChart)
removing redundant column
Column Filter
points vs. wage-revenue-ratio (%)
Scatter Plot
money vs. position
Joiner
fixing header content
Row to Column Names

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: maxhallberg
Created at: 2025-12-04
On NodePit since: 2025-12-10
Last update: 2025-12-10
Created with KNIME version: v5.8.0

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

Try NodePit Runner!