7 Data Quality Best Practices

Published: 6 February 2017

After realising the cost of ‘Dirty Data’ to your business and recognising the benefits of achieving data quality nirvana, you will likely be interested in finding out how to get there. Here we share our Top 7 Data Quality Best Practices, to help you on your way.

Top 7 Data Quality Best Practices

Acknowledge the problem

Like with any problem, the first step to addressing it is acknowledging it exists. Getting others to acknowledge the problem is also useful, as it helps get everyone on board with the project.

Identify the scale of the problem

Once you recognise the problem it is import to establish the extent of the issue and where possible the root causes – this will help you to put preventative measures in place once the initial clean-up has taken place.

Appoint an owner

Although everyone in your business will have a responsibility to maintain accurate records, by appointing an owner (and perhaps some ambassadors) you will ensure data quality is given the focus it deserves.


Telling your people to keep accurate records is not enough. You need to ensure they understand the benefit to them in their role and the broader business benefits for them to change their behaviour.

Set goals

Setting goals and deadlines will help keep everyone on task. This will also act as a measure of achievement which you can share, acknowledging progress and providing positive reinforcement.

Introduce policies and processes

Once the data clean-up has taken place you will then need to introduce data policies and procedures to ensure dirty data is never a problem for you again. Consider using mandatory fields and picklists in your database to reduce human error.

Set up controls

Once the cleanup is complete and new processes are in place that is not the end, in fact it’s probably the beginning. From here you need to put in place measures and controls for regular review to ensure everyone adheres to the new ways of working.

For more tips about managing your data, visit our blog. Share your thoughts by tweeting us @Xperiencegroup

Read More

The road to Project Success – this is how you prevent ...

22 September 2021

Many organisations still consider budget overruns in both time and money as major threats for the success of their business software projects or digital...

Faster, Cheaper, Better – The devil's triangle of...

4 June 2021

Across the globe, clients that require a successful digital transformation project have one thing in common. They want their favourite solutions to be...

Successful project management – How to lay the foundat...

4 June 2021

In today’s markets, there are not many organisations who can allow their next Digital Transformation initiative to fail whether that is cloud, ERP, CRM or...

Webinar Poll Results: for 79% of leaders pandemic impacted t...

11 May 2021

Xperience are currently running a new webinar series on ‘How to master digital transformation to accelerate your business.’ The webinars feature Guus...

Why successful digital transformation calls for more than ju...

25 March 2021