Categories

There are currently no items in your shopping cart.

User Panel

# Master DAX fundamentals : Power BI, Power Pivot & SSAS

7.99 \$
Video Introducing this tutorial

Master DAX fundamentals : Power BI, Power Pivot & SSAS :
Introduction
How to take this course

DAX (Data Analysis Expression) An Introduction :
What is DAX
Calculated Columns and Measures
SUM and SUMX
Count and CountX
Currency Data Type and the need to ROUND in DAX
DAX DIVIDE expression
When you need a BLANK for the right data type
Related and Related Table
MIN and MAX
Other Expressions
IF Statements
Working with Text in DAX
Section Wrap up
Section 1 Activities

How DAX works :
How DAX works
Table Functions
Ignore Filters
Combining Table Functions
Nested Row Context
Calculate
More on Calculate
Section 2 Wrap up
Section 2 Activity

Time Intelligence Functions :
Introduction to Time Intelligence
Creating a Date Table
Multiple Date Tables
Marking a Date Table
Year to Date Calculations
How Time Intelligence Works
Looking Back in Time
Parallel Periods
Moving Totals
Overall Total
Time Intelligence conclusion
Section 3 Activities

Conclusion :
Course Conclusion
Thank you and bonus
Bonus

Master DAX fundamentals : Power BI, Power Pivot & SSAS
Introduction
How to take this course

DAX (Data Analysis Expression) An Introduction :
What is DAX
Calculated Columns and Measures
SUM and SUMX
Count and CountX
Currency Data Type and the need to ROUND in DAX
DAX DIVIDE expression
When you need a BLANK for the right data type
Related and Related Table
MIN and MAX
Other Expressions
IF Statements
Working with Text in DAX
Section Wrap up
Section 1 Activities

How DAX works :
How DAX works
Table Functions
Ignore Filters
Combining Table Functions
Nested Row Context
Calculate
More on Calculate
Section 2 Wrap up
Section 2 Activity

Time Intelligence Functions :
Introduction to Time Intelligence
Creating a Date Table
Multiple Date Tables
Marking a Date Table
Year to Date Calculations
How Time Intelligence Works
Looking Back in Time
Parallel Periods
Moving Totals
Overall Total
Time Intelligence conclusion
Section 3 Activities

Conclusion :
Course Conclusion
Thank you and bonus
Bonus