Combine DAX—Data Analysis Expressions—with Excel Power Pivot and take your Excel analysis skills to the next level.
- View Offline
- [Voiceover] Hi, I'm Ron Davis, and welcome to Excel Power Pivot Data Analytic Expressions, or DAX. In this course, we will look at DAX syntax, operators, data types, and the library of functions. We will also explore the concept of evaluation context, with a dedicated chapter of videos so you could have an understanding of how the output of a DAX expression changes depending on the context where it is evaluated.
We will take a closer look at the concept of filter functions, and also the calculate function. Arguably, the most revolutionary of all of the DAX functions. The influence of time on reports is critical for analytics. We examine how time intelligence works, along with explaining how you can source a calendar that will work for your DAX expressions at your company. Power Pivot is said to be the greatest advance for Excel in 20 years, and it takes an understanding of DAX to unlock the power of that advance.
So let's get going.
- Exploring DAX syntax and data types
- Using functions
- Understanding evaluation contexts
- Using CALCULATE to change evaluation context
- Working with dates
- Utilizing many-to-many relationships
- Implementing banding