Start reading Professional Microsoft PowerPivot for Excel and SharePoint on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

Professional Microsoft PowerPivot for Excel and SharePoint [Kindle Edition]

Sivakumar Harinath , Ron Pihlgren , Denny Guang-Yeu Lee
4.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £29.99
Kindle Price: £25.71 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £4.28 (14%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £25.71  
Paperback £27.06  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of PowerPivot.

Professional Microsoft PowerPivot for Excel and SharePoint describes all aspects of PowerPivot and shows you how to use each of its major features. By the time you are finished with this book, you will be well on your way to becoming a PowerPivot expert.

This book is for people who want to learn about PowerPivot from end to end. You should have some rudimentary knowledge of databases and data analysis. Familiarity with Microsoft Excel and Microsoft SharePoint is helpful, since PowerPivot builds on those two products.

This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It provides an overview of PowerPivot and a detailed look its two components: PowerPivot for Excel and PowerPivot for SharePoint. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were. Through an extended example, it shows how to build a PowerPivot application from end to end.

The companion Web site includes all the sample applications and reports discussed.

Customers Who Bought This Item Also Bought

Page of Start over
This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Product Description

From the Back Cover

PowerPivot brings the power of MicrosoftBusiness Intelligence to Office 2010!

With PowerPivot, Microsoft brings the strength of Microsoft′s Business Intelligence (BI) toolset to Excel and PowerPoint users. Authoredby members of the Microsoft team behind the creation of PowerPivot, this book shows you how to use PowerPivot for Excel to create compelling BI solutions, perform data analysis, and achieve unique business insight. You′ll learn how to use PowerPivot for SharePoint to share your BI solutions and collaborate with others. And your organization will learn how to use SQL Server 2008 R2 management tools to acheive more efficient results.

Professional Microsoft PowerPivot for Excel and SharePoint:

  • Shows how to use PowerPivot for Excel to generate rich and interactive analysis solutions
  • Explores different ways to bring data into PowerPivot
  • Addresses sharing and collaborating on user–generated BI solutions in a SharePoint Server 2010 environment
  • Shows you how to troubleshoot, monitor, and secure PowerPivot services
  • Demonstrates how PowerPivot can meet the needs of Office, as well as how IT professionals can deploy and manage the self–service business intelligence system

Wrox Professional guides are planned and written by working programmers to meet the real–world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Programmer Forums
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More
Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

About the Author

Sivakumar Harinath is a Senior Test Manager on the SQL Server Analysis Services team and a coauthor of Professional Microsoft SQL Server Analysis Services 2008 with MDX.

Ron Pihlgren is a 15–year Microsoft veteran and member of the SQL Server Analysis Services team as a senior test manager.

Denny Guang–Yeu Lee is a member of the SQL Customer Advisory team and a coauthor of Professional Microsoft SQL Server Analysis Services 2008 with MDX.

Product details

  • Format: Kindle Edition
  • File Size: 10168 KB
  • Print Length: 386 pages
  • Page Numbers Source ISBN: 0470587377
  • Publisher: Wrox; 1 edition (25 May 2010)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B003O86FBI
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • : Not Enabled
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #993,360 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

5 star
3 star
2 star
1 star
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
4.0 out of 5 stars A good introduction to PowerPivot 7 July 2010
By JozephV
I was after a book on this latest BI offering from Microsoft and this was the first one I could get my hands on.

Didn't know too much about PowerPivot beforehand but the book has proved very useful in helping me get to grips with this technology. Its well written, with just the right level of technical detail together with useful insights into some of the thinking behind the technology - there's plenty of helpful screenshots too.

A good book to work through, using the sample healthcare database provided.

Would definitely recommend
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.5 out of 5 stars  10 reviews
12 of 12 people found the following review helpful
5.0 out of 5 stars Perfect for those deploying/evaluating a full PowerPivot System 19 Aug. 2010
By Rob Collie - Published on
(This is a condensed version of my full review at [...])

What the book is NOT

1) It is not the first book an Excel pro should pick up. It covers too much, and comes from a perspective that might seem a bit foreign. Start with Bill's book if this is your background.

2) Like Bill's book, it is only a light treatment of DAX. Again, this is wise, because DAX really deserves its own book. Those seeking a detailed DAX book should look forward to an upcoming title from Marco Russo.

3) It does not cover the real-world gotchas encountered in a full adoption of a PowerPivot system. After a full year of applying PowerPivot to real-world problems - six months as a product team member in exile (in Cleveland), and the last six months putting the full system into action at Pivotstream, I can say that there are a number of "gotchas" that you have to look out for in PowerPivot v1. They are not fatal - Pivotstream's PowerPivot platform is very much thriving - but you only discover them, and learn to avoid/overcome them, via real-world practice.

Anyway, for a just-released product, it's not like we can expect ANY book to cover that kind of thing. There's probably room for a book like "PowerPivot in the Trenches" but someone else needs to volunteer, as I, um, rarely get out of my trench :)

What the book IS - Consistently readable and info-rich

1) Great Information Density, but High Readability - When I finished the book, I immediately dropped an email to Denny/Ron/Siva and told them how impressed I was with the balance between density and clarity. As a de facto tech writer myself throughout my career, I can say that I struggle with this, and typically end up jamming in too much at the expense of readability, or a 50-page doc with so much whitespace that 20 pages would have covered it. Perhaps you have noticed.

It's hard to put my finger on how the book strikes such a nice balance - perhaps it's the editing, or the layout style - but I consistently noted how MUCH was conveyed on each page, while at the same time, it felt like a light read. That's saying a lot considering the list of topics covered.

2) Benefits of Three Product Team Authors - When you include all of the folks from teams like SharePoint, Excel, SSRS and others that contributed to PowerPivot, it's probably safe to say that the product reflects the efforts of 200+ people for several years. No one human being could possibly span all of that, and it only gets harder if you weren't directly involved in that process.

These three guys were working on the book for a long time, while the product was still in development. They all had different areas of focus, both in terms of natural affinities and in terms of dividing up their assignments. They then had a lot of time, and access to the people who were building the product, to refine the content.

The benefits of this authorship approach are evident in the book. You'll see what I mean - I always expect some "uneveness" in a tech book of this length because the talents and endurance of a single author are themselves uneven. Chapter to chapter, the red book's quality remains consistent.

Overall Recommendation

If you fit any of the following descriptions, I rate this book as a must-read:

- Anyone leading or contemplating a PowerPivot deployment (the total system, as opposed to just viewing it as Excel 2010++)

- Excel pros who have read Bill's book and want to expand their expertise - I suspect a lot of you will decide, correctly, that a full PowerPivot system makes your talents a lot more valuable and visible, and will find yourselves on point for test deployments

-BI or SharePoint pros who are ramping up on PowerPivot (or evaluating PowerPivot's impact on their work)

Rob Collie
4 of 4 people found the following review helpful
5.0 out of 5 stars Great book, great value when you want to know more on the PowerPivot internals 2 Aug. 2010
By Kasper de Jonge - Published on
The book is mainly targeted at the BI Professional or IT Pro. Chucked with interesting facts and tips you need to know when you want to install or deploy PowerPivot. It also contains very funny story's about how the product came to be with story's from the team.

It is split up in three main parts, first an introduction to PowerPivot, why do we need PowerPivot and a first look at PowerPivot. Great introductory work from the writers. The second part is "Creating Self-Service BI Applications Using PowerPivot". Here we learn how to work with PowerPivot itself from loading the data to publishing it to SharePoint.

The last part is truly meant for the It Pro with a setup, troubleshoot, architecture deep dive and Enterprise considerations. Great information anyone should know when they want to go and install PowerPivot for your company (or as a consultant).

I recommend this book for anyone who wants to start using or consulting PowerPivot at a professional level, it is really full with information and background. I read it in two days while I was on holiday great stuff !
2 of 2 people found the following review helpful
5.0 out of 5 stars Insightful and Easy to Follow PowerPivot Coverage from Horse's Mouth 2 Aug. 2010
By tlachev - Published on
I had the pleasure to read the book Professional Microsoft PowerPivot for Excel and SharePoint by Sivakumar Harinath, Ron Pihlgren, and Denny Guang-Yeu Lee. All of the authors are with the Microsoft Analysis Services team. Together with David Wickert, Denny Lee runs the PowerPivot Twins blog, which is "dedicated to all things PowerPivot". Siva has written the 2005 and 2008 editions of the Professional SQL Server Analysis Services with MDX. So, the book is straight from the horse's mouth.

I really liked the book. It's easy to follow and includes insightful tips. The book targets business users who are interested in creating self-service BI solutions. IT professionals and BI practitioners who will manage PowerPivot applications will find the book useful as well. Professional Microsoft PowerPivot for Excel and SharePoint incudes tutorials that walks the user through the necessary steps to build a PowerPivot-based solution. These steps include importing the data, enriching the data model, creating calculations, and reports. The code samples use a sample database for the healthcare industry - I guess that's because healthcare is the only industry with a budget for IT applications nowadays, or at least self-service BI apps. Adventure Works is probably waiting for the economy to bounce back.

Overall, I'd highly recommend this book to anyone interested in PowerPivot and self-service BI. The book does a great job explaining the capabilities and limitations of the tool. I couldn't stop reading it!
2 of 2 people found the following review helpful
5.0 out of 5 stars PowerPivot IT Pro must have book 3 Aug. 2010
By Dan English - Published on
Format:Paperback|Verified Purchase
This past month I purchased both of the PowerPivot books that were available. The first one I got was the Professional Microsoft PowerPivot for Excel and SharePoint (wow, that was a mouthful). I would have to say that this book is geared more toward the IT Professional where it does a great job covering the installation setup on the server side, managing and troubleshooting techniques, and going over some of the development.

The other part that I really like about this product was the additional insights that were provided by the product team members talking about how the product came to life and the different paths that were explored initially (originally MS Access was looked at...phew). The exercises that were provided were helpful and the troubleshooting section was very useful, especially coming from the IT side of the world. All-in-all I would highly recommend this book to the IT Pro and would give this book 5 out of 5 stars. Definitely worth the $$$.
2 of 2 people found the following review helpful
5.0 out of 5 stars Must buy book for anyone working with PowerPivot for SharePoint 3 Oct. 2010
By Vidmantas Matelis - Published on
This book has a great introduction to PowerPivot for Excel and explains its use. Most of the book is dedicated to explaining setup, troubleshooting, monitoring, and securing PowerPivot for SharePoint. All of the information is presented very well with a lot of step by step guides and screenshots. If you are an IT professional and are planning to use PowerPivot for SharePoint (or are already using it), this is a must have book - there is just no other book that covers the same topic in such detail.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category