Enquire Now
Donaldson DQ Global Case Study

Business Needs

“One of our key initiatives was to consolidate our various CRM systems and processes into Microsoft Dynamics 365.  The project vision was to maximise customer insights to make faster decisions and lead with a 360-degree view of our customers and markets.”

DQ Global Solution

DQ for Dynamics

DQ for Dynamics works inside Dynamics 365 to improve data quality and provide you with data that is fit for business use.

Business Benefits

The DQ for Dynamics tool has enabled Donaldson to merge over 50,000 records and continues to deduplicate 500 records each week.


Company Background

Founded in 1915, Donaldson (NYSE: DCI) is a global leader in technology-led filtration products and solutions, serving a broad range of industries and advanced markets.  Diverse, skilled employees at more than 140 locations on six continents partner with customers – from small business owners to R&D organisations and the world’s largest OEM brands.  Donaldson solves complex filtration challenges through three primary segments: Mobile Solutions, Industrial Solutions and Life Sciences.

The Data Quality Challenge

“Over our 108 years, Donaldson has grown organically and through acquisitions, which has fuelled an explosion of data creation and consumption. For most of this history, data has been created to support individual business objectives using unique definitions, and was not commonly shared across locations, business units, or functions.  As products and customers progress through their lifecycle, data is created and changed in various systems to ensure that our business processes are executed as designed.  Variation in these business processes and systems has led to data inconsistencies.  As a result, the business cannot easily find, share, trace, understand, or roll-up product and customer data across the organisation.

Prior to this project, very few data quality controls were in place.  As a result, there was limited effort to cleanse and de-duplicate customer data.”

Data Quality Solution

DQ for Dynamics was implemented with our CRM Dynamics 365 solution.  We implemented fuzzy searching logic to identify duplicate records.  We also partnered with our data stewards to define rules to:

  • Identify the master (golden) records
  • Auto-populate the master records with data field values from duplicate records
  • Merge to a master record and inactivate the duplicate records

It took us 6-8 months to install DQ for Dynamics and configure it to meet our needs. “

"At Donaldson, we understand the importance of data quality, however, we have not invested in the people, processes, and technology to deliver high-quality data that the business demands. Our Data Management and Sales teams appreciated DQ Global’s ability to explain what good data quality looks like and their patience to guide us through the questions and decisions needed to implement maintainable and scalable processes."

The Results

“In the first 9 months, the DQ for Dynamics tool has enabled us to merge over 50,000 records and continues to deduplicate 500 records each week. This would not have been feasible without the automation this tool provides.  These processes are moving us towards a 360-degree view of our customers.  This results in better identification of leads, improved opportunity pipeline visibility, and ultimately a better customer experience through informed salespeople and leadership.”

If you’re concerned about the quality of your Customer Data, book a DQ Discovery Call with us today