I have a new requirement to update the addresses in our DB based on addresses captured in excel, I want know how I can take the data in excel match it to what exists in our DB, figure out what we should and should not update and then update our DB?
I want to know in steps how to do that and write user stories so they can do the data celaning and updating ?
What techniques to use to elicit and analyze this requirement
Depends what you consider is your source of truth for addresses. Is it your database or perhaps its the official post office addresses in your country?
Try sorting that out first.
Then work out how to match your addresses to the truth address.
To do it well you'll need to account for misspellings, words that sound similar, etc.
Probably will need several passes. Final pass may be manual. Can be as complex as you want it to be
Kimbo
brought to you by enabling practitioners & organizations to achieve their goals using: