NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Data quality

What is data quality and why it is important.

it is a measure of how well business data practices satisfy standards. Good and reliable data can be used to increase efficiency, support decision making, and sky rocket profitability.

Poor data quality leads to wasting time, working with conflicting information resulting in bad decisions and massive decrease in efficiency.

Many organizations implement strict data controls at the point of entry. However quite often it is not enough. For example, when data is loaded into the data-warehouse or moved from one application to another additional validation and transformation rules must be applied.

Data Quality Strategy.

The primary objective of any data integration solution is to assemble data from one or more data sources validate and transform it into standard format.

There are three major steps in implementing data quality strategy:

  • Profiling - helps you to check if a source data file or table extract meets the format such as file encoding fields format and order
  • Cleansing - Once data successfully satisfies profiling standards, it still necessary to cleanse the data for example remove empty values or irrelevant information
  • Auditing - one ot the most important parts of data integration. It gives IT departments the history of data transformation, profiling and cleansing which can be used in importer failure investigations.

Advanced ETL Processor Data validator

Advanced ETL Processor is able to check any data including date formats, post codes, phone numbers, validating against list of values etc. It has more than 190 data validation functions, plus it can be extended by using regular expressions. It is an enterprise data integration solution that lets you quickly validate and process large volumes of data while preserving and enhancing data quality.

Validation Editor

Validation Editor

Simple data cleasing rule

Simple Data validation rule

More about data validator...

"This [Visual Importer ETL] is such a great help. As expected, it has paid for itself within one week!"

Phill Stive,
Oracle DBA, OU,
Newcaste

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with