Data Cleaning and Preparation Techniques
Most of the effort in analytics goes into getting data ready, not analysing it. This practical workshop teaches the techniques needed to clean, structure, and validate data so that analysis rests on a solid foundation.
Course outline
What this programme covers, module by module.
- 01Spotting errors, gaps and inconsistencies in raw data
- 02Standardising formats and removing duplicate records
- 03Handling missing values and treating outliers sensibly
- 04Reshaping data into a tidy analysis-ready structure
- 05Validating data against expected rules and ranges
- 06Documenting each preparation step for repeatability
- 07Merging data from different sources without introducing errors
What you will gain
- Spot errors, gaps, and inconsistencies in data
- Standardise formats and remove duplicates
- Handle missing and outlier values
- Reshape data into an analysis-ready structure
- Validate data against expected rules
- Document data preparation steps
Who should attend
- Data and reporting analysts
- Administrators handling data sets
- Research and evaluation staff
- Anyone preparing data for analysis
Upcoming sessions
| Date | City | Duration | Fees | Book |
|---|---|---|---|---|
| 2 to 3 Nov 2026 | Pretoria | 2 Days | R10,000 | |
| 10 to 11 Nov 2026 | Durban | 2 Days | R10,000 | |
| 30 Nov to 1 Dec 2026 | Cape Town | 2 Days | R10,000 | |
| 11 to 12 Jan 2027 | Johannesburg | 2 Days | R10,000 | |
| 8 to 9 Feb 2027 | London | 2 Days | US$1,100 | |
| 12 to 13 Apr 2027 | Dubai | 2 Days | US$1,100 | |
| 14 to 15 Jun 2027 | Pretoria | 2 Days | R10,000 |
Fees are per delegate and exclude VAT. Public intakes are confirmed once minimum numbers are met. We also deliver this course on your own schedule, in-house or live online.
Enquire about this course
Register your team or ask for a tailored in-house quote. We reply within one working day.
WhatsApp usCourse brochure (PDF)- Fees from
- R10,000 per delegate
- Duration
- 2 Days
- Field
- Data & Analytics
- Formats
- In-house, public, online
More in Data & Analytics
Data Analysis and Visualisation with Excel
Excel remains the most widely used analysis tool in business, and few use it to its full potential. This course takes participants beyond basic formulas into structured analysis, PivotTables, and clear charts that reveal what the numbers mean.
Power BI for Business Intelligence and Reporting
Power BI turns scattered data into interactive reports that decision-makers can explore for themselves. This course guides participants from connecting data sources through building models to publishing dashboards that stay current.
Introduction to Data Analytics for Decision Making
This course demystifies data analytics for professionals who need to use data but are not specialists. Participants learn how to ask the right questions, interpret results, and use evidence to support better decisions.