Thursday, January 15, 2009

Full-Spectrum Data Quality Management...What Is It?

Most people agree that data quality is not just an IT issue, but one belonging to the enterprise. That implies that data quality issues and participation in resolving them crosses organizational silos. That certainly sounds like it could be full-spectrum data quality, but is it?

Data quality management left solely to IT often results in approaches that start from the database layer and work their way out into the business. Organizations where IT is not tightly integrated with other parts of the business tend to stop once the application layer is reached, assuming that problems rooted in people and process are management issues for the business to tackle.

Data profiling by IT is an exercise of evaluating data values in databases relative to pre-determined quality thresholds, which may not focus attention on the data that matters most to the organization. Data quality improvement approaches often include automation (e.g., batch data cleansing, “scripts” that change values across the database, etc.). Error prevention strategies often involve edits and other controls in front-end systems and data validation routines that run in the background.

Contrast that with data quality management being sponsored by a non-IT part of the business. Data quality approaches in this scenario often start from the customer perspective (internal or external) and work inward. These approaches tend to yield data quality issues that customers see, but also tend to only go inward as far as the application layer.

Data profiling by the business is more like a data quality audit in terms of errors exposed to customers—errors in data which are often most important to the organization. Data quality improvement approaches in this scenario include many of the non-IT variables: training, job aids, process reengineering, workflow/procedure adjustments, etc. At times, controls in applications are also considered in improvement strategies, but the business solutions to these issues often rely on changes in culture and the fabric of the organization.

It seems that a full-spectrum approach to data quality improvement is one that focuses on prevention and is bi-directional—that is, it comes at data issues both from the customers’ perspective and from the database layer. These vectors intersect in the front-end systems making the connection between people, process, and technology more solid.

The first step in implementing a full-spectrum data quality improvement approach is to utilize cross-functional teams for root-cause analysis, design of prevention strategies, and their ultimate implementation. Since quality can be influenced by changes to people, process and technology, these teams must include a full-spectrum of individuals (including IT).
Organizations that only make IT responsible for data quality management run the risk of not improving data that is most important to the organization and only going so far as technology systems for improvement. Organizations that only manage data quality outside of IT run the risk of too much reliance on people and processes while not leveraging the heavy-lifting value IT brings to the table. It makes much more sense to continuously improve data from a technology perspective while also improving it from a business perspective…a full-spectrum approach to data quality improvement.

1 comment:

Anonymous said...

I think this is one of the best posts I've read so far this year Eric.

I often find that organisations either swing too far one way or the other and it's this mid-ground that really drives the most benefits.

A key element of DQ (IMO) is really about quality controlling the data/business rules that need to be enforced to ensure efficient, profitable and competitive business.

Profiling tools can help you discover, assess and prevent these rules degrading but they will only ever be able to find a small portion of the overall set of rules an organisation requires.

They do however automate a lot of the process so for this reason are invaluable for finding quick wins and "low-hanging fruit" to pick.

The only way, I believe, to discover and manage the extended set of rules that really impact the business is to get the business involved, backed with IT support as necessary.

Really refreshing post Eric, will definitely add this to the January blog round up, keep them coming!