Self-Service BI and PowerPivot Session @ SharePoint UK User Group – 2nd September 2010

Posted on August 30, 2010 by


I’ll be delivering another session at the Leeds/Bradford SharePoint UK User Group on 2nd September 2010 on Self-Service BI and PowerPivot. I’ll update this post to provide a link to the slide deck after the session. In the meantime, see the agenda below:


– What is PowerPivot?

– Architecture – PowerPivot for Excel and PowerPivot for SharePoint (Analysis Services & Vertipaq mode)

– Installing PowerPivot (Dev/Prod build considerations)

– The client tools – Excel-Add In for PowerPivot

– Connecting to back end line of business applications with a worked example

– Modelling data in PowerPivot with a worked example

– PivotTables/Charts

– Slicing and Dicing data in PowerPivot

– Custom queries using DAX

– Publishing PowerPivot applications to SharePoint

Posted in: Uncategorized