Excel BI Wizardry: Harnessing Power Pivot and DAX

Description

In this course, learn how to leverage Data Analysis Expressions (DAX) and Power Pivot to analyze relational data models in Microsoft Excel. Explore adding calculated columns and measures, understanding the differences between them, and mastering common DAX formulas and functions. Gain insights into best practices for working with DAX and Power Pivot.

What will you learn?

1. Examine troubleshooting options affecting Excel performance while using Power Pivot.
2. Explain the differences between Power Pivot and other Excel PivotTables.
3. Describe the functionality of calculated columns.
4. Determine the appropriate use of functions in DAX formulas.
5. Identify results returned by using the CALCULATE function.
6. Review the use of slicers with Power Pivot.