57.1 DAX Formulas for PowerPivot – Chapter 2

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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s