Posted in

35 Metrics You Should Use to Monitor Data Governance

by Liz Henderson•

How do you know if your efforts are working or are you treading water and getting nowhere?

Data Governance (DG) is the most difficult area of the business to work in (in my view).  When all is working and no issues are causing problems, your efforts go unnoticed.  When issues arise and things go wrong Data Governance is the first area to blame processes dont work, you are not controlling this properly! Sound familiar?

To demonstrate to the business, that your efforts and the investment in DG is benefiting the business, in reducing costs and increasing revenue. You need to implement metrics.  This enables the business to understand and see the improvement you are making.  Where to start and what to measure????

Firstly understand what are your issues, goals and the impacts of resolving the issues.

For example:

Issue Regularity compliance, time consuming and inaccurate.

Goal Reduce compliance payment amounts and time to compile submission, by using accurate data and a defined approved process.

Impact Improved reporting accuracy. Reduced costs and time to comply. Improved reputation with auditors.

This helps define the metrics as you identify what your issues are and the impact. This draws out what needs to change / by improved. In the above example:

Metrics

  • Cost reduction
  • Effort required to comply
  • Time to submit
  • Accuracy of data
  • Number and frequency of audit visits

Suggestions for Metrics for you to use in your initiatives

People

  • Number of data owners identified vs number of domains*
  • DG / process adoption rate by business personnel via a survey*
  • Time in DG meetings reviewing and prioritising issues
  • Number of people trained in new system/process

Process

  • Number of data issues identified
  • Existence of and adherence to a business request escalation process to manage disputes regarding data issues
  • Number of issues escalated to DG Committee
  • Time from issue identification to resolution
  • Number of approved and implemented standards, policies, and processes*
  • Number of published data definitions*
  • Integration of processes into the project lifecycle process to ensure DG oversight of key initiatives*
  • Increased efficiency of projects and new project initiation set-up*
  • Time to market for new products
  • Time to be live on the system with all data completed and verified

Technology

  • Number of data sources consolidated*
  • Number of data targets using mastered data*
  • Number of local spreadsheets used*
  • Number of data fields traceable from source to use
  • Number of unique identifiers*
  • Number of duplicate products
  • Number of SKUs live
  • % of data validated at source
  • % of data validated at Central Distribution Centre
  • Number of variances between data validated at source and CDC
  • Number of business terms mapped to data models and objects*
  • % completion of attributes*
  • % completion of lineage*
  • % completion of glossary*
  • Improved reporting efficiency and accuracy*

Actual Value Identified*

  • Reduce call centre agent time searching for client information from 5 min to 2 min
    • Improved productivity could enable 1-2 people to be reassigned to other high value activities
    • Improved Customer Satisfaction with improved call handling time
  • Improved marketing effectiveness
    • Productivity improvement of 510% would enable marketing team to increase number of executed campaigns
  • Reduce sales rep commission reconciliation from 3 days/month to 3 hours/month

Customer Experience*

  • Direct Mail
    • Cost Savings = Cost per mail piece * Number of returned mail pieces
    • Cost Savings = Time to manually remediate mailing list * Cost for Employee
  • Email
    • Cost Savings = Cost per outbound email * Number of bounced emails
    • Cost Savings = Time to manually remediate mailing list * Cost for Employee

 Visualisation

Give consideration on how you will present your metrics.  They need to be clear and informative with minimal explanation. Use primary colours for best impact.  There are many posts and websites on Data Visualisation to research. With excel being such a powerful tool, this may be all you need to demonstrate your progress to your stakeholders.

What metrics have you used to measure your success and how successfully were they received?

* Metrics curtesy of John Ladley IMCue Solutions

 

Liz has over 15 years experience, creating a data-driven culture for organisations, to enable monetisation of their data. From developing the vision, designing the strategy, providing strategic leadership and, advising and executing a broad range of corporate compliance and digital data transformations.

With her passion for data governance she has solved problems which many organisations experience with duplicate, inconsistent and incomplete data, on multiple siloed platforms.

Prior to her current role she was a consultant delivering Europe-wide programmes for example; Reduced regulatory compliance costs by 40%, Accelerated the start-up of new capital projects enabling top quartile performance and while leading the European graduate induction programme delivered revenue of $2m by expediting the deployment of new consultants. She has spent a number of years in the branded office products industry where she led the business to revolutionise the standards and governance for global product data and was an active member of the industry federation influencing the direction of the industry for data.

When she is not governing data, she enjoys gardening and travelling, has a data blog lizhendersondata.wordpress.com, is a STEM ambassador and a non-executive director for the charity Focus who support the development of young people.

Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.