I need a data-mining specialist to lift the overall quality of a set of structured datasets that currently live in multiple spreadsheets. The work centres on profiling each sheet, uncovering inconsistencies, resolving duplicates, standardising formats, and flagging any gaps that require follow-up. The spreadsheets hold relational-style information but lack the validation rules you would normally find in a database, so I’m expecting you to apply proven data-quality techniques—think column profiling, constraint discovery, referential checks, and outlier detection—using tools you are comfortable with (Python/pandas, Power Query, OpenRefine, SQL-based utilities, or similar). Deliverables: • A cleaned, consolidated version of every spreadsheet (original structure preserved where needed). • A brief, plain-English report that outlines the issues found, the rules applied to fix them, and any residual anomalies that need business input. Everything should be reproducible, so please keep your scripts or macros well-commented and include them with the hand-off.