How do I clean and transform messy data before putting it into a dashboard?

Standardize field names and formats, fix invalid values, handle missing records, remove or merge duplicates, and document business rules for derived fields. Do that work in a repeatable data layer so the dashboard receives clean data every refresh.