User Guide > Designing and Executing Data Profile > Data Quality Dimensions > How Data Quality Dimension Scores are Calculated
Was this helpful?
How Data Quality Dimension Scores are Calculated
This example describes in detail how data quality dimension scores are calculated. A dimension score reflects the overall quality of data/rules associated for a dimension.
Key points about calculating dimension scores:
• The dimension score is derived by aggregating individual pass results of rules in the dimension. Scores are 1-100, where 100 is highest quality.
• Rule weights factor into the individual pass results of rules. A rule weight is the user-assigned importance of the rule. Values are 1-5, where 5 is the most important. The default is 1.
• Individual pass results of rules are referred to as Weighted Pass %. The following equation is used to calculate the Weighted Pass % (score):
(Rule PASS Percentage * Weight)/Total Weights = Weighted Pass %
To illustrate the impact that rule weights have on a dimension score, we present three scenarios for the same dimension pass results, where:
• Scenario 1: Default Weights: All the rules have the default weight applied
• Scenario 2: One Varied Weight: A single rule has a higher weight
• Scenario 3: All Varied Weights: All the rules have different weights
Scenario 1: Default Weights
In this example, the dimension has three rules associated with it: Account_IsNotBlank, Email_IsNotBlank and Balance_IsNotBlank. The following are the profile execution Pass % results and scores, where all the rules have the default weight:
Rule
Pass %
Weight
Calculation
Weighted Pass %
Account_IsNotBlank
80%
1
(80*1)/(1+1+1)
26.66%
Email_IsNotBlank
70%
1
(70*1)/(1+1+1)
23.33%
Balance_IsNotBlank
65%
1
(65*1)/(1+1+1)
21.66%
 
 
 
Dimension Score
71%
Scenario 2: One Varied Weight
The following table shows the same profile execution Pass % results. But in this example, the Email_IsNotBlank rule has a weight of 5 assigned. Notice the impact on the Account_IsNotBlank rule Weighted Pass % value (which dropped 16 percent), and the Balance_IsNotBlank rule Weighted Pass % value (which dropped over 10 percent).
Rule
Pass %
Weight
Calculation
Weighted Pass %
Account_IsNotBlank
80%
1
(80*1)/(1+5+1)
11.42%
Email_IsNotBlank
70%
5
(70*5)/(1+5+1)
50%
Balance_IsNotBlank
65%
1
(65*1)/(1+5+1)
9.2%
 
 
 
Dimension Score
71%
Scenario 3: All Varied Weights
The following table shows the same profile execution Pass % results. But in this example, all the rules have varying weights.
Rule
Pass %
Weight
Calculation
Weighted Pass %
Account_IsNotBlank
80%
2
(80*2)/(2+3+4)
17.77%
Email_IsNotBlank
70%
3
(70*3)/(2+3+4)
23.33%
Balance_IsNotBlank
65%
4
(65*4)/(2+3+4)
28.88%
 
 
 
Dimension Score
71%
Last modified date: 01/08/2026