Course curriculum

    1. Welkom

    2. Download slides and files

    3. Intro

    4. Star schema’s

    5. Exercise 1: Many-to-many relationships

    6. Exercise 1: Many-to-many relationships

    7. Solution 1: Many – many relationship

    8. Demo: years table

    1. Overview Calculated Columns v.s. Measures

    2. DAX Date functions

    3. Logical Expressions

    4. Exercise 2A: Date Table

    5. Exrsice 2A: Date Table

    6. Solution 2A: Date Table

    7. Exercise 2B: Relate Data table to fact tables

    8. Exercise 2B: Modeling - Relate to Fact Tables

    9. Solution 2B: Relate Date table to fact tables

    10. Exercise 2C: KPI Matrix

    11. Exercise 2C: KPI Matrix

    12. Solution 2C: KPI Matrix

    1. Measures

    2. Exercise 3A: Measures

    3. Exercise 3A: Measures

    4. Solution 3A: Measures

    5. Organize Measures in Measure group

    1. SWITCH

    2. Exercise 4A: SWITCH – Age Categories

    3. Exercise 4A: DAX – SWITCH – Age Categories

    4. Solution 4A: SWITCH – Age Categories

    5. Exercise 4B: SWITCH – Age

    6. Exercise 4B: DAX – SWITCH – Age

    7. Solution 4B: SWITCH – Age

    8. Variables - VAR _ RETURN

    9. Lookup data RELATED _ RELATEDTABLE

    10. Exercise 4C: Measures & Calculated Columns

    11. Exercise 4C – DAX – Measures + Calculated Columns

    12. Solution 4C: Measures & Calculated Columns

    13. Lookup data without relationship - LOOKUPVALUE

    14. Exercise 4D: Avg List Price vs Sales Price with Lookupvalue

    15. Exercise 4D: Avg List Price vs Sales Price with Lookupvalue

    16. Solution 4D: Avg List Price vs Sales Price with Lookupvalue

    17. Lookup data without relationship - FILTER

    18. Exercise 4E: # of workable days

    19. Exercise 4E: # of workable days

    20. Solution 4E: # of workable days

    1. Introduction DATEADD _ ISINSCOPE

    2. Exercise 5A: Year over year Growth

    3. Exercise 5A: Year over year Growth

    4. Solution 5A: Year over year Growth

    5. Top 5 Time Intelligence expressions

    6. Relative Date Filter

    7. Exercise 5B: Time Intelligence YTD

    8. Exercise 5B: Time Intelligence YTD

    9. Solution 5B: Time Intelligence YTD

    1. Evaluate expression in Filter Context

    2. Change Filter Context: ALL / ALL_EXCEPT

    3. ALLSELECTED

    4. Exercise 6A: DAX – CALCULATE

    5. Exercise 6A: DAX – CALCULATE

    6. Solution 6A: DAX – CALCULATE

    7. USERELATIONSHIP (Role Playing Dimensions)

    8. Exercise 6B: CALCULATE – USE RELATIONSHIP

    9. Exercise 6B: DAX – CALCULATE – USE RELATIONSHIP

    10. Solution 6B: CALCULATE – USE RELATIONSHIP

About this course

  • Gratis
  • 64 lessen
  • 2 uur aan video-inhoud

Discover your potential, starting today

Enroll today