Power Pivot vs regular Pivot Table

Power Pivot vs regular Pivot Table

There are multiple differences between the Data model (Power Pivot) based Pivot Tables and regular Excel data based Pivot Tables. Most of them come from the fact that the Power Pivot (or the Data Model) is, in fact, an offline OLAP cube. This fact alone unlocks great potential in Pivot Table capabilities. In this video, we will focus on three of those capabilities.

Battle of the Pivots

All Excel files used in making of this YouTube tutorial.

Three differences between regular Pivot Tables in Excel and those that are based on the Power Pivot model, that we will show in this video:

  1. Different Calculations on SubTotal and Grand Total levels
  2. Column-based or Row-based Sets
  3. OLAP tools – convert to formulas command