Given the diversity of the Use Cases and Requirements a Sakai Warehouse seems to be a viable solution.
Sakai warehouse (definition):
*Provides an integrated and total view of learning/collaboration enterprise
*Makes the enterprise's current and historical information easily available for decision making
*Makes decision-support transactions possible without hindering operational systems
*Presents a flexible and interactive source of strategic information
Each use case below has a page to house discussion and examples. The image at right is a diagram linking the use cases, the actors and their responsibilities.