In this video, the instructor explores the similarities and differences between regular PivotTables and "Power" PivotTables, which connect to entire data models.
- [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 other important difference as well.…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.