Is there someone auditing controls using KNIME? If so, could you please share insights on how to validate completeness and accuracy from this tool?

943 viewscircle icon1 Comment
Sort by:
Finance Analyst2 years ago

To validate data completeness: use the "Missing Value" node to identify columns with missing values, use "GroupBy" node to calculate the percentage of missing values for each column (or aggregation nodes), set a threshold for acceptable missing values (e.g., 5% or 10%) and filter out columns exceeding this threshold.

To validate data accuracy: identify the reference or trusted data source that represents accurate values for comparison, use the "Joiner" node to join or merge your data with the reference data, generate summary statistics on the discrepancies, such as mean, median, standard deviation, etc. and use the visualization nodes to visualize the discrepancies.

Content you might like

Lack of mature vendor solutions42%

Trust in AI accuracy62%

Budget constraints17%

Skills to operate the tools28%

View Results

90 Days12%

365 Days40%

3 years31%

5 years9%

7 years9%

Other (share in the comments)

View Results