Running PowerPivot for SharePoint on Windows 7

Given the allure of being able to work on PowerPivot for SharePoint solutions on a single workstation, laptop, or personal computer, my first choice in development environments is to run everything on a single machine. However, given Microsoft's decisions around both their virtualization products (Hyper-V and Virtual PC) and the move of the application platform to 64-bit–only versions (SQL Server 2008R2 and Office SharePoint Server), running PowerPivot for SharePoint leaves some significant decisions for the training environment.

As an example of the choices, unless you are prepared to install (or at least dual-boot) a server operating system (Windows Server 2008 R2), then Hyper-V is not really a ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.