Reports As Data Feeds for PowerPivot
Donald Farmer explains in this one minute video how report data feeds (“the orange button”) are simply great data sources for further analysis in PowerPivot. You get the benefits of both, Reporting Services as platform with all its reporting and management features (e.g. role-based security, cache refresh) and PowerPivotas powerful analysis tool.
Enjoy!