Characterizing the Quality of Address Data

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

By David Loshin

My company is currently working on a couple of projects associated with address quality and location master data. We are reviewing a lot of the existing documentation that has been collected from a number of different operational systems, as well as reviewing the business processes to see where location data is either created, modified, or read.
Read More

Validation, Standardization, and Correction: Tool or Process?

Blog Administrator | Address Check, Address Correction, Address Standardization, Address Validation, Data Enrichment, Data Governance, Data Integration, Data Management, Data Profiling, Data Quality | , , , , ,

By David Loshin

There are all sorts of tools associated with
address standardization, cleansing, and validation. As an example, the USPS
has a certification program for software vendors, referred to as CASS
(Coding Accuracy Support System)™ certification. According to their
website,

CASS enables the Postal Service™ to evaluate the accuracy of address matching software programs in the following areas:

(1) five-digit coding
(2) ZIP + 4/ delivery point (DP) coding
(3) carrier route coding
(4) DPV®
(5) DSF2®
(6) LACSLink®
(7) eLOT®
(8) RDI™ products

CASS allows vendors/mailers the opportunity to test their address-matching software packages and, after achieving a certain percentage of compliance, to be certified by the Postal Service.

Read More

Record Linkage and Fuzzy Matching Part 1

Blog Administrator | Uncategorized | , , , , , , , , , , ,

 

This will be the first in a series of posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various tools and vendor’s products.Read More