Every data cleaning situation is unique
A quick post today.
One often overlooked fact is that every data cleansing situation is very unique.
Take a simple customer deduplication (removal of duplicates) exercise. At first glance it is a very simple problem. Identify the duplicates, and remove them. However once you get into the details you realize there are several items worth considering.
1. How do you identify a duplicate? Is it the company name? Contact name? Address? Maybe you deal with 2 completely different offices that are the same customer (IBM in Australia and in the UK for instance)
2. Do you want to remove all information about a duplicate contact? There may be important contact information or customer notes associated with the record.
3. Have all affected stakeholders in your organization been made aware that the cleanup was occurring? There may be individuals and departments inside your own organization who should be notified to insure no unintended consequences occur.
4. Are there any new standards you’d like to apply? Capitalizing street suffixes, separating full name fields to a First and Last name field, etc.
Note that Data Ladder is here to walk you through these issues which is why we give free personalized WebEx demonstrations addressing your specific data cleansing activity.
Any other big questions that I missed? Feel free to comment below. We welcome and thank you for taking part in the conversation.
Why Email Cleaning is Crucial to Effective Correspondence
Email has grown from a mere messaging medium to something indispensable in the corporate arena. Especially, official communication in the corporate sector happens through an organization’s mailing system. Though everything, from important decision-making to strategy-planning, happen in a matter of clicking send/receive/forward from your desktop, maintaining an effective email system is not as easy as it sounds. Read more
Getting a Real Return from your Data Quality / Data Cleansing Initiative
Getting a Real Return from your Data Quality / Data Cleansing Initiative
Some important basic areas that we will cover:
ROI: Return on Investment is a simple measurement of the success of a project. You need to know two pieces
Investment: How much the project will cost and how to get the best deal
Return: How much the project will return and how to maximize return Read more
Why Data Quality and Data Cleansing Projects Fail
Data Quality and Cleansing initiatives are essential to improving overall operational and IT effectiveness. However many efforts do not get off the ground and get stalled before they really start. Read more