In this video, the instructor outlines some of his personal favorite Power Pivot and DAX best practices.
- [Instructor] All right, congratulations,…you've wrapped up the Power Pivot and DAX 101 section.…Remember that the whole goal of this section was…to lay that foundational groundwork…to help you understand how…to use these tools most effectively.…But to wrap things up, let's cover my three best practices…for Power Pivot.…Number one, avoid using implicit measures whenever possible.…Remember that these are really limited in functionality…and implicit measures are restricted to the pivot…in which they were created.…
On the other hand, explicit measures,…which we're gonna be focusing on from here on out,…are much more portable and much more powerful.…Number two, don't use a calculated column…when a measure will do the trick.…Now we talked about the pros and cons,…the similarities and differences.…What's important to remember is…that you should only use calculated columns…when you want to stamp static, fixed values or attributes…to each row in a table…and you should use measures…when any sort of aggregation is necessary,…
- 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.