Back to Skills

Skill focus

Data Cleaning

Data cleaning is the work that makes reporting trustworthy: fixing inconsistent values, missing fields, duplicates, and formatting problems.

PythonpandasSQLExcelPower Query

How it helps in an office

Most office data starts messy. Cleaning helps teams avoid bad counts, duplicate follow-up, wrong categories, and reports that leadership cannot trust.

Practical examples

  • Standardize names, dates, categories, and statuses.
  • Flag duplicates and missing required fields.
  • Create repeatable QA checks for recurring reports.
  • Give staff clear feedback on data entry issues.

What I focus on

quality checks
standardization
deduping
validation