Home > Ask the Data management / BI Experts > Data governance and quality Questions & Answers > Should we buy data quality management tools or focus on policies?
Ask The Data Management Expert: Questions & Answers
EMAIL THIS

Should we buy data quality management tools or focus on policies?

David Loshin EXPERT RESPONSE FROM: David Loshin

Pose a Question
Other Data Management Categories
Meet all Data Management Experts
Become an Expert for this site


Tips, expert advice and sample chapters
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 17 August 2009
We use SAP as our ERP system. Our data quality efforts focus on master data and we do this by manually running query extract of the data, inspecting it and then making the corrections (passive data quality). Our data capture and load programs have good data validation logic/routines but they aren't perfect, hence the need to manage the back-end data.

The company is not convinced that an investment in costly data quality tools is necessary, but the overhead to manually administer data quality is huge and is producing sub-optimal results.

I have thought about trying to put a justification proposal together, but the buzz is that "it won't fly so don't waste your time." What steps would you recommend to help me improve our data quality, given the stated limitations?



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Data governance and quality
Are there data governance plans, templates or standard procedures?
Resolving data ownership issues with external funders, organizations
Where to find new academic resources on data quality best practices
How to estimate customer data cleansing costs
Data quality management for data warehouses
What is high quality information?
Data quality management tools: Where to get unbiased information
Roles and salaries of data quality and governance analysts
The role of data governance in unstructured data
How to maintain data quality and provide high quality information management and analysis

Data quality management software
Gartner: Open source data quality software focuses on data profiling
Informatica hopes to bridge the business/IT divide with latest release
DataFlux demonstration of product data quality software
Poor data quality costing companies millions of dollars annually
How to improve data quality on a tight budget -- a guide
Data quality management tips and best practices
Peachtree Data uses SAP BOBJ Data Services to clean up mailing lists
SearchDataManagement.com product directory library
Data quality software, including dashboards for non-IT users, gaining traction
IBM acquires data discovery vendor Exeros

Data quality techniques and best practices
Understanding five major enterprise information management benefits
Gartner: Open source data quality software focuses on data profiling
Poor data quality costing companies millions of dollars annually
Are there data governance plans, templates or standard procedures?
Where to find new academic resources on data quality best practices
How to improve data quality on a tight budget -- a guide
Data quality management tips and best practices
Peachtree Data uses SAP BOBJ Data Services to clean up mailing lists
Data quality software, including dashboards for non-IT users, gaining traction
IBM acquires data discovery vendor Exeros

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
data governance  (SearchDataManagement.com)
data quality  (SearchDataManagement.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


Simple arithmetic (well, maybe not so simple): Data quality management software should be a reasonable alternative if the financial scope of the negative impacts of your current situation exceeds the cost of a better solution. In other words, if the costs of the time invested in manual extraction, inspection, cleansing/correction and reconciliation when the corrected SAP data is compared to the original captured data is greater than an automated alternative, then the alternative would be preferred. However, also recognize that there are startup costs as well as capital investment/licensing costs for tools, and even once you buy and install them, you need some expertise to make those tools do anything useful. In fact, from a cost perspective the tools approach may even be more expensive.

Here is a different suggestion: Instead of focusing on the tools approach, think about standardizing your data management and data quality policies and procedures, and review how your current processes could be streamlined, both in terms of maintaining the current manual methods and replacing them with new tools. This data governance assessment and standardization may provide a much greater lift in a shorter time frame in terms of data quality and data consistency improvement. Email me and let me know if that works, or if you have more questions.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts