6 posts
Data Cleansing
How to use Data Cleansing to Maintain Customer Data
Customer data is often a brand’s most valuable resource. Frequently thought of as the “oil of the digital era”, clean, reliable customer data is the key to forming a relationship that extends beyond that of your competitors. It’s the lifeblood of a company, but cleaning dirty customer data and maintaining data hygiene can be a costly and complex…
Why Cleansing Ghost Patient Records is Vital to Healthcare
What are Ghost Patients records and why are they so important to cleanse from healthcare records?
Data Cleansing – Inside a Database or On a Desktop?
We’ve been gathering feedback from some of our service provider clients recently about the impact on them of change: there’s a lot of things that they mentioned to us: organisational change and new demands due to new customers come up as often as they always have done, but what about enforced change from outside the organisation?
When Direct Marketing Fails…
As a Direct Marketer in a tough economy, you are constantly being asked to do more with less. Generate more leads. Improve campaign results. Increase brand awareness. Streamline operational efficiency. Unfortunately, poor quality customer and prospect data can sabotage your direct marketing efforts and your reputation in the process. Want to get a handle on the ways that…
How to keep your SQL Server data clean – efficiently!
Working with very large datasets (for example when identifying duplicate records using matching software) frequently can throw up performance problems if you are running queries returning large volumes of data. However there are some tips and tricks that you can use to ensure your SQL code works as efficiently as possible. In this blog post, I’m going to…
Where Is Your Bad Data Coming From?
As Kimball documents in The Data Warehouse Lifecycle Toolkit (available in all good book stores), there are five concepts that together, can be considered to define data quality: