A cross post from my colleague Kasper de Jonge. He found some great video’s out on the PowerPivot Technet site. Video’s about the architecture you will work with when using PowerPivot for SharePoint. Pretty neat stuff.
The video’s are presented by Lee Graber, Senior Software Developer, Microsoft SQL Server Analysis Services.
Part 1: SharePoint User Identity Fundamentals for PowerPivot Server Administrators
Part 2: Security Context of PowerPivot Connections in a Farm
Part 3: PowerPivot Data Refresh in SharePoint
Part 4: Using PowerPivot Workbooks as a Data Source








