Sale!

Master DAX fundamentals : Power BI, Power Pivot & SSAS (Updated 7/2017)

Original price was: $999.00.Current price is: $49.00.

This Course is available for download now. You can contact us for Screenshots or Demo. Access for this course will be sent on google drive. Join our telegram channel to see updates and occasional discounts. If you want to pay through Paypal or Card contact us – On Telegram Click Here or contact on Mail – [email protected]

Description

Master DAX fundamentals : Power BI, Power Pivot & SSAS (Updated 7/2017)

Master DAX fundamentals : Power BI, Power Pivot & SSAS (Updated 7/2017)
2.5 h | Video: AVC (.MP4) 1280×720 30fps | Audio: AAC 44.1KHz 2ch | 629 MB Genre: eLearning | Language: English
What Will I Learn?
Explain and use Calculated Columns and Measures
Explain and use aggregation functions and expressions in DAX such as SUM and COUNT
Explain and use table functions such as Filter and RelatedTable
Explain and use iteration pairs such as SUMX and COUNTX
Set up Variables

Work with

IF statements and DAX SWITCH function
Describe the fundamentals of how DAX works
Explain Row context and nested Row context
Explain Filter context
Use the ALL function to remove filters
Use the Calculate function to modify and replace basic filters
Explain and demonstrate how Relationships and DAX work together
Discuss the need for a DATE table
Use DAX to create a DATE table using CalendarAuto and other DAX functions
Use and explain Time Intelligence Functions such as TOTALTYD, SAMEPERIODLASTYEAR and more
Calculate Moving totals and Rolling Totals
Carry out Basic to Intermediate level DAX analysis

Work with IF statements and DAX SWITCH function
Describe the fundamentals of how DAX works
Explain Row context and nested Row context
Explain Filter context
Use the ALL function to remove filters
Use the Calculate function to modify and replace basic filters
Explain and demonstrate how Relationships and DAX work together
Discuss the need for a DATE table
Use DAX to create a DATE table using CalendarAuto and other DAX functions
Use and explain Time Intelligence Functions such as TOTALTYD, SAMEPERIODLASTYEAR and more

Explain and use Calculated Columns and Measures
Explain and use aggregation functions and expressions in DAX such as SUM and COUNT
Explain and use table functions such as Filter and RelatedTable
Explain and use iteration pairs such as SUMX and COUNTX
Set up Variables
Work with IF statements and DAX SWITCH function
Describe the fundamentals of how DAX works
Explain Row context and nested Row context

20%

off, especially for you 🎁

Sign up to receive your exclusive discount, and keep up to date on our latest products & offers!

We don’t spam! Read our privacy policy for more info.