Join Chris Dutton for an in-depth discussion in this video Introduction to Power Pivot and DAX, part of Excel Business Intelligence Part 3: Power Pivot and DAX.
- All right guys, you made to section five.…Power Pivot and DAX 101.…In this section we'll be talking about what makes…Power Pivot so different and so much more powerful…than traditional pivot tables.…We'll cover some really important fundamental concepts…like row context versus filter context,…and calculated columns versus measures,…and then from there we'll be ready to really dive in…and explore our data with DAX functions in the next section.…
- 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.