Excel Business Intelligence Part 3: Power Pivot and DAX | Chris Dutton | LYNDA

Excel Business Intelligence Part 3: Power Pivot and DAX | Chris Dutton | LYNDA
English | Size: 763.99 MB
Category: Tutorial

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.

Topics include:

• Power Pivots versus normal pivots
• Creating calculated columns and measures
• Power Pivot and DAX best practices
• Math, stats, and COUNT functions
• CALCULATE, FILTER, and ALL functions
• Joining data with RELATED
• Using iterator functions (SUMX and RANKX)
• Time intelligence formulas

Table of Contents:

Introduction
1. Getting Started
2. Power Pivot and DAX 101
3. Common DAX Functions
Conclusion

Buy Long-term Premium Accounts To Support Me & Max Speed

DOWNLOAD:

If any links die or problem unrar, send request to http://goo.gl/aUHSZc

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.