A data cleaning process applied to a dataset related to companies' layoffs around the globe.
The purpose is to show the cleaning process normally applied to datasets, including some SQL skills.
- Remove duplicates (CTEs, Copy/create tables)
- Normalise data (Trim, Trim Trailing, working with dates, use of Distinct and LIKE, Update records)
- Dealing with Null/Empty values (convert empty to null values, Inner Joins to populate null values)
- Remove columns/rows (Alter... Drop, Delete records)