In this video, the instructor quickly reviews some of the key considerations when it comes to data model performance and speed, including the use of slicers, iterator functions, and redundant columns.
- [Instructor] All right, so I figured I would just…walk through some speed and performance considerations,…especially if you're working with large data models,…or you're writing a tone of DAX,…understanding what has an impact to…speed and importance is pretty important.…So, a couple'a tips for you guys.…Number one, avoid using unnecessary slicers…or considering disabling cross-filtering.…So, what I mean by that,…slicers are pretty cool tools, but the thing is,…they cross-filter by default.…And that means if you've got two related…slicers on a pivot, and the selections in one…are dependent on the selections in the other,…like country and state, for instance,…what Excel will do behind the scenes…is calculate all this complex, cross-filtering logic…to gray-out or disable the irrelevant selections.…
And that's really cool, and it's really user friendly,…but it also eats up a ton of processing time.…So if you feel like your model, or your Power Pivot…workbook is working really slowly,…slicers would be the first place that I'd look.…
- 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.