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

If you're looking to visualize, analyze, and share data insights with ease, Power BI might be the solution you need. In this article, we'll cover what Power BI is, why it's important, and how to get started with it. What is Power BI? Power BI is a business analytics service provided by Microsoft that helps users visualize and anal...
How to Write Business Analyst Resume
Business analysts must have an up-to-date, visually appealing resume to be able to stand out from the competition. A strong business analyst resume should accurately reflect your skills, experience and qualifications while also highlighting your accomplishments and successes. We will provide invaluable advice on how to build a strong, effective bus...
Are you testing your product in the most effective way?
Today covid-19 pandemic has completely flipped the business model. Various conventional Business models like banking and health had to adopt the digital era. Even the school and colleges have to create various applications so that they can provide online learning for their students. All these statements justify the modern business model as complete...

 






 

Copyright 2006-2023 by Modern Analyst Media LLC