Data Quality Tips from Our Experts

By Admound Chou Assistant Data Quality Manager   The date most mailers (and those in the industry) perhaps feared - Jan. 4, 2010 - has finally come. Starting Jan. 4, 2010, a First-Class™ or Standard MailĀ® mailing must pass a USPSĀ®-mandated Move Update compliance measure - or face a 7-cent per piece penalty. Penalties will be assessed on mailings that…

Continue Reading

Wayward Seasonal Catalog Waste Ends With Web-based Apps

By Donna HoganSpecial Correspondent for TechNews Arizona     'Tis the season to pack mailboxes with hefty holiday gift catalogs from Williams-Sonoma, See's Candies, Sears, et al, touting great deals on everything from peppermint bark to perfume to pots and pans.   But how many of the glossy paper-based pitches for toys or fishing gear or lingerie are addressed to…

Continue Reading

Case Study: Northern Ontario School of Medicine (NOSM)

In this case study, the Northern Ontario School of Medicine (NOSM) was able to cleanse and incorporate their data from about 30 distinct source systems, by integrating Melissa Data's Total Data Quality Integration Toolkit (TDQ-IT). TDQ-IT works within the SSIS data flow to deliver a wide range of data integration, transformation, and cleansing functionality including: profiling, parsing, cleansing, matching, and…

Continue Reading

Case Study: University of Iowa, College of Dentistry

In this case study, The University of Iowa's College of Dentistry successfully cleaned their database of bad addresses and cut back on returned mail with Melissa Data's Data Quality Suite. Most of the clinic's database errors were caused by patients intentionally providing fictional billing information; the administration having difficulty reading the patients' forms; or even simple clerical mistakes. Therefore, it…

Continue Reading

How to Enrich Your Data by Extending the Power of SSIS

Bad data is a challenge for all organizations. Without data that is reliable, accurate and updated, organizations can't deliver trusted customer, product and other vital data throughout the enterprise - resulting in waste and operational inefficiencies, less effective sales and marketing, poor customer service and potentially bad business decisions.   That's why many companies choose to incorporate data quality directly…

Continue Reading

Melissa Data Announces New IP Address Locator Tool

The new IP Locator Object allows users to identify where Internet visitors are coming from to help increase click-through and sales. Available as either an API or a Web service, it helps companies enhance geotargeting initiatives and identify Internet user's geographic location; including country, region, city, lat/long, ZIP Code™, ISP and domain name, all without invading, or being perceived as invading, the…

Continue Reading

SSIS Toolkit Debuts at PASS Summit

Hello All! We introduced our new SSIS Toolkit of data quality transforms at the PASS Summit in Seattle this week to positive response. Total Data Quality Integration Toolkit (TDQ-IT) is the most affordable, full featured enterprise data integration platform to help IT professionals integrate increasingly complex enterprise data - in all its different formats, structures, and sources, and deliver a…

Continue Reading

Inaugural blog entry from Melissa Data’s Data Quality Evangelist Ira Whiteside

For my inaugural blog I would like to direct you to Jim Harris Obsessive-Compulsive Data Quality post on Data Profiling. He makes several important points regarding the techniques and methodologies in Data Profiling, and since I am not vendor neutral I would point out we provide all the capabilities Jim describes and more for SSIS.  Also I recently posted an article on…

Continue Reading