PowerPivot for Excel 2010 and SharePoint 2010

On Friday, I was catching up on my podcasts and listing to Hilton Giesenow‘s The MOSS Show and in Episode 34 Hilton interviews Pej Javaheri from the SharePoint B.I. team at Microsoft about Business Intelligence and SharePoint.

What got my attention was  PowerPivot which is an add-in for Excel or SharePoint that allows you to connect to large tables of data to do pivot table analysis.

PowerPivot Tools as seen on Excel 2010 ribbon
PowerPivot Tools as seen on Excel 2010 ribbon
PowerPivot Window Tools
Tools Shown in PowerPivot for Excel window

Continue reading “PowerPivot for Excel 2010 and SharePoint 2010”