Talend Open Profiler
Data profiling is the process of examining the data available in existing data sources (e.g. databases, applications, files...) and collecting statistics and information about this data. Data profiling enables the assessment of the quality level of the data contained in the information system, according to a defined set of metrics and goals.
Talend Open Profiler is a sophisticated yet simple-to-use data profiler. It allows business users or data management staff to define a set of indicators for each data element that needs to be analyzed or monitored. These indicators can range from simple or advanced statistics to text strings analysis, including summary data and statistical distributions of records.
Talend Open Profiler produces sophisticated reports and graphs that let users gauge at a glance the level of quality of the data, and the status of the indicators that were defined.
Download Talend Open Profiler now!
Metadata discovery
|
Talend Open Profiler connects to databases and files to introspect their structures and stores the description of their metadata in its Metadata Repository. The metadata is then used by data analysts to set up metrics and indicators.
|
Indicators
|
The indicators that can be set with Talend Open Profiler include:
- Simple statistics: provides statistics on the number of records falling in certain categories, including the number of rows, the number of null values, the number distinct and unique values, the number of duplicates, or the number of blank fields.
- Text statistics: analyzes the characteristics of text fields, including minimum, maximum and average length.
- Summary statistics: performs statistical analysis on numeric data, including the computation of the mean, the average, the inner quartile range, and the definition of ranges.
- Advanced statistics: determines the mode and builds frequency tables.
|
Rendering
|
Talend Open Profiler presents a series of tables and graphs that display the results of the profiling for each data element and each indicator selected.
|
