Data Preparation and Cleaning Online Course
Join our virtual, live instructor-led session and master Data Preparation and Cleaning Training from anywhere in the world.
Upcoming Virtual Training Schedules
Join from anywhere in the world with our live instructor-led sessions
| Code | Start Date | End Date | Duration | Fee | |
|---|---|---|---|---|---|
| DCP-02 | Mon - Fri (10 Days) | USD 1,700 | Reserve my seat → Register my team → | ||
| DCP-02 | Mon - Fri (10 Days) | USD 1,700 | Reserve my seat → Register my team → | ||
| DCP-02 | Weekend (8 Weeks) | USD 1,700 | Reserve my seat → Register my team → | ||
| DCP-02 | Mon - Fri (10 Days) | USD 1,700 | Reserve my seat → Register my team → | ||
| DCP-02 | Mon - Fri (10 Days) | USD 1,700 | Reserve my seat → Register my team → | ||
| DCP-02 | Weekend (8 Weeks) | USD 1,700 | Reserve my seat → Register my team → |
Here's What You'll Learn
Each module tackles real challenges you face in your role
Why Data Cleaning Matters
Understanding Data Structures
Common Data Issues and How to Spot Them
Cleaning with Excel
Data Cleaning with Python
Structuring Data for Reporting
Validating and Verifying Data
Documenting Your Data Cleaning Process
Building Better Data Habits
Automating Repetitive Cleaning Tasks
Market-specific guidance for Papua New Guinea
A country-aware view of the pressures, proof points, and practical tools that shape how this course applies locally.
Tools and platforms relevant to this field
5Field-relevant examples that may be featured in training where they support the confirmed scope. Exact coverage depends on participant needs and delivery format.
-
Stata StataCorpThe primary tool used by the World Bank and PNG government researchers for cleaning and weighting complex survey data.
-
REDATAM ECLACUsed by the National Statistical Office for processing and cleaning large-scale census and demographic data.
-
SurveySolutions World BankThe standard platform for CAPI data collection in PNG, featuring built-in validation rules to clean data at the point of entry.
-
Power BI MicrosoftIncreasingly used by PNG's corporate sector (e.g., BSP, Kina Bank) to visualize cleaned administrative and financial data.
-
Microsoft Excel MicrosoftThe most common tool for administrative data management and initial cleaning across PNG's public and private sectors.
Real-World Case Studies from Papua New Guinea
2-
World Bank High Frequency Phone Survey Data Cleaning 2023World Bank Group
To monitor the socio-economic impact of COVID-19 in PNG, the World Bank conducted multiple rounds of phone surveys. The raw data required extensive cleaning, including recoding 'Other, specify' open-ended responses into categorical variables and correcting errors identified through quality control monitoring.
The cleaned datasets were published in the World Bank Microdata Library, enabling evidence-based policy making for the PNG government and development partners.
View source -
Demographic and Health Survey (DHS) Data Processing 2023National Statistical Office (NSO) of Papua New Guinea
Supported by UNFPA and the Australian Government, the NSO implemented rigorous data cleaning and processing for the DHS using specialized software to handle complex health and sanitation indicators across diverse provinces.
Produced high-quality statistics on sanitation and hygiene that informed the PNG Vision 2050 and Sustainable Development Goal (SDG) monitoring.
View source
Where this course runs
Data Preparation and Cleaning Training is delivered in the cities below — pick the one that fits your schedule.
