DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution Paperback – Dec 12 2012
There is a newer edition of this item:
Customers who bought this item also bought
What other items do customers buy after viewing this item?
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your mobile phone number.
About the Author
A former Microsoft engineering leader, Rob Collie is an entrepreneur, author, and consultant who believes Excel is enjoying a renaissance in power and importance - a trend that provides massive opportunities for the millions of Excel practioners worldwide. His passion is empowering and the Excel Professional to seize those opportunities. When he's not training, consulting, or writing, Rob can be found in his laboratory, devising new tools and techniques for the Excel community. He also operates the world's leading PowerPivot website (PowerPivotPro.com) and occassionally sleeps.
Top Customer Reviews
I was able to apply right away the knowledge to my production database taking advantage of DAX powerpivot calculated fields I never imagined I could ever execute with pivot tables.
Thanks Rob for the book
Most Helpful Customer Reviews on Amazon.com
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.
Rob Collie's book not only fill in the gaps, it provides a solid foundation upon which you can confidently upgrade from Expert to Master.
I have never come across a technical book that delves deeply into a somewhat complex subject with such an easy to follow and funny style. You will hardly feel the need to read the same chapter again. Once you read it, you are ready to move on to next with a very clear understanding.
This book deserves 6 stars out of 5, and I highly recommend it for Excel/PowerPivot users
How wrong I was..
This is a book I just keep turning too time and time again. And, for as many times that I have referred to it, i have recommended it to coworkers who have purchased as well.
Rob's practical style of teaching by use building blocks and comedy make this a MUST read for anyone who has been using PowerPivot or has heard of its "special powers".
One for certain reality is something that Rob mentions many times in the book. It's this: PowerPivot will make you more valuable . It will make you the superhero among your coworkers and employer when it comes to insights about your business. This is something I said to myself the the first time I saw PowerPivot at a Microsoft conference several year ago.
I have all 3 books that make up this series.. All are just awesome, but this is the foundation..
A must buy.... A must investment in your career...
Written in an easy to understand prose, Rob takes PowerPivot users to the next level with Microsoft's new product.
Packed with tips, tricks, and 'traps' (to avoid) --- A Simple Guide... takes packs a tremendous amount of knowledge into a VERY QUICK read. A must reference and guide for analyst, project manager, finance manager, and engineer.
Order an electronic (Kindle) copy AND a printed book. You'll want to have Rob's insights handy the next time someone tells you "you can't do that in Excel", whatever that task is.
Rob, Marc Russo, Bill Jellen (and a few other) are the next faces on the Mt. Rushmore of Excel self-service BI.
This book addresses problems of managing extremely large datasets without the necessity of using SQL Server/SQL Server Analysis Services. Through thorough explanation and demonstration by examples, Rob Collie provides a structured decision-matrix for enterprise developers considering how to achieve performance improvements, deployment efficiency, and "non-coded" Excel (without VBA) solutions without the intervention of professional database programmers. I recommend this book for persons with limited VBA and SQL programming experience, as the PowerPivot engine exposes similar functionality achieved by programming through the use of DAX formulas - more easily comprehended by traditional users of Excel.
On its own merits, this book is so readable that I recommend it to anyone interested in Microsoft's vision of its future Office product. For example, the capability exposed through PowerPivot requires hefty system requirements, necessary to know prior to purchasing new workstations, or on the contrary, making a decision to use Office in the cloud or on a SharePoint Server. This subject and many others are covered by straight-talk explanation.