Professional Microsoft PowerPivot for Excel and SharePoint and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $44.99
  • Save: $23.55 (52%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 19, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
FREE Shipping on orders over $35.
Used: Good | Details
Sold by RentU
Condition: Used: Good
Comment: Fast shipping from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $35. Overnight, 2 day and International shipping available! Excellent Customer Service.. May not include supplements such as CD, access code or DVD.
Access codes and supplements are not guaranteed with used items.
Add to Cart
Qty:1
  • List Price: $44.99
  • Save: $13.34 (30%)
FREE Shipping on orders over $35.
Only 10 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Professional Microsoft PowerPivot for Excel and SharePoint Paperback – June 15, 2010

ISBN-13: 978-0470587379 ISBN-10: 0470587377 Edition: 1st

Buy New
Price: $31.65
Rent
Price: $21.44
32 New from $23.77 27 Used from $7.51
Amazon Price New from Used from
eTextbook
"Please retry"
Paperback
"Please retry"
$31.65
$23.77 $7.51

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Professional Microsoft PowerPivot for Excel and SharePoint + DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution + Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills)
Price for all three: $76.25

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 384 pages
  • Publisher: Wrox; 1 edition (June 15, 2010)
  • Language: English
  • ISBN-10: 0470587377
  • ISBN-13: 978-0470587379
  • Product Dimensions: 9.1 x 7.5 x 0.8 inches
  • Shipping Weight: 1.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon Best Sellers Rank: #676,811 in Books (See Top 100 in Books)

Editorial Reviews

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.

wrox.com

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.


More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.5 out of 5 stars
5 star
7
4 star
2
3 star
0
2 star
1
1 star
0
See all 10 customer reviews
Between this book and the blog they mention in the book, this was a worth the money spent.
Bryant
Professional Microsoft PowerPivot is an excellent manual authored by key members of the Analysis Services & SQLCAT teams.
Derek Comingore
Overall, I'd highly recommend this book to anyone interested in PowerPivot and self-service BI.
tlachev

Most Helpful Customer Reviews

11 of 11 people found the following review helpful By Rob Collie on August 19, 2010
Format: Paperback
(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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Kasper de Jonge on August 2, 2010
Format: Paperback
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 !
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Vidmantas Matelis on October 3, 2010
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Dan English on August 2, 2010
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 $$$.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By tlachev on August 1, 2010
Format: Paperback
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Search