Steps for reviewing your ETL pipeline
Discussing the ETL pipeline, an often unaddressed step in the impact measurement process, and how reviewing and refining this pipeline can address many common hurdles & lead to efficient and reliable data.
Discussing the ETL pipeline, an often unaddressed step in the impact measurement process, and how reviewing and refining this pipeline can address many common hurdles & lead to efficient and reliable data.
Version 3.2 of the Common Impact Data Standard brings important improvements to how impact data is organized and checked for accuracy.
Explaining the “collective shrug”, a metaphor used in the Common Framework to signal a shift in mindset about impact data aggregation. It means accepting that we may never get perfectly uniform or precise data across a diverse ecosystem—and that’s okay.
The rationale behind our recommendation that organizations keep their indicator framework and indicator reports in separate tables (or tabs).
A summary of key findings from “Impact measurement among social purpose organizations: which practices are associated with useful, non-burdensome impact measurement.” The paper analyzes Common Approach participant data to determine a clear, concise set of practices that empower SPOs to measure effectively without feeling overwhelmed.