To the SharePoint. Andrew Connell [MVP SharePoint] Home. Sharepoint Tips And Tricks. Are you in Canberra this week?
Even if not, you may want to read this post. This week I am presenting in the Canberra SharePoint User Group about PowerPivot for SharePoint. I have spent the weekend reading and testing this application - mostly trying to figure out how it is different from Excel Services. Basically, powerpivot for excel is a powerfull database analysis add on to excel that creates connections to external databases, analyses the relationships for you and allows you to create great pivot tables and charts from this relational external data. This makes creating pivot tables from complex databases very simple.