Visitors Edition
Already a member? Sign In.

Need help? Our Trial Membership program will get you help on any IT project you're working on. You'll get access to our research, tools, advice and project help.

Membership Help?

Want to learn more about our membership options, pricing, or to get a product demo? Get in touch with one of our reps using an option below.

Tackle Data Quality Issues

Low-quality data saps time and money. Stop bad data in its tracks by developing a comprehensive strategy for cleaning your data – and keeping it clean.

More Details
  • Print
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn

Your Challenge

  • Poor data quality is a problem facing most organizations.
  • There are a variety of hard and soft costs associated with poor data, including increased direct marketing costs, lost revenue, inadequate financial reporting, unfulfilled orders and damaged customer relationships.
  • Despite the costs and headaches associated with having poor data, most organizations struggle to define and implement a strategy for effectively improving data quality.

Our Advice

Critical Insight
  • While the business must be accountable for data ownership, IT needs to be proactive in providing solutions for data quality problems.
  • There are five types of interrelated data quality issues: data duplication, stale data, incomplete data, invalid data, and data conflicts. Each problem requires a combination of corrective and preventative measures by the business and IT.
  • Some methods for solving data quality problems are more effective than others. Mass cleanups and strong data validation are more effective than user-training and vendor-supplied tools.
Impact and Result
  • Mass cleanups will solve most data hygiene problems (i.e. duplicate, incomplete and invalid data). Stale data can be fixed through external source integration.
  • Assigning data stewards will improve accountability for data accuracy.
  • Clean data means improved marketing campaigns, decision making and operations planning; both hard and soft costs are reduced dramatically when corrections are put in place.

Get to Action

  1. Understand how data quality problems arise and develop effective solutions for combating them.

    Get the maximum use out of clean data for operations, planning, and decision making.

  2. Identify the areas in the business that are suffering from data quality problems.

    Target remedies at the biggest data quality problems plaguing the organization.

  3. Establish and codify data management policies.

    Streamline data operations and clarify accountability for data.

  4. Create a Data Steward role for managing and improving data.

    Drive greater accountability for data integrity.

Related Content


Get the Complete Storyboard

See how all the steps you need to take come together, with tools and advice to help with each task on your list.

BONUS Get access to up to 5 additional free downloads

Download Now

Low-quality data saps time and money. Stop bad data in its tracks by developing a comprehensive strategy for cleaning your data – and keeping it clean.

Companies Who Helped

12 Contributors (due to the sensitive nature of the problems discussed, all contributors are anonymous).


Solution Road Map

Other Solution Sets in Data Integration & Data Management

  1. Move From Chaos to a Realistic Data Integration Strategy
    Find a balance between a hopelessly tangled web of integration structures and expensive, impractical utopia.
  2. Vendor Landscape Plus: Data Integration Tools
    Integration is the name of the game.
  3. Tackle Data Quality Issues
    Low-quality data saps time and money. Stop bad data in its tracks by developing a comprehensive strategy for cleaning your data – and keeping it clean.
  4. Implement a Master Data Management Strategy
    Manage the truth, the whole truth, and nothing but the truth with an MDM strategy.
  5. Effectively Manage Data Governance
    Convert the management of organizational data from a burden into a competitive advantage.
  6. Integrate a Data Audit into the Data Management Plan
    Data audits are not just about security: quality matters!
  7. Develop a Five Year Data Architecture Plan
    Secure your footings in data to lay a foundation that will withstand the winds and rain of today's IT disruptors.
View the full Solution Road Map