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

Fabricio Laguna talks Business Analysis and AI
I recently connected with Fabricio Laguna, aka The Brazilian BA. Fabricio is a passionate and pioneering business analyst from Brazil. During our conversation, we had a thought-provoking discussion on how artificial intelligence stands to shape the field of business analysis in the years ahead. While AI promises to transform many aspects of busines...
Business Architecture, Ontology and More with Terry Roach
It's been a privilege meeting Terry Roach, a visionary in the field of enterprise architecture and business architecture. Terry's insights into the evolution of business models, the importance of ontology in architecture, and the potential of AI to shape our future were not only thought-provoking but also a reflection of his extensive exper...
Today I had the pleasure of chatting to Jignesh Jamnadas, Chief Operations Officer at Mosaic, about his Blueprints for Success. As a Senior Finance and Operations Executive, Jigs (as he is known to many) has a holistic understanding of all facets of business and a flair for managing both people and processes. Having worked with Jigs, I was struc...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC