Lynda - Excel Power Pivot DAX in Depth
Size: 434MB | Duration: 2h 25m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
Size: 434MB | Duration: 2h 25m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
You cannot get far in Excel Power Pivot, the future of personal business intelligence, without an understanding of DAX: Data Analysis Expressions. This course teaches you how to unlock DAX's power by understanding its fundamental elements: its syntax, operators, data types, and functions, including the revolutionary CALCULATE function. Author Ron Davis also helps you understand how evaluation context affects DAX expression output, and integrate time and dates into Power Pivot calculations. Start watching now to take your data analysis skills to the next level with DAX.
* 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
* Using functions
* Understanding evaluation contexts
* Using CALCULATE to change evaluation context
* Working with dates
* Utilizing many-to-many relationships
* Implementing banding
No mirrors below please.