Measure

Reliable data serves as the bedrock for sound business decisions, and PDQ provides data quality solutions designed to optimize crucial DQ dimensions such as accuracy, completeness, consistency, timeliness, validity, and uniqueness.

PDQ empowers users to recognize, comprehend, and rectify data imperfections, fostering improved decision-making and governance. PDQ provides the user with out-of-the-box capabilities to measure data quality across data assets in the organization by applying data quality rules.

Out of the box Measures

PDQ houses over 150+ Out-of-box measures across health, frequency, distribution, and statistical categories with dimensions based on the criticality of data to improve accuracy toward business outcomes.

x

x

1. Navigate to Settings > Quality.

x

x

1. Enable/disable a measure for any given asset at a platform level, before configuring an asset.

x

Custom Measures

While the platform includes more than 150 measures, it is not confined to this predefined set. Users have the flexibility to personalize their measures by employing either straightforward conditional arguments or a query mechanism.

Custom measures can be created at an asset or attribute level depending on requirement.

x

1. Open the asset > Go to properties > Click on the + icon at the top right corner of the measures table.

Conditional

Users can establish rules grounded in predefined conditional values, and PDQ additionally offer the capability to incorporate multiple conditional rules and rule groups within a single measure.

x

x

x

x

Query

PDQ enables users to employ native database queries for creating measures.

For instance, users can utilize queries like "Select * from Person.data where ID < 100" or employ joins to filter the data. The valid toggle buttons can be utilized to set the polarity of the results.

x

x

x

First Tab

Second Tab

x

x

x