Applied Excel Tools: Power Pivot and Power Query Essentials

Data Analysis Expressions, or DAX, is the formula language of Power Pivot, but there are many similarities with Excel formulas. Learn the basic functions of DAX in this course.

Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power Pivot. You will see that an understanding of Power Pivot and DAX lets you create more complex and insightful charts and tables, without leaving Excel.

In our second course on Data Analysis Expressions, we’ll look at areas of DAX that can be a little bit more difficult to implement, like time intelligence. We’ll also demonstrate some of the important concepts that underpin DAX, such as contexts and filtering. Once you can understand this course, you’ll be well placed to understand DAX comprehensively.

Monte Carlo simulation allows us to identify possible and probable outcomes from a process by simulating it repeatedly. Learn how to create these simulations in this course.