Proven ROI

Making a business case for QuerySurge is easy. QuerySurge returns 1,660% over 3 years!

QuerySurge ROI

Value-add

  • Increase in data testing coverage from < 10% to upwards of 100%
  • Decrease in testing time by as much as 1,000 x over manual tests
  • Combination of an increase in coverage while a decrease in time

Return on Investment (ROI)

  • Redeployment of testing head count by upwards of 75%
  • Time savings over manual testing (minus queries, manual compares, other)
  • 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 a data warehouse testing tool. 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

Data Snapshot

  • 522 QueryPairs
  • 60,000 average rows

QuerySurge execution time and cost

  • Total time: 2 hours and 46 minutes
  • Average for Consulting services: $1,200 per day

Manual Testing execution time and cost

  • Total time: 174 hours = 12.75 days
    (20 minutes per query pair * 522 query pairs = 10,440 minutes)
  • Average cost consulting services: $1,200 per day
  • Cost per release: $1,200 per day * 21.75 days = $26,100 per release
  • Cost per year: $26,100 * 12 major releases per year =
    $313,200 per year (This number does not include minor releases)

ROI

  • QuerySurge cost per user: $10,400 (for Perpetual users)
    Average QuerySurge installation: 4 users
    Average Cost for QuerySurge: $41,600
  • Manpower savings: $313,200 per year
  • Year 1 savings: $313,200 - $41,600 = $271,600
  • Year 2 savings: $313,200 - $7,500 = $305,700
    + $271,600 (year 1) = $577,300
  • 3-year savings: $577,300 + $305,700 = $883,000
  • 3-year ROI = $939,600 (savings) / $56,600 (cost) = 1,660%

The average organization loses $8.2 million annually through poor Data Quality."

...22% estimated their annual losses resulting from bad data at $20 million.

...4% put that figure as high as an astounding $100 million.

- 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.

Download this page as a PDF

Download/save this page as a PDF document to keep or share with colleagues.
Download this page in PDF format