How is Readiness Score calculated for rules ?

Readiness score is a measure that identifies data quality in terms of percentage of clean, meaningful data among coarse records.  It gives a precise overview to the managers and helps them to take relevant decisions.

Readiness score is calculated based on different types of rules. The chart below describes how the score is calculated for each of DvSum rules. 

 

Validation Rule Readiness Score Calculation
  • Count
  • Count distinct
  • SUM
  • CUSTOM QUERY
  • MANUAL

1) If results are less than or same as threshold minimum, and threshold minimum is zero, then readiness score is 100 %.


2) If results are less than or same as threshold minimum, then readiness score is (results/Threshold minimum) *100.


3) If results are greater than or same as 2 times of threshold maximum. Then readiness score is zero.


4) If results are greater than or same as threshold maximum. Then readiness score is (1 - (results thresholdmax) / thresholdmax) * 100

  • Blank Check
  • Value Range
  • DAE – Data Analysis Exceptions
  • Size Check
  • MDC Ruleset
  • Orphan Records
  • Cross Dataset
  • Integrity Check
  • Orphan Keys
  • RCL -X-System Reconciliation
  • Document
  • Matching
  • Address Validation
  • Data Format

1) If there are no exceptions, then readiness score is 100%.


2) If there are exceptions, then readiness score percentage is calculated as (total records – exception records) *100 / (total records).

  • Compare count
  • Compare Table
  • Compare Custom Query
  • Metric Value not selected on either Target or Reference

1) If results are less than or same as reference result, then readiness score is (result/reference result) *100


2) If results are greater than or same as 2 times of reference result. Then readiness score is zero.


3) If results are greater than or same as reference result. Then readiness score is (1 - (results – reference result)/ reference result) * 100.

  • Runtime Elapsed

1) (Difference in the minutes/Threshold) rounded to two digits.


2) (Rounded result -1)*100


3) If the result from step 2 is not between 0 and 100, then readiness score is 0, else the readiness score is equal to step 2.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk