An Overview of Pipeline, Aquaya's Data Analysis and Management System

presented at the UNC Conference on Water, Sanitation and Hygiene

Transcript

1. An Overview of Pipeline, Aquaya’s Data Analysis and Management System Creative ICT Technologies at UNC November 2, 2012 Matt Ball – matt@aquaya.org The Aquaya Institute
2. Outline • Aquaya's background • an overview of Pipeline • the development process • use cases • roadmap • questions
3. Aquaya – a primer • Applied research non-profit, est. 2005 • San Francisco and Nairobi offices • Water Business Kits • Aquatest • Monitoring for Safe Water • ICT ▫ software development ▫ advising on monitoring programs
4. Pipeline • hosted tool for generalized data management and analysis ▫ https://pipelinehq.org • facilitates: ▫ uploading, aggregating and storing data ▫ dynamic graphing and statistical calculations ▫ periodic reporting • data is private • open source – MIT License
6. The development process • Observed need to improve workflows ▫ manual data analysis ▫ manual reporting ▫ poor data management
8. R. Bain
10. The development process (cont.) • leveraged existing data collection work • designed for specific but representative clients ▫ flexible periodic reporting • modular and multi-purpose
11. Use cases
12. Scenario one – system monitoring • follow performance trends
13. Scenario two – program management • analyze temporal and physical reach of an intervention
14. Scenario three – compliance • generate weekly reports on parameters out of specification
15. Scenario four – dissemination • send analyses to other team members or other organizations
16. Roadmap • mapping vs spatial analysis Fomhub.org
17. Roadmap (cont.) • tighter integration with other datasets ▫ weather ▫ health and outcomes • SMS alerts • public portals • more and better APIs
18. Thanks! • our work ▫ aquaya.org ▫ github.com/aquaya ▫ speakerdeck.com/aquaya • more questions? ▫ Matt Ball – matt@aquaya.org