I am wanting to detect corrupt and inaccurate records to check for data quality from large data sets that originate from Microsoft Access and Excel.
Things I would like to check for:
Validity which includes: data-type constraints, unique constraints, foreign-key constraints, regular expression patterns, cross-field validation
But also other things like data accuracy, completeness, consistency, uniformity
What is the best platform to use? RStudio or SQL? I am using Windows.