Data Quality Scorecard

The classification of the different areas of impact of poor data quality resulted in four different impact areas. Within each impact area several different parameters of impact can then be determined to generate what is called a data quality scorecard which contains complex data metrics. These can then be analyzed using three different view points.

The sub-categories for each different category of data quality flaws are described below:

1)      Financial

  • Direct Operating Expenses – direct costs such a labor, raw material that can be used for fulfilling obligations related to contract
  • General overhead – rent, maintainance, asset purchase, utility, licensing, administrative staff and general procurement
  • Staff overhead – those required to run a business like clerical, sales, management, field supervision, bids and proposals, recruiting and training.
  • Fees and charges – bank fees, service charges, legal, accounting, penalties and fines, bad debt, merger and acquisition costs
  • Cost of goods sold – design, raw materials, production, cost of inventory, inventory planning, marketing, sales, customer management, advertising, lead generation, promotional events, samples, order replacement, order fulfillment and shipping
  • Revenue – customer acquisition, customer retention, churn, missed opportunities
  • Cashflow – delayed and missed customer invoicing, ignored overdue customer payments, quick supplier payments, increased interest rates, EBITDA
  • Depreciation – property market value, inventory markdown
  • Capitalization – value of equity
  • Leakage – collections, fraud, commissions, inter-organizational settlements

2)      Confidence and Satisfaction

  • Forecasting - staffing, financial, material requirements, spend vs budget
  • Reporting – timeliness, currency, availability, accuracy,  reconciliation needs
  • Decision making – time to decision, predictability
  • Customer satisfaction – cost of selling, retention, buys per customer, items per customer, sales cost, service cost, time to respond, referrals, new product suggestions
  • Supplier management – optimized purchasing, reduced pricing, making acquisitions simple
  • Employee Satisfaction – recruitment costs, hiring, retention, turnover, compensation

3)      Productivity

  • Workloads – reconciliation of reports
  • Throughput – Increased time for data gathering and preparation, reduced time for direct data analysis, delays in delivering information products, lengthened production and manufacturing cycles
  • Output quality – reports not trusted
  • Supply chain – not in stock, delays in delivery, missed deliveries, replicated costs

4)      Risk and Compliance

This content is for paid members only.

Join our membership for lifelong unlimited access to all our data science learning content and resources.