Microsoft Power BI

    Power BI Topic 6: Power BI Data Analysis Expressions

    Course Duration: 90 Minutes

    Target Audience:

    Aimed at experienced Microsoft Power BI users who wish to use more advanced features and functions to create reports and dashboards.

    Course Objectives:

    Power BI is a Microsoft product that allows for the creation of powerful, interactive visualizations using business intelligence. This session will enable course participants to create more complex Data Analysis Expressions (DAX) in Power BI.

    Course Outline:

    Course Introduction

    What is a Data Analysis Expression (DAX)?

    How Power BI DAX Works

    • Syntax
    • Context
    • Functions

    Calculated Columns and Measures

    • Calculated Columns
    • Calculated Measures
    • Calculated Columns vs. Calculated Measures

    Types of Functions in Power BI DAX

    • Aggregate Functions
    • Count Functions
    • Date and Time Functions
    • Mathematical Functions
    • Logical Functions
    • Information Functions
    • Text Functions

    Creating Measures Using Power BI DAX

    Discussion and Question Time

    View Schedule
    Contact Us