What are the best practices for data cleaning?
Data cleaning - is the process of recognizing inaccurate or unethical data from a database. To ensure that the customer data is employed within the most efficient and meaningful manner , which will increase the elemental value of the brand, business enterprises must give importance to data quality.
Steps for data cleaning –
- For enormous datasets, break them into little information. Working with less information will speed up.
- If you've got a problem with data cleanliness, arrange them by estimated frequency and attack the foremost common problems
- Break down the synopsis measurements for every section (standard deviation, mean, number of missing qualities).
- Keep track of each date cleaning operation, so you'll alter changes or remove activities if required.
Also Read: Updated Business Analyst Questions for 2020
BY Best Interview Question ON 22 Sep 2020