This is the issue. I have some huge dataset that I want to process to remove outliers, data preprocessing, processing, dashboards, reporting and analysis. But these dataset are not consistent and the some of the fields are different to each other. Also these data have some missing data. duplicate dataset etc

Question: Therefore, do you know of any tools to develop to evaluate these dataset. Name at least 3 or more tools starting with excel and state the advantages and disadvantages of each of the evaluation tools?