Power Pivot and Power BI

January 2016

Power Pivot and Power BI

The best-selling guide to Power Pivot

Expanded 2nd edition - now in full color!

category: Power Pivot
covers: Microsoft 365, Excel 2013 - 2016

Product Details
  • 308 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-039-6
  • PDF ISBN: 978-1-61547-226-0

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft's tightly-related pair of revolutionary analytical tools - tools that are fundamentally changing the way organizations work with data. We have repeatedly witnessed the 'Power tools' transformative impact on the bottom line - far more robust and elegant than Excel alone, and much more agile and affordable than traditional BI tools. Their shared state of the art calculation engines (DAX and M) turn any PC into an analytical supercomputer, but the real secret is people - these tools are 100% learnable by today's users of Excel. The data revolution lays not in the hands of an elite few, but in YOUR hands, and we want to help you seize that opportunity.

  • Introduction
  • 1- A Revolution Built on YOU
  • 2- What Version of PowerPivot Should You Use?
  • 3- Learning PowerPivot 'The Excel Way'
  • 4- Loading Data Into PowerPivot
  • 5- Intro to Calculated Columns
  • 6- Introduction to DAX Measures
  • 7- The 'Golden Rules' of DAX Measures
  • 8- CALCULATE() - Your New Favorite Function
  • 9- ALL() - The ìRemove a Filterî Function
  • 10- Thinking in Multiple Tables
  • 11- 'Intermission' - Taking Stock of Your New Powers
  • 12- Disconnected Tables
  • 13- Introducing the FILTER() Function, and Disconnected Tables Continued
  • 14- Introduction to Time Intelligence
  • 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun
  • 16- SUMX() and Other X ('Iterator') Functions
  • 17- Multiple Data Tables
  • 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER()
  • 19- Performance: How to keep things running fast
  • 20- Advanced Calculated Columns
  • 21- The Final Transformation: One Click That Will Change Your Life Forever
  • A1- Further Proof That the Game is Changing
  • A2- So Much Power, So Little Space: Further Capabilities
  • A3- Four Common Error Messages
  • A4- People: The Most Powerful Feature of PowerPivot

Where to Buy

MrExcel Bookstore

eBook from MrExcel.

MrExcel Bookstore

Print book from MrExcel


Print book from Amazon.

Other Editions

DAX Formulas for PowerPivot

December 2012

Fundamentally of course, this book is intended to train you on PowerPivot. It captures the techniques I’ve learned from three years of teaching PowerPivot,

Related Products

Master Your Data with Power Query in Excel and Power BI

August 2021

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.