Icon

FinOps & Compliance

BLOCK 1 — INGEST & STANDARDIZE INPUT DATA

Mock data used for local demo. In production, these inputs could be replaced by cloud billing exports, cloud storage, databases, or APIs.

BLOCK 2 — ENRICH CLOUD COST DATA WITH INTERNAL ASSET REGISTRY

Join cloud billing records to the internal application registry to create ownership, cost center, country, and risk context.

BLOCK 3 — AUTOMATED TAGGING & COMPLIANCE CONTROL CHECKS

Apply rule-based checks to detect orphaned resources, missing mandatory tags, ownership gaps, cost center mismatches, and risk-sensitive exceptions.

BLOCK 4 — FINOPS KPIS & LOCAL DATA APP PREVIEW

Calculate cost attribution, tagging compliance, unit economics, and create a local preview of the stakeholder-facing Data App.

Prepares policy metadata if you want to reference it in later reporting.
String Manipulation
Column Renamer
Add KPI join key to total
Constant Value Column Appender
Tag policy — standardized
String Manipulation
Add KPI join key to compliant
Constant Value Column Appender
Cloud billing — standardized
Column Filter
Executive KPI base table
Joiner
Add KPI join key to non-compliant
Constant Value Column Appender
Joiner
Check registry rows
Extract Table Dimension
Attributed Spend Share
Math Formula
Check business metrics rows
Extract Table Dimension
Executive KPI table
Column Filter
Asset registry — standardized
Column Filter
Calculate tagging compliance rate
Math Formula
Check cloud billing rows
Extract Table Dimension
Calculate compliant spend share
Math Formula
Rename a few columns so it is clear what came from the cloud tags and what came from the internal registry.
Column Renamer
Registry Match Status
Rule Engine
Check tag policy rows
Extract Table Dimension
This joins every cloud resource/cost row to the internal asset registry using application_id_clean.
Joiner
Column Renamer
Pivot compliance cost by status
Pivot
Cost and compliance by business unit
GroupBy
Cost Center Match Status
Rule Engine
Calculate total cost by business unit
Math Formula
Environment Match Status
Rule Engine
Calculate non-compliant cost rate
Math Formula
Missing Value
Ownership Status
Rule Engine
Column Renamer
Color Manager
Column Renamer
Owner Tag Check
Rule Engine
Enriched cloud billing data
Column Filter
Sort business units by non-compliant cost
Sorter
Table View
Monthly cost by business unit and country
GroupBy
Data Classification Check
Rule Engine
Environment Tag Check
Rule Engine
Cost Center Tag Check
Rule Engine
Reads Dataset 1: mock cloud billing/resource data.
Excel Reader
Standardizes missing tag values so your rule logic in later blocks works predictably.
Missing Value
Creates a cleaned environment column so that Prod, prod, PROD, or missing values are handled consistently.
String Manipulation
Creates a cleaned cost center column for matching with the internal registry later.
String Manipulation
Creates a clean application ID column for the join in Block 2.
String Manipulation
Excel Reader
Join cloud cost with business metrics
Joiner
Calculate cost per active banking user
Math Formula
Clean business unit for metrics join
String Manipulation
Clean country for metrics join
String Manipulation
High Cost Untagged Check
Rule Engine
Sort unit economics by cost per user
Sorter
Overall Compliance Status
Rule Engine
Unit economics table
Column Filter
Registry / Orphan Check
Rule Engine
Calculate cost per digital transaction
Math Formula
Critical Risk Check
Rule Engine
Calculate cost per customer account
Math Formula
Suggested Remediation
Rule Engine
Split non-compliant vs compliant
Row Splitter
Exception Severity
Rule Engine
Exception Category
Rule Engine
Compliance exceptions
Column Filter
Compliant resources
Column Filter
Business metrics for unit economics
Column Filter
Sorts the exception table so the most important issues appear first.
Sorter
Missing Value
Local FinOps Data App Preview
Component
Calculate total cloud cost
GroupBy
Column Renamer
Prepares the registry cost center for comparison with the cloud tag cost center.
String Manipulation
Column Renamer
Missing Value
Table View
Column Renamer
Control checked cloud resources
Column Filter
Column Renamer
Standardizes missing registry values.
Missing Value
Handles blank notes and protects against missing numeric fields.
Missing Value
Column Renamer
Creates the join key for Block 2.
String Manipulation
String Manipulation
Filter compliant resources
Row Filter
Prepares the expected environment for later mismatch checks.
String Manipulation
Filter non-compliant resources
Row Filter
Column Renamer
Reads Dataset 3: business metrics for unit economics.
Excel Reader
Calculate non-compliant cost
GroupBy
Reads Dataset 4: mock tag control policy.
Excel Reader
Ensures policy descriptions do not contain blank cells.
Missing Value
String Manipulation
Calculate compliant cost
GroupBy
Business metrics — standardized
Column Filter

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: VinceBoom
Created at: 2026-06-08
On NodePit since: 2026-06-12
Last update: 2026-06-12
Created with KNIME version: v5.11.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!