Tags
Language
Tags
<<
December 2024
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31 1 2 3 4
  1. Home
  2. eBooks & eLearning
  3. Excel Business Intelligence: Power Pivot and DAX [Repost]

Excel Business Intelligence: Power Pivot and DAX [Repost]

Posted By: IrGens
Date: 5 Jun 2024 17:40:34
Excel Business Intelligence: Power Pivot and DAX [Repost]

Excel Business Intelligence: Power Pivot and DAX
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 4h 1m | 766 MB
Instructor: Chris Dutton

Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course—the third and final installment of the Excel Business Intelligence series—experienced Excel trainer Chris Dutton spells out how to use the DAX language and Power Pivot to explore and analyze relational data models.

Chris picks up where he left off in the previous installment of the series, demonstrating how to add calculated columns and measures to data models in Excel. He highlights the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.

Learning objectives

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

More Info

Excel Business Intelligence: Power Pivot and DAX [Repost]
UPWARDS