Category Archives for "Data Quality"

10 Reasons Why Data Quality and Data Governance Initiatives Fail

With her extensive experience in leading Data Quality and Governance initiatives in different domains, Purvi Ramchandani, Certified Information Management Professional Expert (CIMP-Ex), describes ten situations when Data Quality and Data Governance initiatives have a higher probability to fail:1. When the focus is on working in a reactive mode instead of a proactive modeAccording to a […]

Learn more...

How to Mature Data Quality and Data Governance by Stealth – Interview with James Phare of Data to Value

Data Governance by Stealth How do you create traction with data governance and data quality when your organisation is wary of these initiatives due to past historical projects that didn’t live up to expectations? In this interview with James Phare of UK data management consultants, Data to Value, we learn how James helped a past employer […]

Learn more...

4 Implementing an enterprise data quality initiative: Interview with Purvi Ramchandani

What is it like to lead a large data quality program in a large banking institution? In this interview I speak with Purvi Ramchandani, Data Quality Lead at Silicon Valley Bank to learn more about her experiences and progress in delivering an enterprise data quality initiative.Dylan: Can you briefly talk about Silicon Valley Bank and your […]

Learn more...

1 How to create a successful Data Quality Centre of Excellence: Laura Sebastian-Coleman

In this interview, highly experienced Data Quality author and practitioner, Laura Sebastian-Coleman, provides a detailed account of her experiences in launching and growing a Data Quality Centre of Excellence (CoE) in a large organisation. Laura has appeared before on Data Quality Pro and is the author of ‘Measuring Data Quality for Ongoing Improvement: A Data Quality […]

Learn more...

Creating a mature data quality strategy and culture: Interview with Eric Callmann of DigitalGlobe

​In this interview I speak with Eric Callmann, a highly experienced information quality and information management expert. Eric is currently leading the Quality program at DigitalGlobe, Inc and took time out to share some of the novel approaches to data quality that his company have adopted as well as tactics for data governance and maturing a […]

Learn more...

Tech Briefing: How to Apply Lean Data Quality Management principles for smarter delivery of risk and compliance reporting

The traditional approach to delivering reporting and insight requirements often relies on well defined project lifecycle methodologies such as waterfall. This involves sequential stages such as achieving sponsorship, capturing requirements, solution design and implementation.  Whilst a waterfall process works well for projects where the needs are clear it may mean a longer time to market […]

Learn more...

FREE Global Sourcebook for International Data Management: Featuring Graham Rhind

The Global Sourcebook (formerly The Global Source Book for Name and  Address Data Management) is an up to date resource containing an exhaustive library of  information relating to international data naming conventions all in one place. Maintained and published by Graham Rhind since 1994, it is now a free resource, supported by donations, sponsorship and advertising.

Learn more...

Daragh O Brien Interview : IGQIE 2014 and the latest EU Data Protection news

Daragh O Brien of Castlebridge Associates has been a regular contributor to Data Quality Pro expert articles over the years, specialising in Data Protection, Data Governance and Data Quality. This year marks the second anniversary of the Information Governance and Quality Ireland event that Daragh has been responsible for hosting. I recently caught up with […]

Learn more...

How to successfully deliver a corporate data quality program – Sherry Michaels interview

What does it take to deliver a large, complex data quality initiative in a heavily regulated industry? How do you get senior leaders bought-in and data stewards empowered?

These are just some of insights shared by Sherry Michaels, currently Data Quality Program Manager for The Hartford, and a data quality leader for over a decade.

Sherry has 3 decades of insurance experience and talks openly about the practical techniques she has adopted to help mature data quality, data governance and data stewardship across her past projects.

Learn more...

How to Improve Your Data Quality Assessment Process – featuring Laura Sebastian-Coleman

One of the outright experts on Data Quality Assessment is Laura Sebastian-Coleman, author of ‘Measuring Data Quality for Ongoing Improvement : A Data Quality Assessment Framework’.

In this interview she goes into a huge amount of depth on how to improvement measurement and assessment during data quality projects, hope you find it useful.

Learn more...

How to Design, Build and Execute a Data Governance Framework; interview with Guy Harvey

One of the most rewarding aspects of running Data Quality Pro is getting to meet practitioners who are maturing their organisational approach to data quality and data governance. 

It’s particularly rewarding when we meet practitioners who are achieving these objectives in the not-for-profit sector as in the case of our latest interview with Guy Harvey, a data governance practitioner who has been helping Sanctuary Housing roll out an entire data governance framework.

Learn more...

How to Create a Business Focused Data Quality Assessment

Showing the results of a data quality assessment can be a critical activity for engaging the business in positive action. However, your efforts can be thwarted if you adopt the wrong approach.

How can you create a data quality assessment that grabs the attention of the business and engages them into taking the right path forward?

Check out this webinar playback and find out.

Learn more...

How to Align Data Quality and Data Governance – The Mark Allen interview

As organisations mature they invariably wish to extend the reach of their data quality and data governance initiatives but how can they do this effectively? How can they ensure that there is no overlap and that everyone is focused on the same goal? 

In this interview with expert Mark Allen we explore how various business and IT alignment issues impact ability to successfully execute enterprise data governance and data quality programs. Mark also provides insights for how to address these alignment issues.

Learn more...

How to Create a Data Quality Firewall and Data Quality SLA

How do you prevent poor levels of supplier data quality impacting your organisation?

The answer is through the creation of a robust Data Quality Firewall and ongoing Data Quality SLA process. This post creates a blueprint for creating your own data quality firewall and ensuring your data quality SLA provides certified, high quality data throughout your organisation.

Learn more...

2 How to Use Data Migration as a Springboard for Ongoing Data Quality Management, with Bryn Davies

Bryn Davies of Infoblueprint, a South African consultancy ​specialising in Data Quality, Governance and Data Migration services, provides a range of tips for helping project teams to “bed down” data quality and governance capabilities that are sustained long after the migration is completed.

Learn more...

How to Improve Healthcare Data Quality Through Policy and Procedure Management

One of the single most common root-causes of poor information quality is outdated documentation and a lack of governance in the way policies and procedures are managed.

Nowhere is this more critical than in the healthcare sector.

In this interview I speak to Ellis Pratt, ranked the most influential blogger on technical communication in Europe and author/editor of ‘How to Write Instructions‘ and ‘Trends in Technical Communication‘.

Learn more...

Dilbert On Going The Extra Data Quality Mile

I love this recent strip from Dilbert because it sums up where so many companies are failing with their data quality right now. They’re creating good quality data, they have governance in place and stewards in abundance but where they’re not hitting the mark is at the point of information consumption.Going the extra data quality […]

Learn more...

IQCP Study Guide: Data Migration Resources To Download And Study

The IQCP Study Guide includes a requirement to study topics on Data Migration (see pg. 27) under the Information Management category so this post provides practical resources that should help with your IQCP preparation.

The resources listed in the study guide list a few examples but there are lots more available and some of the ones listed are a little out of date. I thought it would help to expand that section with some additional reading.

Learn more...

Data Quality Risk Management: Alex Borek shares practical techniques from TIRM

Poor data quality poses a major risk to every organisation but how do we measure those risks and take appropriate actions? In this interview we speak with Alexander Borek, Doctoral Researcher and Lead Developer of TIRM at the University of Cambridge. Alexander and his team have created a comprehensive approach that enables coordinated activities to direct and control an organization […]

Learn more...

How Create a Data Quality Strategy Without Cookie-Cutting

With so many books, articles and case studies available on the subject of data quality it is easy to to “cookie-cut” past strategies or frameworks and adopt them as your own. 

In this article, I want to explain why that is not necessarily the best approach and what you can do to create the perfect strategy for attaining data quality goals specific to your organisation.

Learn more...

How to Deliver Enterprise Data Quality Management: The Jay Zaidi Interview

What does it take to deliver an holistic enterprise data quality solution across one of the world’s largest and most data intensive organisations?

In this detailed interview, Jay Zaidi provides a huge amount of practical, actionable advice for anyone looking to take their data quality initiative to the wider organisation. 

Learn more...

Jill Dyché Interview: Data Governance and Data Quality Advice for Practitioners and Leaders

When should you enlist an executive sponsor for your Data Governance initiative? What are the 3 things you must focus on when launching your own personal Data Governance business? What’s the difference between a framework and a strategy?

Jill Dyché kindly took time out from her busy conference schedule to answer these and many other questions that are commonly asked by members. 

Learn more...

Framework for Corporate Data Quality Management Created by EFQM and University of St. Gallen

Data quality framework implementation is one of the very first tasks most organisations undertake when piecing together their data quality strategy. In decades past this could be a real challenge given the dearth of expert materials available. Step forward to today and we have the opposite problem, there is so much choice of available frameworks and […]

Learn more...

Featured Member: Mark van der Linden, Oil and Gas Data Quality Specialist, Alberta, Canada

​In this featured member interview we speak with Mark van der Linden, an oil and gas data quality specialist based in Calgary, Canada.

Mark has a wide experience of delivering data quality innovations and initiatives within the utilities industry having created products and delivered services. 

At present Mark is building a specialist data quality and MDM practice in Canada.

Learn more...

When Is It Impossible To Practice Root-Cause Data Quality Defect Prevention?

If you read the articles, webinars and interviews on Data Quality Pro regularly then you’ll know that root-cause prevention of data defects is by far the best outcome and something our expert contributors preach relentlessly. But what about those situations when this simply isn’t feasible? Data Quality Root-Cause Prevention – Prevented by Contracts This post […]

Learn more...

Creating a Data Quality Business: Moving from employee to entrepeneur, Wayne Wiggins interview – Data Quality Pro

Ever wanted to make the leap from working in a safe, stable salary position to the fear, risk and excitement of running your own data quality business?

In this session, long-time Data Quality Pro member, Wayne Wiggins, former head of Information Quality at Royal Bank of Scotland and former Director of Data Sourcing and Data Quality at Deutsche Bank talks about his switch from permanent employment to that of data quality business owner.

Learn more...

How To Make Data Quality Sound Interesting by Richard White

Do your workplace peers and seniors glaze over when you discuss the merits of your data quality skills? Do you secretly cringe at the thought of having to network for new data quality clients at trade events or online? 

Richard White, resident Data Quality Pro business coach and all-round business development guru provides some practical advice for anyone looking to sharpen those data quality introductions.

Learn more...

Know Your Data! Data Modelling tips from William Sharp

In this guest post William Sharp of The Data Quality Chronicle provides some practical advice for leveraging data modelling at the outset of a data quality activity. In today’s world of increasing feature sets it is easy to become bedazzled by the latest instalment of new functionality. Data quality software is no different than other enterprise applications […]

Learn more...

Lean Techniques for Data Quality Management: Little’s Law

In this article we look at another Lean tool that works perfectly with data quality improvement initiatives: Little’s Law.

This simple tool enables us to calculate the lead time for a business service. This in turn allows us to quickly identify areas where effective data quality management will help us deliver faster services, reduce costs and most importantly – delight customers.

Learn more...

Lean techniques for Data Quality Improvement: Time Value Traps

Many of you will no doubt be aware that organisations that adopt Lean initiatives can witness a dramatic effect on the reduction of waste in their business but Lean can also provide a major advantage to your data quality initiatives too.

In this article, the first in an ongoing series, we provide details of a Lean technique that can help you rapidly identify areas ripe for improvement.

Learn more...

10 (Uncomfortable) Questions for your Data Quality Technology Vendor

Considering a new purchase of data quality technology but don’t know what you should you really be asking of your data quality technology provider?

The following list provides a range of questions that go beyond the typical requests you would have around product features, they may help you dig deeper and gather insight around important areas such as customer loyalty, long-term strategy, competitive positioning and quality of service.

Learn more...

How to deliver £600,000,000 of Data Quality Benefits: Interview with Nigel Turner

Nigel is a renowned UK based data quality expert and leader. Whilst working for BT, he led a data quality team that delivered over half a billion pounds of data quality benefits.

This is the first in a series of interviews we will be covering with Nigel, discovering what it takes to lead and deliver data quality initiatives at the very highest level.

Learn more...

The Data Zoo by Julian Schwarzenbach

​The Data Zooby Julian SchwarzenbachHow do personality and behaviour impact the success of your data quality project? In this feature, expert panelist and active community member Julian Schwarzenbach of Data and Process Advantage publishes an excellent white paper covering his popular series on different data behaviours and how they can impact data quality – the data […]

Learn more...

How to Cost-Effectively Satisfy UK FSA Requirements for Single Customer View

How to Cost-Effectively Satisfy UK FSA Requirements for Single Customer View by Ken O’Connor The UK Financial Services Authority have recently implemented a new policy that affects many UK financial institutions. The policy relates to the implementation of a “Single Customer View” (SCV) requirement for certain organisations that fall within their guidelines. In this post […]

Learn more...

Expert Interview With Phil Simon, Author of Why New Systems Fail and The Next Wave of Technologies

In this article I interview Phil Simon, a popular author, blogger and consultant who writes regularly on the subject of emerging technologies, data quality, data migration and a range of associated topics.

Phil blogs at where you can read extracts from The Next Wave of TechnologiesWhy New Systems Fail and The Age of the Platform.

Learn more...

Getting Buy-in For Data Quality With Guest Expert Ed Wrazen

One of the most common questions we hear in the data quality profession revolves around convincing sponsors and leaders to act on data quality – but how do we actually achieve this?

In this 60 minute interview and presentation, Data Quality Pro expert panelist Ed Wrazen (of Trillium Software) provides a range of tactics to help you create a business case and justification for data quality investment.

Learn more...

Data Quality Rules Tutorial 1 of 4: Attribute Domain Constraints by Arkady Maydanchik

Arkady Maydanchik provides practical tips for managing domain data quality rules for attributesData Quality Rules Tutorial 1 of 4: Attribute Domain Constraints Data Quality Assessment by Arkady Maydanchik by Arkady MaydanchikIn this tutorial, Arkady Maydanchik provides an overview of the 5 categories of data quality rules as covered in his Data Quality Assessment book. He […]

Learn more...

IQM-CMM: Information Quality Management Capability Maturity Model with Saša Baškarada

IQM-CMM: Information Quality Management Capability Maturity Model” by Saša Baškarada has been published by the German Association for Information and Data Quality.

Dr.Baškarada has an extensive background in the field of information and data quality so I recently caught up with him to find out more about his goals for the book and how he feels it will benefit organisations on their information quality journey.

Learn more...

Identifying Duplicate Customer Records: An MDM Case Study With Dalton Cervo of Sun Microsystems

In any MDM initiative duplicate records will present a major challenge but when an organisation attempts to consolidate 800+ systems into a single customer hub the challenge is made all the greater.

We recently caught up with Dalton Cervo, Customer Data Quality Lead at Sun, to learn how his organisation is tackling an MDM initiative of this scale.

Learn more...

Data Quality Best-Practice for Data Migration, Featuring John Morris

Data migration projects have an extremely high failure rate and one of the principal causes is a lack of effective data quality management across all aspects of the project.

To help members reverse the trend of project failure we have enlisted the support of John Morris, author of Practical Data Migration and creator of the PDMv2 Data Migration Methodology, the only industry standard methodology for data migration currently available. John also provides great advice via his BCS Blog.

Learn more...

DEBATE: Is Data Cleansing a Reality for the Data-Driven Business?

For every practitioner who has witnessed the benefits of data defect reduction via cleansing technology there are those who view cleansing to be firmly outside the scope of best-practice data quality management.

In this debate, we provide the case for and against data cleansing and encourage readers to share their experiences and views on this thorny topic.

Learn more...

7 Simple, Low Cost Ways to Improve Data Quality in Data Entry

One of the single biggest causes of data defects in any organisation is poor quality information entered at the start of the information chain via data entry interfaces.

This article provides some simple, practical and cheap techniques to dramatically improve the data quality of human entered information.

Thanks to Henrik Sørensen for contributing to this feature.

Learn more...

2 How to Create a Compelling Data Quality Business Case

In a past IAIDQ/UALR salary survey one of the biggest issues cited was the ability to demonstrate the value of data quality. This typically involves a business case that attempts to convince sponsors that the benefits of your data quality efforts will outweigh the costs incurred.

This is a big area and one article isn’t going to come close to tackling this subject but in the spirit of continuous improvement I wanted to share some techniques that may just help tip that next business case in your favour.

Learn more...

New Zealand Ministry of Justice Data Quality Framework

Mandy Mackay provides the New Zealand Ministry of Justice Data Quality Framework and a detailed account of how they developed it.New Zealand Ministry of Justice Data Quality Framework+ interview with Mandy MackayCreating a data quality framework is an admirable achievement for any organisation and witnessing its implementation with immediate benefits gained is a major milestone […]

Learn more...

Interview with Danette McGilvray, Author of Executing Data Quality Projects

Executing Data Quality Projects: Ten Steps to Quality Data and Trusted Information (TM) By Danette McGilvray In this article I talk with Danette McGilvray of Granite Falls and author of Executing Data Quality Projects. Danette is a highly experienced practitioner, trainer and author of data and information quality. Danette provides a range of insights including […]

Learn more...

Necessity of Conceptual Data Modeling for Information Quality by Pete Stiglich

The ability to correctly identify the business entities and the way we want to model those relationships is pivotal to good information quality. Most organisations opt for physical modeling and create application specific schemas that often lack the high-level vision for how the business really needs to utilise its data.

In this post, senior consultant at EWSolutions, Pete Stiglich, presents an excellent account of the importance of Conceptual Data Modeling on ensuring information quality.

Learn more...

Integrated Modelling Method: An Introduction with John Owens


In this post we speak to John Owens, the creator of the Integrated Modelling Method (IMM), a framework that combines all the modelling techniques that are so often lacking in organisations that are looking to improve data quality.

We recently caught up with John to find out more about his distinctive approach to modelling and how it can provide benefits to our goals of high quality information.

Learn more...

2 Data Profiling for Beginners with Talend Open Profiler: Data Quality Tutorial

​In this feature we show you how to create a data profiling process by creating a tutorial that combines:

  • Free database, free data profiling tool and free pattern analysis tools from Talend, Oracle and Data Quality Pro
  • A sample data set in various formats from a real life property database
  • A full 21 page tutorial with step-by-step instructions and worked examples that are suitable for all abilities
Learn more...

Misconceptions of Data Quality on Data Migration Projects, Featuring John Morris

Data migration projects have an extremely high failure rate and one of the principal causes is a lack of effective data quality management across all aspects of the project.

To help members reverse the trend of project failure we have enlisted the support of John Morris, author of Practical Data Migration, creator of the PDMv2 Data Migration Methodology, the only industry standard methodology for data migration currently available.

Learn more...