|
|
|
Our Products
|
|
DataMotion is the most powerful data quality tool in the Brazilian market that can be used in online environments, in batch or even on the Web as a validation tool for registration data.
|
|
Scenario
|
Companies usually have multiple data storage formats and locations. In order to support decision making, enhance systems performance, or even update existing systems, data must frequently be copied, moved, replicated or even undergo transformations from one location to another. The Data Quality & ETL (Extraction, Transformation and Loading) concept aims exactly at offering a solution for this demand.
DataMotion is a technology of specific components for data quality, ETL, data transformation, recoding and string handling. Given its architecture and access methods, DataMotion may be used in various scenarios requiring data cleansing, correction, transformation, recoding and conversion.
|
|
|
Data Quality
|
Geographic/Telephone Number Data
Address treatment - validation and standardization of locations, neighborhoods, city, state, and zip code; separation and standardization of location components - type of location, location, number and complement.
Telephone number treatment - validation and update of area codes and phone prefixes.
Names
Gender attribution and person type identification (company or person); identification of curse words (typos in names); separation of compound names, first name, middle name, last name.
Documents
Control digit validation and field formatting for CNPJ, CPF and State Registration (IE).
E-mail Address
Verification and consistency of e-mail address field and ping to verify domain existence.
Generic Fields
Standardization and formatting of generic fields such as Position, Product Table, Relation, Marital Status, etc; integration with regular expressions; word accentuation.
MatchCode
Avoids duplicate records through phonetic identification of duplicate contents. Ideal for the creation and management of unique registrations by applying several levels of parameters and business rules.
|
|
|
ALC - Layout and Content Analyzer
|
According to DMReview estimates, 20 to 50% of companies in the world have quality problems in their data. Through evaluation and monitoring it is possible not only to prevent current problems from continuing, but also to avoid future problems.
All data content and structure analysis phases are defined by the Data Profiling processes. Through DataMotion's ALC, several powerful functionalities for registration content diagnostic and analysis will be available to the user.
DataMotion ALC has the following built-in functionalities:
- Analysis of practically any file type;
- Support for files of virtually any size;
- Field layout mapping;
- Database structural analysis;
- Analysis of missing data;
- Content tabulation and field completion patterns;
- Identification of possible registration anomalies;
- Management reports in Excel spreadsheets;
- Etc.
Go to contact us and schedule a no-commitment demonstration of our products.
|
|
|
| Applications |
Application Examples and typical uses:
- Consolidation of several databases with different data structures
- Legacy data processing and conversion
- Integration of files from different sources into a single repository
- Process automation and sequencing
- Key tool in a CRM and Marketing project arsenal
- Data preparation for Business Intelligence and Data Mining projects
- Data preparation for Data Mart and Data Warehouse projects
- Administration support and Market Research and Survey support
- etc.
|
|