Configuring scorecard

After selecting the source files of data to be scored, you need to configure the score card. Configuration involves:
  • Adding data quality dimensions on the basis of which scoring is to be performed
  • Adding and configuring rules for every DQ metric
  • Defining the threshold percentages for categorizing the data as bad, acceptable, or good
  1. On the Create Scorecard page, from the Entities list, select the entity for which you want to define the DQ dimensions and perform one of these steps, based on whether you want to select a DQ metric from the list or define a new one.
    1. Click the Add DQ Metric icon, and select the required parameter from Accuracy, Consistency, and Completeness.
    2. To define a new DQ metric, click Add DQ Metric, write your parameter where the cursor is blinking, and press the Enter button on your system.
    The selected DQ metric is displayed as a tab adjacent to the Add DQ Metric tab
  2. Click the Add rule button to create a rule for the DQ metric.
    The Add rule pop-up is displayed.
  3. Specify these rule details:
    Note: Avoid using anchor operators, such as ^ (beginning of line) and $ (end of line) in the regular expression, as these are not supported by Lucene’s regular expression engine.
    Fields Description
    Rule name Enter a name for the rule.
    Description Describe the rule.
    Rule Builder Build your rule by using the Select Column and Select Operator drop down lists.
    • The Select Column drop-down lists all the columns in the selected data source.
    • The Select Operator drop-down lists these operators: exists in, equals, ends with, contains, is not null, not equal, is not empty, starts with, matches, is null, and is empty.

    To build multiple conditions, click the Condition button, and use the AND OR slider to join the multiple conditions.

    To create another group of conditions, click the Group button.
    Note: You can drag the conditions set up and down and across the groups to build the rule.
    Rule Expression This field displays the rule you just built using the Rule Builder. See the example below:

  4. Click OK.
    You are navigated back to the Create Scorecard page, with the rule details displayed in a grid below the Add Rule button.
  5. To edit rule details, click the Edit rule icon in the Actions column.
  6. To delete the rule, click the Delete rule icon in the Actions column.
  7. Adjust the Threshold slider to define your score card as Bad, Acceptable, or Good.
    Note: Color coding for the slider:
    • Bad: Red
    • Acceptable: Yellow
    • Good: Green
  8. Click the forward arrow on the top right of the page to move to the next stage in creating scorecard.
    Note: At any point, to go back and edit details in the previous stage, click the backward arrow on the top right of the page.