Detailed Course Outline
Context
- Context is one of the important subjects for using the correct DAX functions.
Different types types of context
- Row context
- Selection context
- Filter context
Datamodelling
- Setup a robust datamodel
- Using DAX Studio (Basis)
- Creating a date-table in DAX vs. Power Query
- Other table functions like FILTER & ADDCOLUMNS
- When do yo use a measure table??
- How to setup a measure table?
- How to use Display folders
- The difference between measurements and calculated collumns
- When do you use DAX and when are you going to use Power Query?
- Using implicit and explicit measurements
- Formatting measurements
- Documenting measurements
Calculation function: The Swiss Army knife of DAX [list] [*] Extensive use of Calculate in combination with other FILTERS [*] CALCULATE with OR & AND. [*] CALCULATE with various filter options [*] Calculate with ALLSELECTED FUNCTION [*] CALCULATE with ALLEXCEPT FUNCTION [*] CALCULATE with VALUES FUNCTION [/list] Influencing relationships with DAX [list] [*] USERELATIONSHIP FUNCTION [*] CROSSFILTER FUNCTIONS [/list] Parameters in Power Query [list] [*] Creating dynamic Parameters [*] Using dynamic Parameters [*] Using Parameters in a template file [/list] Parameters in DAX [list] [*] Creating & using DAX Parameters [/list] Cumulative Column functions [list] [*] Cumulative Columns via Calculate, Filter and MAX [*] Counting and cumulative Columns via RANKX, FILTER and EARLIER [*] Using the TOPN function [/list] Time Intelligence functions [list] [*] Creating YTD / MTD functions [*] Comparing periods (YoY / MoM etc.) [*] Applying ISINSCOPE & HASONVALUE [*] Calculating rolling averages [/list] Report Design [list] [*] Using bookmarks [*] Adding buttons and navigation [*] Theme design [*] Using tooltips [*] Creating drill-through pages [*] Applying row-level security
[/list]