Introduction to DAX for Power BI

Code: 1365 Category: Tag:

This Introduction to DAX for Power BI presents Data Analysis Expressions (DAX) in Power BI from an intermediate to an advanced level. The journey starts with an introductory discussion about DAX, the syntax of DAX statements, and how to write structured DAX in the DAX editor. You also get an introduction to DAX Studio, a third-party tool that can be used to write DAX. You can decide if you want to use DAX Studio for the course exercises.

We will discuss many of the functions in DAX and how they could be used in a Power BI Project including explaining the use of iterator functions vs standard statistical functions. There are discussions explaining Calculated Columns, Tables, and Measures discussing the differences. There is also an explanation about Quick Measures and how we can utilize those. We will explain DAX Context and where those contexts apply. There are separate discussions for the CALCULATE function, the usage of a Data Model and incorporating a Date Dimension, and also using Time Intelligence Functions. We will conclude with a discussion around utilizing DAX with Row Level Security.

Introduction to DAX for Power BI Delivery Methods

In-Person

Online

Introduction to DAX for Power BI Course Benefits

Structure DAX with Power BI and DAX Studio

Extract business intelligence by using DAX

Add value with measures, calculated columns and calculated tables using DAX

Utilize the different types of Dax functions

Appreciate DAX context and where it applies

Understand the use of a Data Model and how to extend it

Create a Star and/or Snowflake schema as your data model

Add a Date dimension to your model

Implement Row Level security with DAX

Develop a Star Schema from a Flat File Schema

Decide when to use M in Power Query or DAX in Power BI

Leverage continued support with after-course one-on-one instructor coaching and computing sandbox

Introduction to DAX for Power BI Course Outline
Introduction to DAX for Power BI Course Information

Prerequisites

Introduction to Microsoft Power BI Training
Power BI: Hands-On Reports and Dashboards Training
Power BI: Advanced Data Modeling and Shaping (One-Day Course)
or equivalent working experience

Audience Profile

This course has been designed specifically for experienced model developers. We recommend that attendees have prior experience working with Power BI Desktop to create data models.

Exam Information

4thdacad Exam provided at the end of class

Introduction to DAX for Power BI Course Outline
Chapter 2: Working with a Data Model
Chapter 3: Using DAX in Power BI
Chapter 4: DAX and Row Level Security
Chapter 5: Comparing DAX and M

Request Quotes

Register now
CAPTCHA image

Please type the characters This helps us prevent spam, thank you.

WebSphere Application Server V9 Administration (WA590G)

Public Speaking Training: Create Compelling Speeches & Presentations

HA100 – SAP HANA Introduction Training

Configuring Windows Server Hybrid Advanced Services (AZ-801)

Introduction to Microsoft Excel Training

IT Management Skills Training

SAP Business Suite to SAP S/4HANA Delta (S4H01) Training

Building Data Lakes on AWS

Introduction to Programming with ABAP (BC100) Training

PMI-Agile Certified Practitioner (PMI-ACP)® Training

arالعربية