Starter Clean
Make your data clean, consistent, organized, and ready for analysis.
Data intake & assessment
- Review data sources and file formats
- Assess data structure and quality
- Identify missing, inconsistent, and problematic fields
- Document initial data-quality issues
Data cleaning
- Remove duplicate records
- Handle missing values
- Correct inconsistent values
- Standardize text, dates, and numeric formats
- Correct obvious data-entry errors
Data formatting & standardization
- Standardize column names
- Standardize categories and labels
- Convert data types
- Standardize date and time formats
Data validation
- Check for invalid values
- Identify outliers and unusual records
- Validate business rules
Data organization
- Reorganize datasets into analysis-ready structures
- Prepare clean datasets for Excel, SQL, Python, SAS, Tableau, or other analytics tools
