No post yesterday because I had to do a sleep study, although if I knew Chapter 2 was going to be so short I would have done it before I went into the sleep lab. Anyway, chapter 2.
Chapter 2 is all about the different versions of PowerPivot for Excel. Well, not really all about them – more just a quick overview. My take on the PowerPivot for Excel version story and what’s important:
To my mind, there are two major versions: PowerPivot for Excel 2010 and PowerPivot for Excel 2013. There are two minor versions for Excel 2010 – one tied to the SQL Server 2008 R2 release and one tied to the SQL Server 2012 release. All versions of PowerPivot for Excel are separate, downloadable add-ins for Excel. There is no download for PowerPivot for Excel 2013 – it’s just a part of Excel, in the Office box and installed (although not enabled).
Some of the functionality of PowerPivot is now in Excel and the PowerPivot add-in doesn’t need to be installed for you to create a basic PowerPivot model. Since this post is a summary of Chapter 2 of Rob’s book, I won’t say too much more about the details but if you have questions, leave a comment and I’ll attempt to answer them.
Two other main points round out the chapter – you should favor 64-bit Excel & PowerPivot. I agree with that advice. Another point is that the PowerPivot interface is different on Windows XP. Also one thing to note about PowerPivot on Windows XP – only 32-bit is supported.