Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Enhance your customer data within a user-friendly environment by easily exporting it into Microsoft Excel and utilizing our plugin, which can be found in the Office Store for improved data quality. With our tool, you can transform data by abbreviating, elaborating, excluding, or normalizing it across five spoken languages and twelve distinct entity categories. You can assess the similarity between records through various comparison techniques, such as Levenshtein and Jaro-Winkler, and generate phonetic match keys for deduplication purposes, including DQ Fonetix™, Soundex, and Metaphone. Additionally, classify your data to determine what each piece represents—for instance, recognizing Brian or Sven as personal names, while identifying Road, Strasse, or Rue as elements of an address, and Ltd or LLC as legal suffixes for companies. You can also derive information such as gender from names and categorize contact information based on job titles and decision-making roles. DQ for Excel™ operates seamlessly within Microsoft Excel, making it both intuitive and straightforward to use, thus streamlining your data management processes effectively. Moreover, with its powerful features, you can ensure that your customer data remains accurate, relevant, and organized.
Description
DQV is the comprehensive data quality and testing platform developed by Kumaran Systems, catering to teams engaged in the movement, masking, or validation of substantial data volumes. This tool meticulously evaluates source and target datasets on a field-by-field basis, identifies discrepancies, and produces mismatch reports, eliminating the need for manual checks using spreadsheets.
The platform encompasses five key functionalities: it performs field-level comparisons while detecting drift, facilitates migration mapping between different schemas, offers deterministic PII masking, conducts record- and table-level validation with the ability for on-the-fly corrections, and generates synthetic data for teams lacking access to production data for testing.
DQV is compatible with a wide range of data sources, including SQL Server, Oracle, MySQL, PostgreSQL, AWS, Azure, GCP, flat files, JSON, XML, and REST APIs, and it seamlessly integrates with tools like Informatica, Databricks, and CI/CD pipelines, or can operate independently as a library or CLI tool.
In real-world applications, DQV has successfully validated an impressive 26.6 million bank records in less than 22 minutes, showcasing its efficiency and speed. Additionally, a free trial is offered, along with various licensing options, including individual, enterprise, and on-premises plans, ensuring flexibility for different organizational needs. This versatile solution not only enhances data integrity but also streamlines the testing process across multiple platforms.
API Access
Has API
No
API Access
Has API
No
Screenshots View All
No images available
Integrations
Microsoft Excel
No
Pricing Details
No price information available.
Free Trial
Yes
Free Version
No
Pricing Details
No price information available.
Free Trial
Yes
Free Version
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
No
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
Yes
In Person
Yes
Types of Training
Training Docs
No
Webinars
No
Live Training (Online)
No
In Person
No
Vendor Details
Company Name
DQ Global
Founded
1997
Country
United States
Website
www.dqglobal.com/products/dq-for-excel/
Vendor Details
Company Name
Kumaran Systems
Founded
1992
Country
United States
Website
kumaran.com/products/dqv/
Product Features
Data Quality
Address Validation
No
Data Deduplication
No
Data Discovery
No
Data Profililng
No
Master Data Management
No
Match & Merge
No
Metadata Management
No
Product Features
Data Quality
Address Validation
No
Data Deduplication
No
Data Discovery
No
Data Profililng
No
Master Data Management
No
Match & Merge
No
Metadata Management
No