Join Chris Dutton for an in-depth discussion in this video Final section, part of Excel Business Intelligence Part 3: Power Pivot and DAX.
- Alright, congratulations guys.…You've made it to the final section…of the course, Section Seven.…I hope you enjoyed that DAX section, it's really cool,…really powerful functions you can do with DAX.…Now in this section, it's really just…about wrapping things up.…We're gonna talk about some data visualization options…using tools like pivot charts, Power View,…cube functions, etc., and then give…a little sneak peek into Power BI.…Now, spoiler alert, if you take all…of the skills you've just learned…through this course up to this point,…Power Query, data modeling, Power Pivot,…and DAX, that's the exact same engine…that drives Power BI.…
So you're already 90% of the way to learning Power BI,…which is an awesome little bonus.…So with that, thank you guys…again for joining, enjoy the rest of the course.…
- 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.