Learn how to use Power Pivot and the DAX language to explore and analyze relational data models in Excel.
- [Chris] Hey everyone. Chris Dutton here, and welcome to Excel Business Intelligence Part 3: Power Pivot and DAX. In this part of the course we'll practice using Power Pivot and Data Analysis Expressions, known as DAX, to explore and analyze the data model that we built in part two. We'll add some powerful calculated columns and measures to our model and practice working with some of the most powerful DAX tools like statistical functions, logical operators, text and filter formulas, and time intelligence.
Keep in mind that this is part three of a three-part series, so we'll be picking up right where we left off from part two, which covered Data Modeling 101. Make sure to either work through sections one and two first or download the completed part two project file so that you can follow along from here. We have a lot to cover, so let's dive in.
- 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.