Data Reconciliation: Process, Standards, and Lessons
In 2016, the Colombian National Administrative Department of Statistics (known as DANE) conducted a data gap analysis of the data currently available to monitor Colombia’s progress on the Sustainable Development Goals (SDGs) – revealing that 16 percent of SDG indicators were missing data (and/or there was no methodological clarity to measure the indicator) and 30 percent had only partial data.
In response, the Sustainable Development Solutions Network (SDSN) and Centro de Pensamiento Estratégico Internacional (Cepei) began testing new methods to collect this missing SDG data. Their source: the private sector in Colombia. Specifically, 2.6 million records of business performance living in the Bogotá Chamber of Commerce’s databases.
The project partners hypothesized that a technological data reconciliation platform would support the public-private data sharing process, but encountered challenges ranging from awareness-raising and trust-building to data access and confidentiality.
Read about the outcomes of this project and learnings for future data reconciliation projects in this process brief.
Fredy Rodriguez and Philipp Schönrock, Centro de Pensamiento Estratégico Internacional – Cepei
Melika Edquist, Jessica Espey, Jay Neuner, and Leslie Rae, Sustainable Development Solutions Network – SDSN