Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Requirements  What are the business/data analyst activities to prepare for data cleansing and updating projects?
Previous Previous
 
Next Next
New Post 7/29/2020 4:29 AM
User is offline KarmaHazem
1 posts
No Ranking


What are the business/data analyst activities to prepare for data cleansing and updating projects? 

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

 
New Post 7/29/2020 8:54 PM
User is offline Kimbo
450 posts
5th Level Poster


Re: What are the business/data analyst activities to prepare for data cleansing and updating projects? 

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

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Requirements  What are the business/data analyst activities to prepare for data cleansing and updating projects?

Community Blog - Latest Posts

So you’ve found the perfect time and place to study and you’re ready to finally get some work done. You’ve pulled out your laptop, your textbook, and your notes, and four different highlighters. After five minutes of reading your textbook, you start zoning out and thinking about puppies. Then, you go on Tumblr and look at cut...
Elicitation involves bringing out or drawing out information. Elicitation is a key task in business analysis as without proper elicitation the requirements for the solution to the business needs cannot be identified. 1. Not understanding underlying business need Organization’s business environment keeps changing with respect to Customer...
TOGAF is a certification that is handed over by The Open Group. It is an open corporate architecture means used to improvise upon the business effectiveness across the world’s leading business set-ups. Aspirants wishing for a successful career in corporate architecture must go for the TOGAF certification in order to explain the...

 



 

Copyright 2006-2021 by Modern Analyst Media LLC