Based on a comprehensive quality scoring system, the quality report provides detailed data quality scores for various dimensions, including comprehensive quality score, dimension quality score, and table quality score. Users can define the statistical scope (statistical date, data source, database, data table) and choose a scoring model that meets business needs to generate quality reports. It supports one-click sharing and report export.
Note:
Quality report data supports system automatic updates (daily at 1:00 AM) and manual recalculation triggered by users after modifying dimension weights. The specific update method and update time will be prompted.
Scoring Logic
Quality scores in the quality report are calculated based on the selected scoring model, using the Rule Quality Score as the basis. It calculates according to the user-defined filter range (statistical date, data source, database, data table) and the dimension-defined rule range, forming table quality score, database quality score, dimension quality score, and comprehensive quality score.
Dimension Quality Score
Scoring Model
Calculation Formula
Rule Quality Score
-
This rule tests the pass rate (Number of successful executions / Execution Total) x 100
Table Quality Score
Calculated by full dimension weight
∑(AVG(Rule quality score of the same dimension associated with the table) * Weight of the dimension) / ∑Dimension weights
Calculated by configured dimension weight
∑(AVG(Rule quality score of the same dimension associated with the table) * Weight of the dimension) / ∑Configured rule dimension weights
Not calculated based on dimension weights
AVG(All rules quality scores associated with the table)
Library Quality Score
-
∑(Table quality scores) / Number of tables participating in detection within the selected range
Dimension Quality Score
-
∑(Quality scores of the same dimension tables) / Number of tables participating in detection in the dimension
Comprehensive Quality Score
-
∑(Table quality scores) / Number of tables participating in detection within the selected range
Note:
Rules associated with the table include table-level and relevant rules configured within the table. For library, dimension, and comprehensive quality scores, the calculation formulas are the same under different scoring modes, but the table quality scores used for calculation differ.
Operation Details
Comprehensive Quality Score
Provides global quality score data, where users can view the trend chart of the last 7 or 30 days and the Average Overall Quality Score Within the Cycle.
Dimension Quality Score
Displays the scores of six major dimensions: Accuracy, Uniqueness, Integrity, Consistency, Timeliness, and Validity. It supports user-defined scoring weights for each dimension, weight setter, weight update time, and the number of evaluation forms. All this information will be recorded and displayed.
Note:
1. Only project administrators have the authority to modify dimension weights. By default, changes take effect the next day, but users can also choose to apply changes immediately to manually trigger recalculation. Supports recalculation of historical scores for up to the past 60 days using the modified dimension weight values.
2. Dimension weights are global. When selecting the first two scoring modes (Full Dimension, Configured Rule Dimension), changes will affect all scores, including Comprehensive Quality Score, Dimension Quality Score, Database Quality Score, and Table Quality Score once they take effect.
3. Report Recalculation Status will give a synchronized prompt. When the quality score is in the process of recalculation, the Dimension Weight Entry will be grayed out until recalculation is complete. Then, modifying the dimension weight will be supported again.
