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 Welcome
1 Welcome
Getting Started
2 Important – Versions and compatibility
3 Set expectations
2 Important – Versions and compatibility
3 Set expectations
Power Pivot and DAX 101
4 Introduction to Power Pivot and DAX
5 Create a Power Pivot table
6 Power Pivots versus normal pivots
7 Introduction to Data Analysis Expressions DAX
8 Calculated columns
9 DAX measures
10 Create implicit measures
11 Create explicit measures AutoSum
12 Create explicit measures Power Pivot
13 Understand filter context
14 Step-by-step measure calculation
15 Recap – Calculated columns versus measures
16 Power Pivot best practices
4 Introduction to Power Pivot and DAX
5 Create a Power Pivot table
6 Power Pivots versus normal pivots
7 Introduction to Data Analysis Expressions DAX
8 Calculated columns
9 DAX measures
10 Create implicit measures
11 Create explicit measures AutoSum
12 Create explicit measures Power Pivot
13 Understand filter context
14 Step-by-step measure calculation
15 Recap – Calculated columns versus measures
16 Power Pivot best practices
Common DAX Functions
17 Introduction to DAX functions
18 DAX formula syntax and operators
19 Common DAX function categories
20 Basic math and stats functions
21 COUNT COUNTA DISTINCTCOUNT and COUNTROWS
22 Logical Functions IF AND and OR
23 Switch and Switch TRUE
24 Text functions
25 The CALCULATE function
26 Add filter context with FILTER – Part 1
27 Add filter context with FILTER – Part 2
28 Remove filter context with ALL
29 Join data with RELATED
30 Iterator X functions – SUMX
31 Iterator X functions – RANKX
32 Basic date and time functions
33 Time intelligence formulas
34 Speed and performance considerations
35 DAX best practices
17 Introduction to DAX functions
18 DAX formula syntax and operators
19 Common DAX function categories
20 Basic math and stats functions
21 COUNT COUNTA DISTINCTCOUNT and COUNTROWS
22 Logical Functions IF AND and OR
23 Switch and Switch TRUE
24 Text functions
25 The CALCULATE function
26 Add filter context with FILTER – Part 1
27 Add filter context with FILTER – Part 2
28 Remove filter context with ALL
29 Join data with RELATED
30 Iterator X functions – SUMX
31 Iterator X functions – RANKX
32 Basic date and time functions
33 Time intelligence formulas
34 Speed and performance considerations
35 DAX best practices
Conclusion
36 Final section
37 Data visualization options
38 Conclusion
36 Final section
37 Data visualization options
38 Conclusion
Excel Business Intelligence Part 3: Power Pivot and DAX
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 4h 01m | 764 MB
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 4h 01m | 764 MB
Download from Turbobit
Download from DepositFiles
Download from Rapidgator
No comments: