Data Profiling
DataCleaner
Measuring is knowing; but how do you measure the quality of
extensive amounts of data? The data profiling tool
DataCleaner enables your organization to
profile the data properties of different data sources quickly and
simply, ranging from flat files, to Excel spreadsheets, to
databases such as Oracle, SQL Server, and DB2. Data profiling with
DataCleaner combines ease of use with a
broad range of analysis functions. Building an analysis job that
consists of data profiling checks on hundreds of data entities
is extremely quick and the results are presented in a convenient
report. DataCleaner can even perform
transformations and filtering on the selected data in order to
partition, subset and combine parts of the data in the job. This
makes DataCleaner an all-in-one Data
Quality Analysis (DQA) tool.
Data Profiling features include:
- Pattern finder
- Value distribution
- String length, case and character
checks
- Value range and missing value
checks
- Dictionary and string pattern match
checks
- Synonym replacement checks