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

m_anst
m_anst
What Does Success Look Like? I challenge Business Analysts to view requestors’ requirements as an opportunity to define success. Too often, teams fall into a trap focused on requestors’ prescriptive requirements that are meant to serve as roadmaps for developers and testers. When you limit your view of requirements to this prescripti...
0 Responses
Mariya Kotsupalova
Mariya Kotsupalova
They say the best criteria of Business Analyst’s success are a happy customer (business) and a happy engineering team. But what does it mean? How can we break down happiness and measure it? These are precisely the questions my 8 BAs team and I tried to answer this year. The result was a surprisingly efficient pair of surveys we developed and ...
0 Responses
Rajesh-N
Rajesh-N
Explore the Benefits of RPA's Adoption Across Segments In the past few years, we have seen steady growth in Robotic Process Automation (RPA). It gathered momentum in 2019 and became a hot topic in IT and business circuits in 2020. The power of process automation will be felt even more strongly, propelling its adoption as a replacement f...
0 Responses






Copyright 2006-2020 by Modern Analyst Media LLC