Profiling customer data

Incorporating appropriate data quality tools in your business processes is vital at the beginning of any project and through the project plan in order to see what type of data quality you have and decide how and what data to resolve.

Suppose, for example, that you want to start a campaign for your sales and marketing groups, or you need to contact customers for billing and payment and your main source to contact appropriate people is email and postal addresses. Having consistent and correct address data is vital in such campaign to be able to reach all people.

This section provides an example of profiling US customer email and postal addresses.

It shows how to identify anomalies in address columns, how to use some Talend Jobs to recuperate duplicate and non-match addresses and finally how to generate periodic evolution reports to keep monitoring data evolution and share such statistics with business users.