Here's a really good article from the Berkeley Lab View on the work that Catharine Van Ingen and Stuart Ozer from MSR have been involved with w/ LBL and the Berkeley Water Center. The use of SQL Server Analysis Services and Reporting Services have made a real difference in how scientists can explore AmeriFlux and water sensor data. You can see the datasets for the AmeriFlux and the Russian River at http://bwc.berkeley.edu/ Also Deb Agarwal and team have done a real good job w/ their User Manual outlying how to access the data via the web and Excel
Lab Team Helping Smooth Flow of Water Data
By Jon Bashor
A collaboration among Microsoft, Berkeley Lab and UC Berkeley is underway to make it easier for researchers to access and analyze collected data on water, with the goal of accelerating research in the increasingly important areas of water supply and climate change.
Called Microsoft e-Science, the project is part of the Berkeley Water Center’s effort to marshal expertise from public institutions and the private sector to enable researchers to easily access and work with water data. The year-old center is the brainchild of Berkeley Lab’s Computational Research Division (CRD), UC Berkeley’s College of Engineering and UC Berkeley’s College of Natural Resources.