Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

70e0dd03af7558936035655768d96700?s=47 Matt Ball
November 02, 2012

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

presented at the UNC Conference on Water, Sanitation and Hygiene

70e0dd03af7558936035655768d96700?s=128

Matt Ball

November 02, 2012
Tweet

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
  5. None
  6. The development process • Observed need to improve workflows ▫

    manual data analysis ▫ manual reporting ▫ poor data management
  7. None
  8. R. Bain

  9. None
  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