Use Case: Create Entity Business Rule to Identify Data Anomaly - trillium_discovery - trillium_quality - 17.1

Scenario

A preliminary review of your entity Customer Master shows that it has data inconsistency. You want to identify the data attributes with the inconsistency and review the types of data inconsistency (for example if data is inaccurate or missing etc) and note down the rows with the incorrect data.

Solution

Create one or more entity business rules to check for inconsistency in all rows/records across all attributes in the entity.

Step 1: Create entity business ruleApplying Entity Business Rules

Example: Rule to identify empty attributes

The postcode attribute cannot be empty, however, you noticed that there are multiple instances where the information is missing. To identify exactly which postcode rows are empty, you create this rule:

Step 2: Run entity business rules analysisBusiness Rule Analysis

Example: Run analysis of Incorrect Postcode and Data Duplicates rules

Once you have created all necessary entity business rules, run business rules analysis.

Step 3: Analyze data inconsistencyBusiness Rule Results

Example: Analyze Empty Postcode rule

Analyze the passing rows to identify the number of empty postcode attribute.

1. Right -click Customer Master Entity > Business Rules > Drill down to Entity Business Rules. A list of the two business rules you created in Step 1 are listed. Notice, that 9.669% of all records have empty postcode attribute.

   

2. Select and right-click Empty Postcode, select Drill down to Passing Rows. A list of all records with empty postcode attribute is listed (76 of them).