Using Power Pivot
Summary
PowerPivot is a full scale OLAP tool that works inside of Excel 2010. It does allow direct connection to a database and will import the data directly. The tools offer all the previous power of the OLAP tools supplied in SQL Server – though they are much easier to use. The video demonstration is analyzing a database using these tools.
Video
Download
http://office.microsoft.com/en-us/excel/download-powerpivot-HA101959985.aspx