BNY Interview Question

How to improve data quality?

Interview Answer

Anonymous

Mar 8, 2020

1. Understand stakeholders needs, remove duplicates from the data 2. Check the columns whether it doesn't contain mixture of numerical and characters values 3. With advanced excel perform a vlookup and pivot tables to find granularity of data