From the course: Excel Business Intelligence: Power Pivot and DAX

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Power Pivots versus normal pivots

Power Pivots versus normal pivots - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot and DAX

Start my 1-month free trial Buy for my team

Power Pivots versus normal pivots

“

- [Instructor] Let's take two minutes and talk about the differences between a normal pivot table and a power pivot table. Here on the left side of the screen, I've got a screenshot from a normal pivot. Here we're looking at the sum of a quantity metric broken down by day. We're looking at our field list on the right side of the screen and here's a power pivot version of the same view. I've got a total quantity metric. It's broken down by day. I've got the same filters set above the table and we're looking at our field list on the right. Now, the obvious difference that you've probably noticed is that in the power pivot version, boom, we've got access to way more tables. The normal pivot version just lists fields within this single table or source that we're pointing to. Power pivot allows us to access any of the fields in any of the tables in our data model and then analyze them based on any relationships that we've defined. That's the most obvious of the differences, but there's one…

Contents