By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Data Cleansing vs Data Maintenance: Which One Is Most Important?
Share
Notification Show More
Latest News
big data mac performance
Data-Driven Tips to Optimize the Speed of Macs
News
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
Artificial Intelligence
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Uncategorized > Data Cleansing vs Data Maintenance: Which One Is Most Important?
Uncategorized

Data Cleansing vs Data Maintenance: Which One Is Most Important?

martindoyle
Last updated: 2015/09/01 at 5:08 AM
martindoyle
5 Min Read
SHARE

Data Cleansing vs Data Maintenance: Which One Is Most Important?

Data cleansing v maintenanceThere are always two aspects to data quality improvement. Data cleansing is the one-off process of tackling the errors within the database, ensuring retrospective anomalies are automatically located and removed.

Contents
Data Cleansing vs Data Maintenance: Which One Is Most Important?Data Cleansing vs Data Maintenance: Which One Is Most Important?An Apple A Day…Facing Facts   Don’t Depend on Dentures

Data Cleansing vs Data Maintenance: Which One Is Most Important?

Data cleansing v maintenanceThere are always two aspects to data quality improvement. Data cleansing is the one-off process of tackling the errors within the database, ensuring retrospective anomalies are automatically located and removed. Another term, data maintenance, describes ongoing correction and verification – the process of continual improvement and regular checks.

Often, businesses ask us: which process is the most important? In the long term, which one should we focus on? Unfortunately there is no simple answer, but there is an easy way to understand the differences between them.

An Apple A Day…

When we think about data, we can compare it to caring for our health. In particular, data maintenance is a lot like brushing your teeth. We brush our teeth at least twice a day to stop decay from taking hold. If we didn’t, the sugar that we consume would gnaw away at the enamel and cause rot to set in.

More Read

big data improves

3 Ways Big Data Improves Leadership Within Companies

IT Is Not Analytics. Here’s Why.
Romney Invokes Analytics in Rebuke of Trump
WEF Davos 2016: Top 100 CEO bloggers
In Memoriam: Robin Fray Carey

The longer we leave it between brushings, the more vulnerable our teeth become. Similarly, our database must be continually cared for and maintained.

Why?

Data in a database rots and decays in exactly the same way as teeth do. Frequent data maintenance is required to keep the data in good health, ensuring that the rot cannot progress to a catastrophic stage. That’s one good argument for data maintenance, and it proves why it is an unavoidable task that all businesses must commit to.

But what about cleansing data?

Facing Facts

Simply brushing your teeth helps to stop them from crumbling and decaying, but we also need to organise frequent visits to the dentist. At these essential appointments, our teeth are thoroughly checked and professionally cleaned, and any tooth damage repaired before it escalates. Brushing the teeth does not mean these visits can be skipped.

We might not find the dentist’s chair pleasant, and there are certainly more enjoyable things to spend time and money on. But these regular appointments are essential if we want our teeth to last.

In the same way, data needs to be checked and validated by an expert. In our example, we do this by using data quality software. This is your database’s ‘dentist’s appointment’ – the chance to catch and fix errors that have built up over time. Using sophisticated matching techniques, automated processes can pick out likely duplicates, and find data that doesn’t play by the rules.

ActivityTypical Cleansing
Prevention10%
Detection30%
Repair60%

cleansing

 

 

 

 

 

 

 

ActivityIdeal Maintenance
Prevention45%
Detection30%
Repair25%

Maintenance

 

 

 

 

 

 

 

 

 

 

 

Don’t Depend on Dentures

If you don’t look after your teeth, you’ll end up with nothing – at best, you might get a set of false ones for your old age. If you don’t care for data, all the effort and money that was invested in collecting it will turn out to be wasted. And it will be impossible to build meaningful reports based on the scraps of accurate data that you have left. The only way to continue will be to start from scratch, buying a new set of data from someone else.

Aside from that, a successful business with no reliable data is facing a perilous future. Deprived of its most important asset – the information it needs for sensible decisions – it must navigate without knowing who its customers are.

There is no short cut to good data quality, and no way that cleansing or maintenance can be skipped.

martindoyle September 1, 2015
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

big data mac performance
Data-Driven Tips to Optimize the Speed of Macs
News
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
Artificial Intelligence
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

big data improves
Big DataJobsKnowledge ManagementUncategorized

3 Ways Big Data Improves Leadership Within Companies

6 Min Read
Image
Uncategorized

IT Is Not Analytics. Here’s Why.

7 Min Read

Romney Invokes Analytics in Rebuke of Trump

4 Min Read

WEF Davos 2016: Top 100 CEO bloggers

14 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?