Introduction to DAX for Power BI IDPB001
- Course Code : IDPB001
- Duration : 2 Day
- Price : 1,614 GBP
- Level: ntermediate
- Language: English
Course Content
This course elevates your skills in Data Analysis Expressions (DAX) from intermediate to advanced levels. It begins with an introduction to DAX, covering its syntax and how to write structured DAX in the editor and DAX Studio. The course explores many DAX functions used in Power BI projects, including iterator and standard statistical functions, calculated columns, tables, and measures, as well as Quick Measures.
You’ll learn about DAX Context, the CALCULATE function, the use of a Data Model, and incorporating a Date Dimension. The course also covers Time Intelligence functions and utilizing DAX with Row Level Security.
Delivery Method
Online
In-Person
Have questions about this course?
Benefits
Structure DAX with Power BI and DAX Studio.
Extract business intelligence using DAX.
Add value with measures, calculated columns, and tables.
Utilize various DAX functions.
Appreciate DAX context and its applications.
Understand and extend Data Models.
Create Star and/or Snowflake schemas.
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.
Pre Requisites
Introduction to Power BI Training
Power BI: Hands-On Reports and Dashboards Training
Power BI: Advanced Data Modeling and Shaping (One-Day Course)
Equivalent working experience
Course Outline
Chapter 1 - Chapter 5
Chapter 1: Introduction to DAX
Introduction to DAX
DAX Functions
Calculated Columns and Tables
Quick Measures and Measures
DAX Context
Writing DAX in Power BI
Hands-On Exercise 1.1: Introduction to DAX
Chapter 2: Working with a Data Model
Role and components of a Data Model
Star and Snowflake schemas
Fact and Dimension tables
Building a Data Model from multiple sources
Creating a Date Dimension
Hands-On Exercise 2.1: Working with a Data Model
Chapter 3: Using DAX in Power BI
Writing and formatting DAX
Summarizing and aggregating functions
Working with joins and filtering
Useful DAX functions
Hands-On Exercise 3.1: Working with DAX Functions – Part 1
CALCULATE function
Time Intelligence functions
Hands-On Exercise 3.2: Working with DAX Functions – Part 2
Chapter 4: DAX and Row Level Security
Row Level Security (RLS)
DAX functions for RLS
Defining roles and creating rules for RLS
Managing security and members
Hands-On Exercise 4.1: Implementing Row Level Security
Chapter 5: Comparing DAX and M
Overview of M in Power Query
When to use M or DAX
