Microsoft PowerPivot for Excel and SharePoint


As you may already know from some of the tweets concerning #PowerPivot, the book Microsoft PowerPivot for Excel and SharePoint is now available at  The book’s authors are Sivakumar Harinath, Ron Pihlgren, and Denny Guang-Yeu Lee (i.e. myself).  Siva and Ron are both long time (this is a good thing) testers with the Analysis Services team.  And myself, well – you already know who I am (just in case you don’t, I’m with SQLCAT specializing in Analysis Services and PowerPivot).

This is an end-to-end book describing all of the moving parts within PowerPivot.  It is written in difficulty order – that is, each chapter is written corresponding from the novice to more advanced concepts.  We cover all the aspects of Excel and DAX – but we also cover the many moving parts concerning SharePoint including: PowerPivot for SharePoint, Excel Services, Geneva / Claims Token,  and Troubleshooting. 

We cover a lot of stuff in this book – so much so that by the time you finish reviewing it, it may actually be possible to understand our vaunted PowerPivot Client/Server Architecture! 🙂

PowerPivot Client Server Architecture

I certainly hope you enjoy it!

Happy Reading!


  1. […] also get a chance to win one of two copies of the Professional Microsoft PowerPivot for Excel and SharePoint book as […]

  2. […] of seconds (yes, I’m still a fan of PowerPivot – full disclosure, I’m co-author of the book Microsoft PowerPivot for Excel and SharePoint).  But if I want to easily determine how many of those 54M rows has the any column contain the […]

Leave a Reply

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

You are commenting using your 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