Power BI (Introduction To DAX)

This course introduces Data Analysis Expressions (DAX) and provides you with foundational skills required to enhance data models with calculations.

Content:

• Introduction to Data Models
  • Data model fundamentals
  • Star schema design
  • Define analytic query
  • Configure report visuals
• Writing DAX Formulas
  • Describe DAX calculation types
  • Write DAX formulas
  • Describe DAX data types
  • Work with DAX functions
  • Use DAX operators
• Defining Calculated Tables and Columns
  • Create calculated tables
  • Create calculated columns
  • Describe row context
  • Choose technique to add a column
• Defining Measures
  • Describe measure types
  • Create Quick Measures
  • Describe differences between calculated column and measure
• Using DAX Iterator Functions
  • Describe iterator functions
  • Use aggregation iterator functions
  • Calculate ranks
• Modifying Filter Context
  • Describe filter context
  • Use the CALCULATE function
  • Use filter modifier functions
  • Examine filter context
  • Perform context transition
• Using DAX Time Intelligence Functions
  • Define Time Intelligence
  • Use Time Intelligence functions