Data profiling and DQ Analysis

Find the patterns, missing values, character sets and other characteristics of your data values. The heart of DataCleaner is a strong data profiling engine for discovering and analyzing the quality of your data.

Profiling is an essential activity of any Data Quality, Master Data Management or Data Governance programme. If you don't know what you're up against, you have poor chances of fixing it.

Data Monitoring

To manage your data's quality, you need to monitor it. Monitoring is a central aspect with DataCleaner - to establish the starting point and goals, and to ensure a process of following up on data quality issues.

The monitoring server of DataCleaner enables you to not just make point-in-time profiles of your data, but to schedule periodic data quality checks and receive notifications if quality KPIs get out of control.

Cleansing and enrichment

Use reference data, external and internal, in order to verify that the data values you have correspond to the real world. DataCleaner allows you to build your own cleansing rules and compose them into several use scenarios or target databases. Whether it is simple search/replace rules, regular expressions, pattern matching or completely custom transformations, we support it.

You can also leverage EasyDQ.com, an on-demand DQ services platform to easily check if addresses exist, if phone numbers are filled correctly for international use, if persons or organizations are noted on EU or OFAC sanction lists and more.

Customer information quality

A poor level of information on your customers is damaging for your business. Customers will easily loose confidence in your treatment of their data, and your internal operations might suffer as well.

Lightweight ETL & data migration

DataCleaner's processing engine was built for highly interactive, performing and flexible tasks. Apply it for analytical purposes or for adhoc Extract-Transform-Load (ETL) activities with a lightweight workflow.

DataCleaner is built to handle data both big and small. Give everything from CSV files, Excel spreadsheets to Relational Databases (RDBMs) and NoSQL databases a spin!

Duplicate detection

Duplicates is a very common driver for data quality efforts. Avoid operational issues and bad customer experiences by identifying if you have the same persons, companies and products registered multiple times.

Commercial editions of DataCleaner include the latest generation duplicate detection feature, building on Machine Learning principles for improved inferential matching.

What people say about us

Datalytics is a leading business consulting firm in the South American region. We're specialized in Data Integration, Data Cleansing, Business Intelligence and Data Mining solutions. We've been following your products for some time now, since my belief is that it's an excellent software and the perfect match for our offering.

- Andrés Eyherabide, Professional Services Manager, Datalytics.

With a tool like DataCleaner you avoid a lot of the common mistakes in doing Data Integration and ETL. You also sometimes able unlock new business value or cost savings because you’re able to identify strange behaviour in your database and improve or utilize this in upstream processes.

- Emilio Arias, Stratebi Business Solutions.

At Platon we use DataCleaner in our Information Management projects as a handy and powerful "swiss army knife" for activities related to Data Quality Analysis, Data Profiling and exploring customer data in general. We have found that the tool provides us with a lot of important analysis features in this process.

- Asbjørn Leeth, Senior Consultant, Platon.

Using DataCleaner and its Duplicate Detection function we identified around 10% redundant contact entries. Furthermore addresses were validated and standardized, so the data quality was lifted making it possible for BestBrains to improve our communication and relations with our large network.

- Jesper Thaning, Partner, BestBrains.

Watch online videos

Our documentation contains videos - a great way to get into how DataCleaner works. Head over to the videos and documentation section to learn more.