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.

And there are many references to operations or transformations performed on addresses, mostly with the intent of improving the quality of the address.… 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.

There are many facets to review. I would like to start by drawing from several articles from experienced practitioners, either from academia or the commercial market.Read More