KQIs (Key Quality Indicators) To Measure Data Quality

At the recent MIT Information Quality Industry Symposium, the hot topic was measuring the impact of data quality programs. In a bad economy, it makes perfect sense. If your company is cutting programs, you need to justify your data quality initiatives, or they too will be cut. My favorite presentation on the topic was from Delphine Clement, whose topic was the, “Cost of Non Quality Data.” I thought that was an interesting way to look at it, and she presented a very mature view of Data Management. Delphine credited sessions from previous MIT Information Quality Symposiums with some of the underlying theory. I’m sure there are others to credit as well, and if you know the history please comment.

Delphine reports on the Key Quality Indicators (KQIs) that matter the most to her business partners. She has taught the business community that KQIs are needed to build confidence in the KPIs. I like that the KQI approach mirrors the KPIs (in naming and level of importance), and that they are presented as a complementary report. Think of this as the metadata for the KPIs. That’s the way I rationalized it.

KQIs would make sense to any Data Quality lead, but it might not to a VP of Marketing or VP of Sales. It’s not their job to care how we do ours. So how do you bridge the gap with the executive KPI users? You must understand their needs, and show them that the KQIs are driving the data quality projects in your organization. They will only care if the KQIs help to resolve their issues. Also, KQIs may be used to show them progress in your data quality programs. When you complete a project and are able to turn a yellow (cautionary) indicator to green (good), they will understand how the project affected their work.

Delphine’s approach begins by asking business leads and other data users a simple question, “How should we measure data quality.” She gathers feedback via surveys from her business customers and measures progress through response trending over time. Sounds like internal Marketing, right? Delphine also presented a methodology for measuring direct vs. indirect cost savings from Data Quality initiatives. She has clearly spent a lot of time working on this approach and is doing a great job. I really enjoyed this presentation.

She also recommended involving the end users early on to define:

• What are the Key Quality Indicators (KQIs) that are important to the business?
• Should the KQIs be global or local?
• What is the cost of poor quality data?
• Are the KQI’s different by country?

I love these questions. Simple, direct, and open. Rather than telling our peers how we should be measured, ask them and include them in the KQI process.

MIT Information Quality Industry Symposium Day 1

I’m just settling in for Day 2 of the MIT IQIS 2009 and thought I’d throw out some thoughts for a couple of future posts I’m drafting. Here are the quick recaps from yesterday. 

Danette McGilvray - Ten Steps to Data and Trusted Information

A great primer on how to manage any Data  Quality project. Her 10 steps made a lot of sense. Not all of the methodology would be used for any given project, but still it worked for me. I also won her book, “Executing Data Quality Projects” in the drawing at the end of the class.

Bill Inmon - DW2.0 and Unstructured Data

After 10+ years in Data Warehousing I finally got to see Bill Inmon speak. Bill is the rockstar of the DW world. He’s regarded as the Father of Data Warehousing and treated as royalty at a conference like this. His new stuff was all about contextual ETL. Sounded interesting, but I believe there are others working on the same thing.

Keynote: Ronald Bechtold - Transforming the Army with High

Ronald is the Chief Data Officer at the Army. Cool title. Not what you’re picturing. He is a passionate CIO type who has a huge challenge. Definitely some words of wisdom in there. “Focus on solving problems,” rather than tools, technology or data. Good stuff!

Joe Bugajski - MDM Improves Information Quality to Deliver Value

Joe had some great examples where Data Quality actually led to increased revenue. Imagine that! Value from Data work. I think that’s what we’re all striving for. Joe is a big personality who speaks well, so this one was entertaining.

Mark Goloboy (that’s right, me) - CRM Data Quality for Sales and Marketing

After a bit of nerves, I found my groove and thought the presentation went really well. Some good questions about where my company started with Data Governance - it’s a very new ffocus or us. I also got to push back on some industry experts when asked why we weren’t focusing on MDM to start. Plus, Bill Inmon attended.

Martin Boyd - Product Data Quality Product from Silver Creek

More contextual analysis. Seemed to be done in a very smart way. The software was functional at big clients, and they had figured out how to solve some complex issues around improving poor product data. If they had the same thing for Customers, it would be a more interesting product. More development or a merger are needed here.