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
http://online1.daytonastate.edu/player2.php?id=af5d5ef24881f3c3049a7b9bfe74d58b
Download
http://office.microsoft.com/en-us/excel/download-powerpivot-HA101959985.aspx
Comments (0)
You don't have permission to comment on this page.