When preparing to test a data migration we wanted to know how many records needed to be inspected. I googled for a calculator and this site came up.
Let me give a hypothetical scenario to illustrate how it can work for you.
I have a 1000 accounts of VIPs being migrated from a legacy system to a new online travel management tool.
We want to migrate their current details including name, company, address, contact details etc. We are also interested in migrating past travel details, but this will be deferred to a later release.
The VIPs are important customers to us and we have no tolerance for mistakes. By no tolerance I mean that if a handful of them has a problem, I can handle it, but not more because, as I said, they are all VIPs. So no tolerance means 1% room for error.
The developer work has been unit tested and peer reviewed and it looks like the data is in pretty good shape in the legacy system, so I only need a 90% confidence level on the test.
(This stands in contrast to our 85% unit test coverage, 0% automated UI tests, and 75% coverage of cases in UAT.)
We also do a pre-test check in the developer environment and inspect 20 records and find that there are three mistakes, so we add in a response bias of 15% (which is 3/20.)
The calculator tells me that out of 1000 cases I need to test 122 records. With an error tolerance of 5%, a confidence level of 90% and a bias of 15%.
That scenario includes the potential for up to 50 VIPs to encounter a problem sometime, based on the data we migrate. Maybe that’s one a week in the year, or maybe, because they are VIPs and travel a hell of a lot, it’s 50 in the first month. And we know that each problem costs us $300. The potential for errors at this threshold is $15,000, which is about equivalent to 3 weeks of testing time.
So we know that the potential cost here outweighs the cost of some additional tests. If we target an error tolerance of 1% we need to run 776 tests. Each test takes 10 minutes, so that’s about four weeks worth of testing/inspecting effort. That’s a bit too expensive, so we start exploring the numbers in between until we find the right balance between risk and cost.
Okay, I am no stats expert and would love some commentary on this scenario.
9 October 2009
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Due to popular demand I have aggregated some information on User Stories and created a simple template. If you feel this would be useful to...
-
I have been having a bit of a discussion over at the IIBA blog with Kevin (VP BOK) and Julian (Chief architect.) It’s migrated over to ...
-
Better Projects Templates I am uploading a couple of project document templates to Google Docs. As I add more I'll post them up here. You...
-
You've heard many reasons why project fail. Here is a discussion hosted by BCS on why projects work. The discussion covers four dimensio...
-
The Precedence Diagramming Method ( PDM ) was developed in the early 1960s by H.B. Zachry in cooperation with IBM. It has largely repla...
-
In the below video some of the #10yrsagile participants discuss the role of the Business Analyst. A question for you; Do you agree or di...
-
This is a guest post by Jeff Hobbs. Jeff is a project manager at ActiveState Software who provide pm and collaboration software. Email, ...
-
In one of the Carnivals of Business Analysts the theme was “ Requirements Analysis ." I searched the web far and wide and came up with a n...
-
I'm a massive Lord of the Rings fan. Every year, I spend part of my holiday vacation rewatching the 12 hours of the blu-ray extended edit...
-
The definition of a stakeholder is controversial. For example, project team members are generally not considered stakeholders, but in virtua...

0 comments:
Post a Comment