Data Cleansing and Simple Business Rules

Blog Administrator | Address Quality, Analyzing Data, Data Cleansing, Data Quality | , , ,

By David Loshin

Having worked as a data quality tool software developer, rules developer, and consultant, I am relatively familiar with some of the idiosyncrasies associated with building an effective business rules set for data standardization and particularly, data cleansing. At first blush, the process seems relatively straightforward: I have a data value in a character string that I believe to be incorrect and I want to use the automated transformative capability of a business rule to correct that incorrect string into a correct one.
Read More

In a Global Economy, a Global Solution is Vital

Melissa Team | Address Quality, Address Standardization, Address Validation, Data Integration, Data Management, Data Quality, International Address Verification | , , , , ,

By Patrick Bayne
Data Quality Tools Software Engineer

Heidelberglaan 8
3584 CS Utrecht

If you were given this address, how would you know it was valid? Is it formatted
correctly? How long will it take you to verify? For years businesses have
understood a need for address validating solutions, because clean, accurate data
is essential. Without accurate and consistent data, customers are lost due to
missed mailings, synchronization across servers is difficult, and reports become
inaccurate – all adding to costs and missed opportunities for your business.… Read More

Communication is a Key to Data Quality

Blog Administrator | Address Quality, Analyzing Data, Analyzing Data Quality, Data Governance, Data Management, Data Quality | , , , ,

By Elliot King

Too often, data quality is seen as a strictly technical issue. Data quality problems must be identified, assessed and then rectified, and that process is best managed by experts using the right tools.

But communication may be the most important element in a data quality program. A data quality program can only succeed if all the stakeholders understand the data quality program and play their role properly in executing it.

Read More

Address Quality – Take 2

Blog Administrator | Address Correction, Address Quality, Address Standardization, Analyzing Data, Data Cleansing, Data Management, Data Quality, Postal Address Standards, USPS | , , , , , , , , ,

By David Loshin

We have dealt with some of our core address quality concepts, but not this one:

The intended recipient must be associated with the deliverable address.

The problem here is no longer address quality but rather address
correctness
.

The address may be complete, all the elements may be valid, the
ZIP+4 is the right one, and all values conform to standardized abbreviations …
and still be incorrect if the recipient is not associated with the
address!… Read More

Postal Standards and Address Quality – Take 1

Blog Administrator | Address Correction, Address Quality, Address Standardization, Address Validation, Analyzing Data Quality, Data Quality, Postal Address Standards, USPS | , , , ,

By David Loshin

The USPS Postal Standard (Publication 28) provides at least some of the specifications we need for address quality. For example,

 “The Postal Service defines a complete address as one that has all the address elements necessary to allow an exact match with the current Postal Service ZIP+4 and City State files to obtain the finest level of ZIP+4 and delivery point codes for the delivery address.”

Read More