Enter the Contact Zone: Where Data Integration and Data Quality Are Simplified

Blog Administrator | Data Enhancement, Data Enrichment, Data Integration, Data Management, Data Profiling, Data Quality | , , , , , , , , ,

By Joseph Vertido

For many, the concepts of data integration and data quality are separate and have no commonality. But in reality, when you combine them – they create a partnership that excels. Where data quality leaves off, data integration begins, and vice versa.
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

Cleansing Your Data Using SQL Server 2012 Data Quality Services (DQS) and Melissa Data

Blog Administrator | Data Integration, Data Management, Data Quality, Data Quality Components for SSIS | , , , , ,

Check out this video featuring a step-by-step/start-to-finish approach to cleanse and enrich address data using the new SQL Server 2012 Data Quality Services (DQS), and Melissa Data’s Datamarket Address Check service. From the video, you will learn how to create a comprehensive Data Quality project that leverages Melissa Data’s deep experience in address verification to cleanse, verify and standardize postal address information in SQL tables and Excel spreadsheets.… Read More

Data Quality Incident Management

Blog Administrator | Address Standardization, Data Integration, Data Management, Data Quality | , , , , ,

By David Loshin

The previous step in our transition from uncontrolled reactivity to being proactively engaged in managing data quality involved defining processes for identifying and evaluating data errors using standardized methods. Providing well-defined processes to data stewards and data quality analysts helps reduce any confusion around the appropriate steps to take when those commonly-occurring data failures are discovered in process.
Read More