Modeling Data and Writing DAX

Star schemas, relationships, measures and DAX calculations in Power BI semantic models.

MSBA-261 12 lessons planned ▶ Video lessons coming soon

Offered by HSM University · Microsoft Certification Prep

Course content

  1. 1Star schema designComing
  2. 2Relationships and cardinalityComing
  3. 3Date tablesComing
  4. 4Calculated columns versus measuresComing
  5. 5DAX basics and evaluation contextComing
  6. 6CALCULATE and filter contextComing
  7. 7Time intelligenceComing
  8. 8Iterators and rankingComing
  9. 9Calculation groups and field parametersComing
  10. 10Row-level securityComing
  11. 11Model performanceComing
  12. 12Case study: a profitability modelComing

Requirements

Recommended background. You can start any course at any time.

Description

Star schemas, relationships, measures and DAX calculations in Power BI semantic models.