Clich├ęs Won’t Suffice

By Elliot King A silver bullet... A quick fix...For most problems, we all want them, but in most cases they don't exist. In IT generally, many times people hope to find some technology that could serve as a quick fix or a silver bullet. Generating too much data? Buy additional storage. Problem solved. To fix data quality problems, however, great…

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

The Complexity of Linking Addresses (and Locations) to Geocodes

By David Loshin There is a difference between an address, which refers to a delivery location, and a geocode, which can specify practically any location, and clearly, addressable locations make up a subset of geocoded locations. And if you are at a specific location, and you happen to be holding a GPS (global positioning satellite) device, you can derive the…

Continue Reading