Scorecards
The scorecard provides the following types of details:
- •Top issues
- •Field scores
- •Individual scores
- •Overall score
- •Trend chart
Top Issues
The Top Issues area of the scorecard shows the top issues based on the results of all quality metrics included in the Data Assessment task. For example, if you included the Duplicates and Address Validation quality metrics in the Data Assessment task, this area provides the top issues for both quality metrics.
The Top Issues area rounds percentages up to the nearest percent. For example, if 6 out of 100,000 records are incomplete, the Top Issues area shows 1% incomplete.
Use the Top Issues area to identify higher-priority data quality issues with the data for the associated Salesforce object.
Field Scores
The Field Scores area of the scorecard shows field scores for Completeness and Conformance quality metrics. The Field Scores area shows the number of records that have complete or conforming data for each field included in the quality metric.
For example, a scorecard shows the following field scores:
Field | Complete | Conformant |
|---|
Billing Street | 19745 | |
Created Date | 20000 | |
Fax | 14 | 11 |
Total number of records: 20000 |
The Field Scores area provides the following details:
- •The Data Assessment task analyzed 20,000 records based on the Completeness and Conformance quality metrics.
- •19,745 records contain values for the Billing Street field.
- •All 20,000 records contain values for the Created Date field.
- •14 records contain values for the Fax field.
- •11 records have values in the Fax field that conform.
A blank value in the Conformant column indicates that no conformance quality check was performed on the field. 0 appears in the Conformant column if no fields conform.
Individual Scores
The Individual Scores area of the scorecard provides an individual score for each quality metric included in the Data Assessment task.
The dashboard provides individual scores for the following quality metrics:
Quality Metric | Description of Individual Score |
|---|
Address Validation | Percentage of address fields included in the quality metric that have valid addresses. |
Completeness | Percentage of fields included in the quality metric that have values that are not null or blank. |
Conformance | Percentage of fields included in the quality metric that conform. |
Non-Duplicates | Percentage of records that are not duplicates. |
Overall Score
The Overall Score area of the scorecard provides an overall score for the Data Assessment task. The overall score is the average of all individual scores for the Data Assessment task.
Trend Chart
The Trend Chart area of the scorecard shows the history of individual scores for each quality metric included in the Data Assessment task. Place the cursor over the lines in the chart to view individual scores for particular data quality jobs. If you run the Data Assessment task three times, you see individual scores for the quality metrics for each of the three jobs. You must run the Data Assessment task at least two times to see results in the trend chart.
Use the trend chart to monitor improvements or degradations in data quality over time. For example, you run a Data Assessment task and notice a large percentage of duplicate rows. You remove some of the duplicate rows, and then run the Data Assessment task again to determine the new percentage of duplicate rows. Use the trend chart to visually display the change in the duplicate scores.