The latest news and views from Gibson Lamb

The place for updates on financially significant world events; our views on market developments; and news about our approach to doing business, including our focus on sustainability.

Our big data cleaning process and what you can learn from it


Date published

Gosh it’s November!

For those who don’t know, we are forty odd years old and over the years have helped thousands of individuals, some who remain active clients and some who do not. 

When Clive retired back in April, we used that as the catalyst to go through our database with a fine tooth comb to ensure all of the data is accurate and relevant.  Data cleaning is not a small task, I can assure you, as we had 7,832 clients ‘on the list’ back in April.

The process is slow because not only are we still running the business and looking after our clients, we’re adjusting to life after Clive and planning for the future.

Hey, we’ve even found time to take some holiday too.  Notwithstanding everything, we’ve now only got 7,518 left on the list, meaning we have reviewed over 300 files already.

For those old enough to remember Magnus Magnusson, we have started so we shall finish as the exercise will be over when the count gets to zero.

Why are we doing this?

  • It’s a long outstanding task and a little embarrassing that we haven’t done it before
  • We are working towards British Standard BS8577 and to achieve that goal, we need to have a handle on all our systems and process.
  • We are undertaking our first ever customer service survey with the aim of establishing what our clients like and don’t like about what we do.  We will then refine our service propositions and potentially role them out to those clients not yet enjoying a pro-active service with us.  Having accurate client data will enable us to roll the services out to clients.

We’re dead proud of what we have achieved so far and if you would like to know more, please don’t hesitate to ask

Here are three tips for your upcoming data cleaning efforts (because, admit it, you know you need to!)

  • Have a plan.   Don’t just plough into the exercise hoping it’ll turn out okay.  Establish out what you want at the end of the exercise and plan backwards to work out how to get it
  • We’re all in this together.  If the top dog gets stuck in, it will motivate the whole team
  • Enjoy reminiscing.  Stumble across that long forgotten about event from years gone by?  Share the anecdote and have a laugh about it