Who Should Lead Your Data Quality Initiatives

By Elliot King Data and data quality issues touch virtually every part of an organization. Poor data hurts organizational efficiency. It can have a measurable impact on the bottom line. And it can diminish employee morale when employees cannot access the information they need to succeed at their tasks, and the data they do retrieve turns out to be wrong.…

Continue Reading

Business Rules for Standardization: Bringing it all Together

By David Loshin While we have been talking in the last few posts about checking whether a data value observes the standard (and is therefore a valid value), the real challenge in standardization is in determining (1) that a value does not meet the standard and then (2) taking the right actions to modify it so that it does meet…

Continue Reading

Context is Key to Measuring Data Quality

By Elliot King Beauty is in the eyes of the beholder, but that is not the case when it comes to data quality or, at least, it is not the whole story. Data quality can be measured along several different dimensions. But in the final analysis data quality depends on the context within which the data is used.  Perhaps the…

Continue Reading

Techniques for Address Standardization

By David Loshin In my recent set of posts, we looked at the value and importance of address standardization as an integral component of both transactional and analytical applications, especially when seeking levels of accuracy associated with the concept of location, which in some cases goes beyond the concept of "address." But knowing that with some degree of precision we…

Continue Reading

Are You A Dupe Detective?

By Joseph Vertido The process of finding approximate matching records in your data to get rid of duplicates is precisely that - fuzzy. It raises as many questions as answers. Am I using a good matching algorithm? Am I matching on the right fields? Is it a true match or a false one? The problem begins when inconsistent data enters…

Continue Reading

Review: Contact Verification Component

By Brian Erlich SQL Server Magazine Melissa Data provides mailing lists, mailing and data management software, and other products that can help companies improve the quality of their data. It now offers the Data Quality Components for SSIS, a suite of components that integrate into SQL Server Integration Services (SSIS). I recently had a chance to try the company's Contact…

Continue Reading

Build in Data Quality Right the First Time

Tackling complex data quality and data integration projects is now easier than ever - with Melissa Data's newly launched Professional Services. The program joins together your company's development and data management teams, with our own in-house data quality analysts. The goal: to help you accelerate adoption of our powerful data quality solutions, and realize immediate ROI. For more information, click…

Continue Reading

A Comparison of Microsoft Data Quality Services (Denali) vs. Melissa Data’s Data Quality Components for SSIS

By Ira Whiteside Recently Microsoft released a new Beta Release of SQL Server codenamed "Denali," which included the Data Quality Services (DQS) feature. Here at Melissa Data, we are partners with Microsoft and also participate in the Azure Data Services Market for DQS providing Address Correction references. Over the next several weeks, we intend to explore the new data quality…

Continue Reading

Measuring Yourself

By Elliot King Sometimes you just know you're doing things badly. You send out a direct mail piece and you get all sorts of bounce backs. And sometimes you know you're doing something well. The next direct mail piece gets a really high rate of return. But an ad hoc, event-by-event assessment of performance generally is not good enough. Organizations…

Continue Reading