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 5: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 9: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

A business analysis checklist helps you stay organized while you work through projects. It includes questions that will help you identify problems in your current processes, and suggest improvements for future projects. Understand the Problem Before you start writing code, you need to understand what problem you're solving. This means u...
I’ve heard “The End is Near!” for Business Analysts for almost 20 years.  Waterfall project management, with its need for formal requirements, is dead…a dinosaur…so 1990’s.  To be honest, that’s mostly true.  With the publishing of the Agile Manifesto in 2001 there was no need for a 2-inch-...
Business analysis is used to identify and articulate the need for change in how organizations work, and to facilitate that change. As business analysts, we identify and define the solutions that will maximize the value delivered by an organization to its stakeholders. We look for opportunities for new business models and new ways to work together. ...

 






 

Copyright 2006-2022 by Modern Analyst Media LLC