SOP7: Data cleaning and validation procedures

This standard operating procedure (SOP) is the seventh and last in the series. It provides comprehensive guidance on data cleaning procedures for surveys conducted using the ESPEN Collect platform. The data cleaning is essential to ensure the accuracy and reliability of survey data, which is essential for assessing the impact of neglected tropical diseases treated with preventive chemotherapy (PC-NTD). 

Good data is essential for making informed decisions, such as whether to resume drug distribution programmes. To support this process, ESPEN Collect offers data monitoring tools through the Metabase dashboard, enabling real-time monitoring of data quality during ongoing surveys. In addition, the platform provides ongoing support for data management, both during the survey and data cleansing phases. 

To speed up the data cleaning process and improve overall data quality, data managers from the Ministry of Health (MOH) and partner organisations are encouraged to actively participate. This guide will detail how they can effectively contribute to data cleansing efforts, highlighting the benefits of their involvement. 

By following this SOP, users will be equipped with the necessary procedures and best practices to ensure high quality data, supporting the successful elimination of targeted diseases