1 / 16

Not another spreadsheet: Project Tracking in cbfish

Not another spreadsheet: Project Tracking in cbfish.org. An overview of the data management challenges faced by a rather large mitigation program, and the system we created to overcome those challenges. Matt Deniston, Sitka Technology Group American Fisheries Society Annual Meeting

Download Presentation

Not another spreadsheet: Project Tracking in cbfish

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Not another spreadsheet: Project Tracking in cbfish.org An overview of the data management challenges faced by a rather large mitigation program, and the system we created to overcome those challenges. Matt Deniston, Sitka Technology Group American Fisheries Society Annual Meeting Seattle, WA, Sept 4-8, 2011

  2. The Situation: $$$ Annual expenditures have steadily increased from $2.3 million in 1980 to $310 million in 2011. Cumulative to date: over $10.5 billion.

  3. The Situation: Large Scope One of the largest environmental mitigation programs in the world • 260,000 square miles (France) • 600 active projects,1300+ total projects • MOAs signed with tribal and state entities • NOAA and USFWS regulation: Endangered Species Act

  4. The Situation: Data Chaos Draft Jan07 Decision Summary-Budget-Reqs-BOG-Apr08 Traditional tools of memos, spreadsheets, mini databases no longer worked Public Comments ‘07 ISRP Review 5 FY07 Budgets v.23 In Lieu Ratings Jul07 Capital Ratings Jul07 Fish Accord DRAFT budgets Budget Change Requests UPA Projects Mar2005 Decision History Expenditures FY05-06

  5. The Situation: Regulatory Pressures Biological Opinions have significantly increased demand for reporting and tracking ColumbiaBasin Fish & WildlifeProgram

  6. The Situation: ??? Results Lack of a sustained rebound in the salmon and steelhead runs makes no one happy… Source: Fish Passage Center, www.fpc.org/adultsalmon/adultqueries/Adult_Annual_Totals_Query_Results.asp

  7. The Challenge To design and build a transparent web-based system for managing the program’s obligations, objectives, activities, and accomplishments. Obligations • NW Power Act • ESA – BiOps • Fish Accord 10 year agreements Objectives Wildlife Columbia Basin Fish & Wildlife Program ResidentFish • {title} • {text} AnadromousFish • Activities • Budgeting • Portfolio Analysis • Project Reviews Accomplishments

  8. The Solution: cbfish.org

  9. Schedule & Key Deliverables Project Records & Budgets Interactive Maps & Reports Project Proposals & Change Requests Dashboards& Web Services 10/1/2008 10/1/2009 9/30/2010 New System of Record / Process Improvements Improved Info / Analytics

  10. Approach for design & development of cbfish.org • Iterative & collaborative • Requirements evolve with real-world use • Updates to software every 2 weeks • Continuous feedback loop Design Requirements Deliver Analysis Time System Capability

  11. Extreme Makeover

  12. Ways to view/manage a project Example project: “Avian Predation on Juvenile Salmonids”

  13. Data visualizations: High Level Indicator charts

  14. Data visualizations: Accomplishments by ESU

  15. Benefits of cbfish.org • Provides transparent public access • Centralizes info for easy access and sharing • Tracks progress towards obligations and objectives • Delivers new insights into accomplishments & areas where more is needed • Enables program to grow – more restoration, more research and monitoring, etc.

  16. Questions? Thanks for your time! Matt Deniston, matt@sitkatech.com

More Related