ENTERPRISE DATA MANAGEMENT: Data Cleansing and Standardization
Is your customer and vendor data in control? Is your data up-to-date, valid and consistent? Do you periodically monitor this critical data, getting rid of invalid data, fixing incorrect data and de-duplicating duplicates? If you answered no to any of these questions, GL Associates can help.
GL Associates has the tools and services for cleansing and standardizing customer and vendor data.
GL Associates has the tools and services for cleansing and standardizing customer and vendor data.
The first step in data management and data governance
Customer and Vendor data standardization is an important first step in any Master Data Management and Data Governance initiative because many different areas (Marketing, Customer Service, Sales, Credit, Accounts Receivable, Procurement, Accounts Payable, and Shipping) in the organization rely on the accuracy of this information in every business activity.
Customer and Vendor data standardization is an important first step in any Master Data Management and Data Governance initiative because many different areas (Marketing, Customer Service, Sales, Credit, Accounts Receivable, Procurement, Accounts Payable, and Shipping) in the organization rely on the accuracy of this information in every business activity.
Business risks result from bad customer/vendor data
Embarassing mistakes, higher costs and fraud are some of the risks that companies take on when customer and vendor data are not in control. Some of the common issues companies face are:
Customer and vendor data duplicated and not up to date
Customer and vendor names and addresses are often out of date and do
not meet USPS standards (for households and zip+4 compatibility), and they
are often duplicated because similar customer and vendor names and
addresses are spelled slightly different in the ERP database and in other
databases too.
not meet USPS standards (for households and zip+4 compatibility), and they
are often duplicated because similar customer and vendor names and
addresses are spelled slightly different in the ERP database and in other
databases too.
Invalid customer and vendor names and addresses
Can the staff be certain that the customer or vendor actually exist at all? Do
your procedures include validating name and address data to eliminate the
possibility of fraud?
Inability for stretched resources to monitor and correct bad data
As important as having correct customer and vendor information is, no one
has time to check the accuracy of the thousands of database records because
this requires a great deal of manual effort.
has time to check the accuracy of the thousands of database records because
this requires a great deal of manual effort.
GL Associates approach, tools and expertise ensure success
GL Associates is an expert in customer and vendor standardization. This service is a key differentiator between GL Associates and our competitors that are not familiar with this process and do not understand its importance.
Customer and vendor data cleansing performed quickly and efficiently
GL Associates helps companies to standardize and cleanse their customer
and vendor address information with up-to-date USPS standards, validate
household information, and to de-duplicate customers and vendors in a single
database, or across all databases in the entire organization. We do it quickly
and efficiently because we are noted experts in this area, and we have
standardized, cleansed and de-duplicated hundreds of millions of customer
and vendor addresses.
GL Associates offers a complete end-to-end services using a two-step
approach
Step 1: Address cleansing and standardization
In the first step of the GL Associates cleansing and standardization process,
all name and address data is standardized based on USPS rules. Street
names, street directionals and zip-codes are all corrected based on the latest
USPS data. This will give the system a set of addresses with all misspellings
and changed zip-codes or street names corrected.
all name and address data is standardized based on USPS rules. Street
names, street directionals and zip-codes are all corrected based on the latest
USPS data. This will give the system a set of addresses with all misspellings
and changed zip-codes or street names corrected.
Step 2: Customer/Vendor de-duplication
The next step of the process is a name and address match between the
cleansed records. This will identify the duplicates based on name and
address. The matching is based on industry-standard best-of-breed
matching that can account for nicknames, spelling errors, different titles and
even fraudulent addresses. Once the number of duplicates is ascertained,
GLA can propose a strategy to merge the address data and purge the
duplicates while moving all the history to the remaining record. The resulting
file contains one record for each unique name and address, and these
records will have the most up-to-date address information based on USPS
rules.
Enterprise Data Management:
Data Cleansing and Standardization
Master Data Conversion
ERP Instance Consolidation
Archon Data Management Software
EVENTS
PRESS RELEASE: 2010 Technology Best PracticesJul 15th 2010
Optimizing the Chart of Accounts for Robust Management Reporting in JD Edwards
Sep 14th 2010