YoVDO

Use DAX in Power BI Desktop

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft Power BI Courses Data Analysis Courses DAX (Data Analysis Expressions) Courses Data Modeling Courses Power BI Desktop Courses Calculated Columns Courses

Course Description

Overview

  • Module 1: In this module, you'll learn about the Power BI Desktop model structure, star schema design basics, analytics queries, and report visual configuration. This module provides a strong foundation on which you can learn to optimize model designs and add model calculations.

    • By the end of this module, you'll be able to:

    • Describe the structure of a Power BI Desktop model.
    • Explain star schema design basics.
    • Define the term analytic query and its phases.
    • Describe how fields can be used to configure a report visual, which then generates an analytic query.
  • Module 2: In this module, you'll learn how to write DAX formulas to create calculated tables, calculated columns, and measures, which are different types of model calculations. Additionally, you'll learn how to write and format DAX formulas, which consist of expressions that use functions, operators, references to model objects, constants, and variables.

    • By the end of this module, you'll be able to:

    • Describe the different DAX calculation types.
    • Write DAX formulas.
    • Describe DAX data types.
    • Work with DAX functions.
    • Use DAX operators.
    • Use DAX variables.
  • Module 3: By the end of this module, you'll be able to add calculated tables and calculated columns to your data model. You'll also be able to describe row context, which is used to evaluated calculated column formulas. Because it's possible to add columns to a table using Power Query, you'll also learn when it's best to create calculated columns instead of Power Query computed columns.

    • By the end of this module, you'll be able to:

    • Create calculated tables.
    • Create calculated columns.
    • Identify row context.
    • Determine when to use a calculated column in place of a Power Query custom column.
    • Add a date table to your model by using DAX calculations.
  • Module 4: In this module, you'll learn how to work with implicit and explicit measures. You'll start by creating simple measures, which summarize a single column or table. Then, you'll create more detailed measures based on other measures in the model. Additionally, you'll learn about the similarities of, and differences between, a calculated column and a measure.

    • By the end of this module, you'll be able to:

    • Determine when to use implicit and explicit measures.
    • Create simple measures.
    • Create compound measures.
    • Create quick measures.
    • Describe similarities of, and differences between, a calculated column and a measure.
  • Module 5: By the end of this module, you’ll learn about what the family of iterator functions can do and how to use them in your DAX calculations. Calculations will include custom summarizations, ranking, and concatenation.

    • By the end of this module, you'll be able to:

    • Describe iterator functions.
    • Use aggregation iterator functions.
    • Calculate rankings.
  • Module 6: By the end of this module, you’ll be able to describe filter context, which is used to evaluate measure formulas. You’ll then learn why some calculations need to modify filter context and that it can be achieved by using the CALCULATE function. Additionally, you’ll learn how to configure the CALCULATE function with filters and filter modifiers.

    • By the end of this module, you'll be able to:

    • Describe filter context.
    • Use the CALCULATE function to modify filter context.
    • Pass filters to the CALCULATE function.
    • Pass filter modifiers to the CALCULATE function.
    • Perform context transition.
  • Module 7: By the end of this module, you’ll learn the meaning of time intelligence and how to add time intelligence DAX calculations to your model. These calculations will include year-to-date (YTD), year-over-year (YoY) growth, and others.

    • By the end of this module, you'll be able to:

    • Define time intelligence.
    • Use common DAX time intelligence functions.
    • Create useful intelligence calculations.

Syllabus

  • Module 1: Describe Power BI Desktop models
    • Introduction
    • Star schema design
    • Analytic queries
    • Configure report visuals
    • Check your knowledge
    • Summary
  • Module 2: Write DAX formulas for Power BI Desktop models
    • Introduction
    • Write DAX formulas
    • DAX data types
    • Work with DAX functions
    • Use DAX operators
    • Use DAX variables
    • Check your knowledge
    • Summary
  • Module 3: Add calculated tables and columns to Power BI Desktop models
    • Introduction
    • Create calculated columns
    • Learn about row context
    • Choose a technique to add a column
    • Check your knowledge
    • Summary
  • Module 4: Add measures to Power BI Desktop models
    • Introduction
    • Create simple measures
    • Create compound measures
    • Create quick measures
    • Compare calculated columns with measures
    • Check your knowledge
    • Summary
  • Module 5: Use DAX iterator functions in Power BI Desktop models
    • Introduction
    • Use aggregation iterator functions
    • Calculate ranks
    • Check your knowledge
    • Summary
  • Module 6: Modify DAX filter context in Power BI Desktop models
    • Introduction
    • Modify filter context
    • Use filter modifier functions
    • Examine filter context
    • Perform context transition
    • Check your knowledge
    • Summary
  • Module 7: Use DAX time intelligence functions in Power BI Desktop models
    • Introduction
    • Use DAX time intelligence functions
    • Additional time intelligence calculations
    • Check your knowledge
    • Summary

Tags

Related Courses

Curso Completo de Machine Learning en Microsoft Power BI
Coursera Project Network via Coursera Learning Microsoft Power BI Desktop
LinkedIn Learning Learning Power BI Desktop
LinkedIn Learning Getting Started with Power BI Desktop
Coursera Project Network via Coursera Introducción a Power BI para los negocios
Universitat Politècnica de València via edX