The Return On Investment (ROI) of Automated Data Testing

Making a business case for QuerySurge is easy with an ROI of 1,287% over 3 years!

QuerySurge Return On Investment (ROI) Calculation

Value-add

  • Increased data testing coverage from < 10% to upwards of 100%
  • Decreased testing time by as much as 1,000 x over manual tests
  • Provides data quality at speed

Return on Investment (ROI)

  • Time savings over manual testing (minus queries, sampling, other methods)
  • Redeployment of testing head count by upwards of 75%
  • Increase in better data due to shorter/more thorough testing cycle

Case Study: Fortune 50 Firm

With the assistance of our client, we were able to gather metrics to show the ROI of QuerySurge vs. testing without an automated data testing solution. The client previously used minus queries as the preferred test strategy.

This Case Study only takes into account ROI from a time/cost perspective of the same resources and not vs. head count redeployment or the impact of Bad Data.

QuerySurge vs. Manual Testing (minus queries, or sampling)

Data Snapshot

  • 522 Query Pairs (tests). It takes the same effort to create query pairs for Minus Queries as for QuerySurge, so this cost is a wash.
  • 1,100,000 average rows

Manual Test Execution cost

  • Average cost for consulting services: $75/hour or $600 per day

Manual Testing execution time and cost

  • Total time: 174 hours = 21.75 days

    (20 minutes per query pair * 522 query pairs = 10,440 minutes)
  • Average cost consulting services: $600 per day
  • Cost per release: $600 per day * 21.75 days = $13,050 per release
  • Cost per year: $13,050 * 12 major releases per year = $156,600 per year
  • Manual time to create reports: 3 days per release
    3 days * $600 per day = $1,800 per release
  • $1,800 * 12 = $21,600 per year
  • Total Cost = 156,600 + 21,600 = $178,200

Return On Investment (ROI)

  • Cost for QuerySurge for 1 user: $5,460 (subscription price/year)
  • Cost to run, monitor and report on QuerySurge tests: 8 hours per run = $600 per day = $7,200 per year
  • Total cost of QuerySurge testing = $5,640 + $7,200 = $12,840
  • Year 1 savings: $178,200 - 12,840 = $165,360 per year
  • Year 2 savings: = $330,720
  • 3-year savings: = $496,080 
  • 3-year ROI = $534,600 (manual testing) / $38,520 (QuerySurge)
    = 1,287% ROI

This ROI calculation only calculates labor savings.

Additional Issues

  • Minus Queries are processed on either the source or the target data store, which can draw significantly on your database resources (CPU, memory, and hard drive read/write)
  • Minus Queries only return failed data sets, thus there is no historical review, analysis, or audit trail of data from past testing

QuerySurge will help you:

But don’t believe us (or our clients). Try it for yourself.
Check out our free trials and great tutorial

Poor-quality data is costing companies, on average, $14.2 million annually

- Gartner, Inc.

46% of companies cite Data Quality as a barrier for adopting Business Intelligence products.

- InformationWeek

Data quality problems cost U.S. businesses more than $600 billion a year.

- The Data Warehousing Institute

Data Quality best practices boost revenue by 66%.

- SiriusDecisions, Inc.

Nearly 1/3 of analysts spend more than 40% of their time vetting and validating their analytics data before it can be used for strategic decision-making

- Forrester Research

Important Links