"In my eyes, data cleansing practices are an important part of my job duties and responsibilities. At the high level, I start with a data cleansing strategy, so I know what the goals and expectations are for the data cleansing initiative. Here is a list of best practices that I follow that has helped me become a better data consultant.
1.Develop a data quality plan - (Create data KPI's, know where data errors occur, determine where the data is coming from, and perform root cause analysis on data health).
2.Standardize customer contact data - (Check important data at the point of entry and create a standard operating procedure).
3.Validate and verify the accuracy of data - (Use manual, web, and email verification).
4.Identify duplicate entries - (Manual and automated systems).
5.Append data for accuracy - (Company name, contact first name and last name, title, phone, email, location, revenue, product lines, company stock, etc.)."
