Sunday, February 28, 2010

PowerPivot for Excel

  • I’m just brushing up on my Excel skills prior to Office 2010 going to RTM later this year
  • I noted that the PowerPivot site has some good demos and hands-on labs available via www.powerpivot.com. There is also a good blog and two sample sets of data (pivot sample data) here and (SQL Server data) here
  • For a Windows 7 installation, for the SQL data set for Adventure-works demo, you will need SQL Server 2008 Express edition with Advanced services from here. Instructions and prerequisites here. NOTE: You have to install SQL Server Express SP1 BEFORE you commence the main install and reboot the system. Then you won’t get any compatibility warnings and fail the ‘restart’ section of the install! SP1 is more of a pre-patch 

image