PowerPivot for the Data Analyst: Microsoft Excel 2010 and over one million other books are available for Amazon Kindle. Learn more
Buy New
$25.36
Qty:1
  • List Price: $34.99
  • Save: $9.63 (28%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $6.45
Gift Card.
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 this image

PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library) Paperback – June 13, 2010

ISBN-13: 978-0789743152 ISBN-10: 0789743159 Edition: 1st

Buy New
Price: $25.36
30 New from $21.36 23 Used from $17.46
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$25.36
$21.36 $17.46

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




Frequently Bought Together

PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library) + DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution
Price for both: $47.52

Buy the selected items together

NO_CONTENT_IN_FEATURE

Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

Product Details

  • Series: MrExcel Library
  • Paperback: 336 pages
  • Publisher: Que Publishing; 1 edition (June 13, 2010)
  • Language: English
  • ISBN-10: 0789743159
  • ISBN-13: 978-0789743152
  • Product Dimensions: 9.2 x 7 x 0.7 inches
  • Shipping Weight: 1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (36 customer reviews)
  • Amazon Best Sellers Rank: #113,707 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Bill Jelen , Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary, Ellen and his sons, Josh and Zeke.


More About the Author

I spent twelve years 'in the trenches', working as a financial analyst for finance, accounting, marketing and operations departments of a $500 million company. Armed with a half-rate reporting tool and a spreadsheet, I was responsible for turning large amounts of data into analyses for the board room quickly and accurately. Working originally in Lotus 1-2-3 and then Microsoft Excel, I honed techniques to take massive amounts of data and produce meaningful reports in record time. These techniques are spelled out in Guerilla Data Analysis Using Microsoft Excel.

In 1998, I launched MrExcel.com, which is now one of the three most popular Excel websites with 21 million annual page views. Being MrExcel is now my full-time gig. My team has developed custom applications for hundreds of clients around the world. I enjoy entertaining a room full of accountants with my 'Power Excel' seminar.

When I am not Excelling, you can find me and the family under the stars enjoying a movie at one of the many drive-in theaters that still dot northeast Ohio or kayaking on the Mogadore Resevoir.

Customer Reviews

4.2 out of 5 stars
5 star
20
4 star
8
3 star
4
2 star
4
1 star
0
See all 36 customer reviews
The prose is very easy to read.
Bill Draper
Overall, this is an excellent introduction to PowerPivot which takes you all the way from importing data to creating dashboards for the boardroom.
Amazon Customer
Unfortunately the supporting sample files do not lend themselves well to the examples given in the book.
barnkb

Most Helpful Customer Reviews

19 of 19 people found the following review helpful By Bill Draper on July 28, 2010
Format: Paperback Verified Purchase
The good:
* Excellent information on new features and capabilities of PowerPivot tables. Lots of good examples.
* Good compare & contrast with base PivotTables.
* Good documentation of some of the v1 PowerPivot limitations.
* The prose is very easy to read.

The gaps:
* The book was written before the final product was delivered. It would be good to see some errata/revisions covering changes made in the mean time for early buyers.
* Probably somewhat related to the above, the discussion of DAX is fairly limited. DAX is the real key feature that makes PowerPivot more powerful than base PivotTables. (The best reference source I've seen so far is the MS "Data Analysis Expressions in PowerPivot for Excel 2010" document.)
* It would have been nice to explain some considerations when moving models from PivotTables to PowerPivot. For example, PivotTables by definition have to have everything in one giant table. PowerPivot models end up working better with separated lookup (dimension) tables in my experience so far.
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
14 of 16 people found the following review helpful By Rob Collie on August 23, 2010
Format: Paperback
Excerpt from my full review at PowerPivotPro:

My biggest overall conclusion after reading Bill's book is that Excel users will be hard-pressed to find a better place to start their PowerPivot journey. Bill is not a SQL guy and he is not an MS employee - he has been building spreadsheets in the wild since before Pivots even existed. And for many years now he has made his living simply teaching others to get the most out of Excel.

That history and perspective shows through in the book. Reading it is VERY different from reading any of the MS documentation on PowerPivot for instance - that MS content is excellent at describing PowerPivot, but it just isn't written by a multi-decade Excel maestro, so it doesn't tell Excel users, in detail, what will be familiar to them and what will be new.

What the book is NOT

Clocking in at 294 pages, this book doesn't try to do everything, which I think is wise. I don't think any Excel pro wants to pick up, as a starting point, a 1200 page bible. This book is an excellent intro and you will hit the ground running fast, but at some point later, you will eventually go looking for:

- An in-depth guide to high-powered DAX measures
- An in-depth guide to the implications of various table structures and relationships
- Performance-tuning reference
- A how-to reference for deploying PowerPivot for SharePoint
- List of best practices, tips and tricks, workarounds for Excel Services on SharePoint

Like I said, as an Excel pro, you are MUCH better off NOT trying to tackle those up front. You can get incredible mileage out of PowerPivot without once touching those topics. You will want to someday, but you don't NEED to, so I highly recommend Excel pros pick up this book as their starting point.

-Rob Collie
PowerPivotPro
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
7 of 8 people found the following review helpful By barnkb on June 2, 2011
Format: Paperback
This is the first book I have used written by Mr. Jelen. It is obvious he knows his stuff and I can envision that he is very adept at the art of teaching. However, this book is written in a manner similar to other "How To" books in the sense that he describes step-by-step how to achieve a desired result in understanding a concept. Unfortunately the supporting sample files do not lend themselves well to the examples given in the book. First, it took a bit of sluething to even find the files (the link provided in the book was not a valid link) and then after the file was finally discovered, the naming of those files had almost no correlation with the book exercises. After some poking around and guesswork, you can usually find the file you're seeking but it should be much more obvious than it is. Also, the sample files should contain two states, the raw file to use so you can do the exercise and then a solution file. I wonder if everyone involved in this book had the goal to get it out early and just didn't want to take the time to make following the exercises a little more student friendly.

On one other unrelated note.... I have purchased other books that are accompanied by a CD that contain a searchable PDF of the book. This is a very much appreciated and useful companion to the hard copy. If producing a CD is problematic for the publisher for whatever reason they have, perhaps an online version could be made available?
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 Amazon Customer on October 29, 2010
Format: Paperback
This book examines in detail PowerPivot which is a free add-in for Excel 2010. It makes possible the analysis of very large amounts of data normally beyond the capability of Excel. PowerPivot is not for the faint hearted and is aimed at experienced users of Excel who are familiar and comfortable with lookup functions, pivot tables and databases.

To take full advantage of the book, you will need to download PowerPivot from [...] and also the author's example files from [...] There are 32-bit and 64-bit versions of PowerPivot and it is essential that you choose the one which matches your 32-bit or 64-bit version of Excel 2010.
The introductory chapter is a personal and interesting account which puts PowerPivot into context and shows the enthusiasm that Mr Excel has for his subject. After discussing how to obtain and install PowerPivot the book then begins to go into detail about how and when to use this application. Whilst it is clear that the author is a passionate advocate of PowerPivot, he is also critical of what he sees as shortcomings - for example, not easily being able to sort in month order - and he devotes a whole chapter to explaining the circumstances in which you might decide that a conventional pivot table might be a better approach.

The book gives detailed descriptions of the steps involved in many different tasks clearly illustrated with accompanying diagrams and supported by the exercise files that you can work through yourself.
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

Customer Images

Most Recent Customer Reviews

Search