For the complete documentation index, see llms.txt. This page is also available as Markdown.

Data Quality Last Execution Dashboard

The Data Quality Last Execution Dashboard provides a consolidated view of the most recent Data Quality Rule execution results across the organization. The dashboard displays both an overall Data Quality index and dimension-level execution statistics, enabling users to monitor Data Quality performance, identify validation issues, and assess the overall health of data assets.

The dashboard retrieves the latest execution result for each associated object and Data Quality Rule, ensuring that only the most recent validation outcomes are included in the analysis.

Dashboard Overview

The dashboard displays execution statistics using interactive doughnut charts that summarize Data Quality Rule execution results based on the following statuses:

  • Passed Objects – Objects that successfully met the configured validation criteria.

  • Failed Objects – Objects that did not satisfy the configured validation criteria.

  • Execution Failed Objects – Objects for which the validation process could not be completed due to execution-related issues.

  • Undetermined Objects – Objects for which a definitive validation result could not be determined.

The dashboard includes:

Overall

The Overall doughnut chart provides a high-level Data Quality index across all Data Quality Rules and dimensions. It consolidates the latest execution results from all evaluated objects and presents an executive-level view of overall Data Quality performance.

This view enables users to:

  • Assess overall Data Quality health across the organization.

  • Monitor the percentage of objects that passed validation.

  • Identify the proportion of failed, execution failed, and undetermined objects.

  • Track Data Quality trends and operational performance from a centralized view.

Dimension-Level Statistics

In addition to the Overall view, the dashboard displays execution statistics for individual Data Quality Dimensions, such as:

  • Accuracy

  • Uniqueness

  • Completeness

  • Validity

Each dimension-level doughnut chart displays the latest execution results for objects associated with that specific Data Quality Dimension.

Interactive Analysis

The doughnut charts support interactive filtering.

Users can select any status segment within the Overall or Dimension doughnut charts to filter the detailed results displayed in the grid below.

For example:

  • Selecting the Passed Objects segment displays only objects that passed validation.

  • Selecting the Failed Objects segment displays only objects that failed validation.

  • Selecting the Execution Failed Objects segment displays only objects with execution failures.

  • Selecting the Undetermined Objects segment displays only objects with undetermined results.

The detailed grid automatically refreshes to display the corresponding objects and execution results, enabling users to investigate Data Quality issues and validation outcomes more efficiently.

Detailed Results Grid

The Detailed Results Grid displays object-level execution results based on the selected status or dimension in the dashboard. It provides information about the data object, associated rule, execution details, and validation results.

Field
Description

Connector

Displays the connector associated with the data object being evaluated.

Schema

Displays the schema containing the evaluated object.

Object

Displays the name of the table, file, or other data object evaluated by the Data Quality Rule.

Attribute

Displays the specific column or attribute evaluated during rule execution.

Rule Name

Displays the name of the Data Quality Rule used for validation.

Purpose

Displays the business objective or validation purpose defined for the rule.

Function

Displays the Data Quality Function used for validation.

Dimension

Displays the Data Quality Dimension associated with the rule, such as Accuracy, Completeness, Uniqueness, or Validity.

Rule Execution ID

Displays the unique identifier assigned to the rule execution. Selecting the value opens detailed execution information for the rule run.

Object Execution ID

Displays the unique identifier assigned to the execution result of the individual object.

Passed Row Count

Displays the number of rows that successfully satisfied the configured validation criteria.

Passed Percentage

Displays the percentage of rows that passed validation.

Failed Row Count

Displays the number of rows that did not satisfy the configured validation criteria.

Failed Percentage

Displays the percentage of rows that failed validation.

The results displayed in the grid are based on the most recent Data Quality Rule execution and are automatically filtered according to the selected dimension or status segment in the dashboard. This allows users to quickly investigate passed, failed, execution failed, and undetermined validation outcomes.

Execute the Advanced Job for the Dashboard

To generate or refresh dashboard statistics:

  1. Navigate to Administration > Advanced Jobs.

  2. In the Name column, search for

    1. Build DashboardStats

    2. Enable system dashboards

  3. Select the Advanced Job.

  4. Click Run Advanced Job to trigger the job.

  5. Monitor the Job Home Page for the execution status.

  6. Once the job executes successfully, the Dashboard will be generated and displayed under the Dashboards module.

This process updates the dashboard with the latest Data Quality Rule execution statistics and ensures that the Overall and Dimension-level metrics reflect current Data Quality performance.

Purpose

  • Display the total count of attributes associated with each dimension.

  • Categorize attributes based on data quality status into:

    • Passed

    • Failed

    • Execution Failed

    • Undetermined

    • Total

  • Retrieve the most recent execution ID for each object and rule.

  • Ensure that only the latest validation result is used.

Key Performance Indicators (KPI)

KPI Metric
Description

Successful Object Validations (Passed)

Counts the number of objects (columns) that successfully met data quality standards.

Failed Object Validations

Represents the number of objects that did not pass data quality checks.

Total Object Validations

Measures the total number of objects assessed for data quality.

Execution Failures

Tracks validation failures caused by execution errors.

Undetermined Objects

Identifies objects with inconclusive validation results.

Last updated

Was this helpful?