Overview

The KPI (key performance indicator) Alternatives Processor collects KPI Alternatives from the dataset input. Alternatives come with information about the column location (schema, table, column name), distinct values and formats, fill rate of the column and total amount of entries. 

Input

The processor has one input port. It requires a certain dataset suitable for a KPI analysis. Please read through the example for more detailed information. 

Configuration

Configuration interface (part 1)

Configuration interface (part 2)

• KPI Column: Select the column containing the KPI name
• Schema Column: Select the column containing the schema name
• Table Column: Select the column containing the table name
• Column name Column: Select the column containing the column name
• Filter Column: Select the column containing the SQL WHERE statement
• Probability Column: Select the column containing the probability. (How probable is the current alternative?)
• Total Count Column: Select the column containing the total value count. (How many entries does the current alternative have?)
• Fill Rate Column: Select the column containing the fill rate. (What is the percentage of valid entries in the current alternative?)
• Column Formats Column: Select the column containing information about the most common column format. (What are the most common formats of the entries in the current alternative?)
• Most frequent Values Column: Select the column containing information about the most common values. (What are the most frequent distinct values in the current alternative?)
• Separator: Specify a separator for the values in the most frequent formats and most frequent distinct values column. (Default is set to "\|")
• Probability Threshold for Preselection: Choose a threshold for the probability value. The most probable alternative for a KPI will be preselected automatically when its probability is over the given threshold. Must be a value between 0.0 and 1.0. Defaults to 0.5
• Preselections (leave empty): After executing the processor you can store its result inside its configuration and run it again obtaining all selected alternatives in the output, when switched ON. Default is OFF

Output

The processor itself contains results: An interactive table with the initial data and additional information on distinct values and data location.

The output port delivers a table with the KPI Alternatives.

Example

Workflow

Input

Configuration

Example: configuration of processor (Part 1)

Example: configuration of processor (Part 2)

KPI Column: KPI

Schema Column: SCHEMA

Table Column: TABLE

Column name Column: COLUMN

Filter Column: FILTER

Probability Column: PROBABILITY

Total Count Column: TOTAL_COUNT

Fill Rate Column: FILL_RATE

Column Formats Column: COLUMN_FORMAT

Most frequent Values Column: MOSTFREQUENTFORMATS

Separator: \|

Probability Threshold for Preselection: 0.6

Preselections (leave empty): [object Object],[object Object],[object Object],[object Object]

Results

The Processor itself delivers the results given below: 

Result delivered by the KPI Alternatives Processor

The attached Result Table Processor delivers the table below:

Related Articles

KPI Alternatives for Projects Processor