With an international database spanning North America, Europe, Asia and the South Pacific, SPIE needed to be able to search their database through multiple fields.
Complete D365 Data Management Solution
DQ for Dynamics™ works inside Dynamics 365 to improve data quality and provide you with data that is fit for business use.
Using DQ for Dynamics™, SPIE was able to search using fuzzy logic, as well as cleanse their database of duplicate and invalid records.
SPIE, the international society for optics and photonics, was founded in 1955 to advance light-based technologies. As a not-for-profit-society, we organize and sponsor approximately 25 major technical forums, exhibitions and education programs in North America, Europe, Asia, and the South Pacific. Through our SPIE Digital Library, we also publish the world’s largest collection of optics and photonics applied research, with more than 500,000 papers from SPIE journals, conference proceedings, presentations, and eBooks.
Our challenge was not having a solution that enabled us to search using fuzzy logic. Our native tool searched only by last name, first name and email. With DQ for Dynamics™, we can now pull and examine additional data, such as affiliation and address information.
We found DQ Global to be the best cost-saving solution compared to its competitors. With each session created, we can now assign duplicate records to specific staff on our services team for investigation and merging.
We apply DQ for Dynamics™ for effective data cleansing of our database of over 1,200,000 contacts and 120,000 company records. We utilize this solution to aid in merging duplicate records using advanced fuzzy logic searching.
In the beginning, our search was for a deduplication solution that was easy to use and could effectively dedupe and merge records. After researching other solutions, DQ was the ultimate winner. Their solution is very easy to navigate once you learn your way around, and we love the merging tool. It does the work for you!
With DQ for Dynamics™ doing the searching for us, we are now able to identify and merge more duplicates than ever before.
The merge tool is easy to use, and we especially like the feature of having many editable fields during the process. We have also been able to improve on our decision-making process when identifying potential duplicates.
