The First PowerPivot Formulas Book Written Specifically for Excel Users
PowerPivot’s formula language (DAX) was created by Microsoft to turbocharge Excel’s existing capabilities. It puts truly revolutionary power in the hands of YOU, the “spreadsheet heroes” of the world.
DAX Formulas for PowerPivot is the Excel user’s ideal roadmap for harnessing PowerPivot’s career-changing capabilities, utilizing the style developed and refined during Rob Collie’s 3+ years of training fellow Excel users on PowerPivot:
1. Example-Driven: each concept, function, and technique is accompanied by a tangible example. Everything is both explained AND demonstrated.
2. Visual – the book features more than 300 illustrations, diagrams, and screenshots. You SEE everything.
3. Jargon-Free – no prior experience required with programming or business intelligence technologies. If you’ve created a PivotTable before, you are ready.
Buy the Book or E-Book
|“The style of the book is very visual and easy going, there are no dry explanations of database concepts or theory, it’s all about real examples of everyday data analysis problems and how to solve them using DAX. Also included are the little tricks and tips… which you are unlikely to see in any of the more theoretical books.”-Jacob Barnett, Commercial Analyst (Australia)|
|“Despite being a fairly accomplished Excel pro, I have been unable to wrap my arms around DAX. But that is over. Four days of working through this book with my own data and I am now making some damn cool stuff that eluded me before.”-Ken Puls, Founder of ExcelGuru and Microsoft-Recognized Excel MVP (Canada)|
|“Human… this is how technical books should be written.”-Tom LaRock||“…writing style is very addictive… it’s a real page-turner.”-Siraj Samsudeen|
|“Rob has a gift for explaining things in a way that makes it easy to understand.”-Shawn Frizzell||“…extremely well written, clear, concise and flows logically down your DAX adventure.”-Dave Boylan|
|“This book gets to grips with the real problems faced when implementing a powerpivot solution. The section on performance was especially worthwhile and the examples meaningful.”-Dave Pitts||“Packed with loads of super useful tips and tools. After getting through the first chapters I had already gotten my money’s worth. Best gift to data analysis in the 21st century.”-Dan Wesson|
This diagram from an early chapter of the book illustrates Rob’s
“Learn incrementally and at your own pace” philosophy
A Few Sample Pages – Click Each for Larger Version
Data Sources and Workbooks From the Book
All Files Used in the Book Are Available for Free Download
Click Image to Visit the Download Page