Standardization of customer data using Talend Data Quality components

 

Subscription onlyThis content is available for Talend Academy subscription users only. Open use case - EN

 

Prerequisites

Talend Data Integration Basics, Talend Data Quality Essentials, Talend Cloud Data Stewardship

Third-party software

MySQL

Description

 

 

This use case introduces you to customer data cleansing and standardization.

Customer data can stem from various sources. Contact information like postal addresses, emails, and phone numbers are key attributes for secure communication between companies and customers. Data quality and standardization of these attributes are crucial.

 

Talend Studio provides components to validate the customer’s contact attributes accuracy by profiling data using regular expression patterns and by integrating addresses standardization services like Experian QAS, Loqate, MellissaData, and Google.

 

When automatic corrections are not possible, data stewards can manually revise the incorrect data.