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 some of the fields are different to each other. Also these data have some missing values. duplicate dataset etc. I am getting these data from various institutions, which implies each data from each institutions differ slightly in the field to other institution and I am thinking of a tool to use to evaluate this data.

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