SQL Server 2008 R2 - Gemini
I would like to introduce you to a great new concept coming out with SQL Server 2008 R2 and Office 2010 called Gemini! The idea behind Gemini is managed self-service Business Intelligence. This means enabling users in various departements to make their own analysis in cooperation with central IT which decides which data sources can be used. The user interface for Gemini is Excel 2010. Users can connect to provided data sources and enhance them with their own non-structured data like other Excel sheets, data feeds, reports etc...
Here are some videos showing the described functionality.