Accellence’s Data Quality Solution provides the capability to transform raw data into consistent, accurate, and reliable information. This will provide better understanding of your business environment, allowing company to maximize profitability and reduce costly operational inefficiencies.

Customer Data Integration

A significant challenge in data quality is always in the area of customer data - names and addresses, due to both their key roles in business operations and their highly dynamic nature. Customer Data Integration solution improves the quality of your customer data by providing the capability to identify duplicate customer records. It also offers pre-built data cleansing rules and processes. The Match and Merge functionality allows you to search, match, and identify duplicate customer records based on key customer attributes.

Data Quality in Oracle Warehouse Builder

Warehouse Builder enables the following major data quality tasks:

• Data profiling - inspect data for anomalies, errors, accuracy, inconsistencies, redundancies and incomplete information
• Data rules derived from data profiling - correct, standardize, and verify data
• Data auditors based on data rules
• Name and address cleansing
• Matching and merging of data
• Data Monitoring - Check and control data integrity over time

Pre-Built Customer Data Cleansing Tools

Accellence’s Data Quality Solution provides pre-built and configurable Customer Data cleansing solution on Oracle Warehouse Builder. The solution incorporates pre-defined quality knowledge base which fully support Thai localization requirements such as:

• One Name Field that contains Title, First name, and Last name
• One Address Field that contains all attributes i.e. Number, Street, District, Amphor, and Province.
• Incorrect Title and/ or sequence
• Incorrect Amphor, Province, Postcode information and relationship
• Incorrect telephone format
• One customer contains many addresses
• One address belongs to many customers

Key Features

• Profiling and auditing quality of source data
• Pre-built data exploration and data quality monitoring reports
• Pre-built cleansing rules and knowledge base
• Match and Merge - identifies duplicate or similar records based on key attributes and conditions
• Customizable extract, transform, and loading (ETL) capability to consolidate data from disparate data sources and perform cleansing process
• Pre-defined data model to support Business Intelligence capability
• Design and manage corporate metadata

Please call us to help you make better business decisions from your data.