{"currencyCode":"USD","itemData":[{"priceBreaksMAP":null,"buyingPrice":19.69,"ASIN":"1615470158","isPreorder":0},{"priceBreaksMAP":null,"buyingPrice":21.43,"ASIN":"1615470212","isPreorder":0},{"priceBreaksMAP":null,"buyingPrice":18.94,"ASIN":"1615470271","isPreorder":0}],"shippingId":"1615470158::lIzrzCSvrSMj7eo4Q7L%2BU%2Fe8qrp9H%2B6MsMcUJCLITI7%2FO4795SuHKlPVbGP48CUnXjIZzDM3pId%2FX8Q3EZt%2B%2FiNKZaP6ovcfYVBQmW1GAdVQlE9Ue%2F2NsQ%3D%3D,1615470212::XWulPDGEnRWAUUi%2BiGp%2B4Y2c%2Bc8pF5cLCUfP5Kh0xZqeDLoFRVjJopKhHU2DRR0VkFrJQbSFaSgv%2BdVoN6vOiPdhkCJYrsdN8rnjEexsXUzzWypAY7mYvA%3D%3D,1615470271::3T0pfdQF1KChR9tIwYjO0xzyrOMhu5rDvSH7fJcip4djtmpLSzlNBN5Vp8f%2FoDIGxLCNw4NS6mRVBYGzF85K3JIK2bwDN160QR9snPgUIeZvFMSBOSXh9Q%3D%3D","sprites":{"addToWishlist":["wl_one","wl_two","wl_three"],"addToCart":["s_addToCart","s_addBothToCart","s_add3ToCart"],"preorder":["s_preorderThis","s_preorderBoth","s_preorderAll3"]},"shippingDetails":{"xz":"availability","yz":"same","xy":"availability","xyz":"availability"},"tags":["x","y","z"],"strings":{"showDetails":"Show details","differentAvailabilityAll":"Some of these items ship sooner than the others.","addToWishlist":["Add to Wish List","Add both to Wish List","Add all three to Wish List"],"shippingError":"An error occurred, please try again","differentAvailability":"One of these items ships sooner than the other.","preorder":["Pre-order this item","Pre-order both items","Pre-order all three items"],"addToCart":["Add to Cart","Add both to Cart","Add all three to Cart"],"showDetailsDefault":"Show availability and shipping details","priceLabel":["Price:","Price for both:","Price for all three:"],"hideDetailsDefault":"Hide availability and shipping details","hideDetails":"Hide details"}}
Customers viewing this page may be interested in these sponsored links
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle Edition for FREE. Print edition purchase must be sold by Amazon.
Learn more.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
Thousands of books are eligible, including current and former best sellers.
Look for the Kindle MatchBook icon on print and Kindle book detail pages of qualifying books. You can also see more Kindle MatchBook titles here or look up all of your Kindle MatchBook titles here.
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
I follow the blog of the author, Rob Collie. After seeing the video of the book getting printed I knew that I had to buy it. Oh, that and I'm a big PowerPivot fan and general Excel junkie. The book is a blast. Rob has a great writing style, honest and fun.
First, PowerPivot doesn't put Excel on steroids. Nor does it turbo charge it. Those metaphors fall short. It's more like PowerPivot takes a solid family sedan that you think you know and turns it into a NASCAR race car.
DAX Formulas for PowerPivot walks you through PowerPivot and how to get the most out of it's powerful DAX formulas. This not merely a reference book. It's full of how to's. Plus it's got nice big illustrations. I do have a couple of warnings for this book though:
1) I found myself up very late playing with PowerPivot stuff while reading this book. Don't start the book if something to do the next day, like go to work. Seriously, I'm not kidding.
2) Read the whole book. I had a personal project that coincided with some of the items in the book, so I started the project while reading the book. I ended up rebuilding the project twice as I worked through the examples. In my initial pass, my project was taking more than a minute to reload the data from the database. After following Rob's performance tips at the end, the reload was down to 13 seconds.
3) The short links to more information are case sensitive and contain both upper and lower case letters. Be careful when you type them.
Bottom line, if you use Excel for anything, and you can spell PowerPivot, you owe it to yourself to see what it can really do. This the book to teach you how.
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
12 of 12 people found the following review helpful
I can't say much more about this book that hasn't been said here or on other blog reviews.
It's a very good book for getting started with PowerPivot if you have never used it before. If you have some PowerPivot experience, but are mostly self taught from blogs and other random sources, then this is a good book to help "fill in the cracks" and consolidate what you already know.
I have read many technical books over the years on everything from Access to Excel to SQL Server to SharePoint...etc. While many have been good, I don't know that I would classify any as "page turners". This book is as close as a technical book can get. Rob has a unique writing style which he has been demonstrating on his blog for several years now. He is gifted at explaining very techinal issues in an easy to follow and engaging manner. One example flows to the next as does each chapter. It doesn't get bogged down in technical details but gives a solid explanation of real world examples.
I can see myself referencing this for years to come.
I will be recommending this to everyone on my team as well as others throughout my company that show an interest in PowerPivot.
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
10 of 10 people found the following review helpful
First let me say that I read several technical books a month, and have reviewed them for Manning Publications on several occasions. So I have some pretty high standards that must be met before I give a book five stars. I am teaching myself PowerPivot for work, and have Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning which is very thorough, but this book is more helpful. It focuses most on what I know least about--Data Analysis eXpressions, or DAX. It begins with the assumption that the reader is an Excel power user, or "Excel Pro" as the author calls us. It therefore gets right into the material related to PowerPivot, without wasting time or space on things everyone who uses Excel professionally already knows. The author's writing style is entertaining, turning what could be a very dry topic into something you want to celebrate along with the writer. I love his side remarks, such as: "You will not see me create another implicit measure in this book. They are dead to me." My only complaint is a formatting one. Much of the text is in a green font that shows as a much lighter gray on the regular Kindle, making it hard to read. Even on the Fire I would have preferred a choice with more contrast. Despite that little annoyance, the book is a fast, enjoyable read with the information presented effectively and in an order that makes perfect sense to an Excel Pro. I am tempted to go ahead and buy a print copy just to have as a reference for my team, it is that good.
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
10 of 12 people found the following review helpful
I've known Rob Collie (blog | @powerpivotpro) for over two years now, ever since he accosted me at TechEd in 2010. Since then we've met up at some SQL Saturdays, the 2010 PASS Summit, and we even collaborated on the computing power and hard dollar costs adjusted for inflation. And by "collaborated" I mean "I emailed Rob and asked him to show me what to do". And then he did. True story.
When I read that post on Moore's Law again it made more sense to me this time. The reason why is because I just got done reading his most amazing book: DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX
When I opened the book to flip through the pages I will admit I was slightly disappointed in what I first saw: a bunch of formulas like CALCULATE(), DATEADD(), and COUNT(X). I thought "Oh, no, Rob has gone and written a book like all the other tech books out there, full of formulas and a desire to be like a textbook that it is likely never going to be." Knowing Rob this surprised me a bit and since I had already spent my money I figured I might as well start reading it anyway.
I started reading his while sipping on my coffee this past Sunday morning. I was done with the book before lunch. Not because it was a short read, but because I just could not put it down.
Rob walks you through what is essentially the training program he uses with clients that want to know how to use PowerPivot. He gives you step by step examples and ties everything back to clearly defined use cases. He mixes in some anecdotal stories along the way, too. Rob worked at Microsoft for many years and as a result he has many, many stories to share. I think the one about Steve Ballmer was my favorite.Read more ›
1 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
If you have a question or problem, visit our 