To wrap up the course introduction, the instructor explain exactly what to expect (and what not to expect) from the course.
- [Instructor] Last bit of housekeeping…before we dive in.…Just want to set some expectations for the course.…Again, I'm on Excel 2016, 365 ProPlus,…so what you see on your screen may differ a little bit…from what I'm showing on mine…and that's especially true…if you're using the 2010 plugin version or a 2013 copy.…Number two, this course is really designed…to get you up and running with Excel's BI tools.…The goal of this course is to provide you…with a deep, solid, foundational understanding…of Power Query, Power Pivot, and DAX.…
I might simplify a few concepts along the way…to make them easier to teach and for you to grasp,…and we may pass over some of the more advanced tools.…Number three, these tools are incredibly powerful,…but, to be honest,…they can still be a little bit buggy sometimes.…Excel uses a ton of processing power,…so it helps to close other workbooks and applications…while you're working on the data model for the course.…Of course, this should go without saying,…but save early and often.…Especially save new backup versions every once in awhile,…
- 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.