Mastering DAX for Microsoft Power BI Virtual Classroom Live March 26, 2025

Price: $1,700

This course runs for a duration of 3 Days.

The class will run daily from 8:00 AM CT to 4:00 PM CT.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

Learn the full range of DAX functions in Power BI.
DAX is the native language behind Microsoft PowerBI and other Microsoft data tools. It’s designed as a flexible, powerful syntax for working with various data types and crafting functions to manipulate and analyze data.

Even for beginners, PowerBI out of the box offers incredible analysis capability. However, for those who are comfortable with basic features and are ready to truly unlock PowerBI’s potential, DAX is the key. Learning to use DAX within PowerBI gives you the power to perform incredibly fine-grained analysis and data manipulation.

In this class, you will get hands-on experience with DAX and learn it’s full range of functions. Led by an expert, you’ll get practice applying DAX skills to real-world datasets and real-world analysis problems. You’ll leave class ready to extend your role well beyond that of most PowerBI users – applying skills to manipulate, analyze, and communicate about data precisely and powerfully.

Audience

Some professionals who would find this course particularly beneficial include:

Analysts
Database Administrators
Senior Business Intelligence Architects
Business Intelligence Consultants
Senior Business Analysts
Digital Marketers
Data Strategists
IT Specialists
IT Managers
IT Directors
Financial Specialists

Objectives

Apply a wide range of available DAX functions and when you should use them
Manipulate data based on date, time, currency, integer values, and more
Expertly analyze data using powerful statistical functions
Build and manipulate tables with a wide range of data sources
Design and analyze data using boolean logic
Tease apart sophisticated data relationships to find insights
Filter through large data sets quickly and effortlessly
Work with and manipulate text values in Power BI

Course Overview

Part 1: Introduction to DAX

What is DAX?
Why use DAX with Power BI
Calculated Columns vs Measures
Types of Functions
Logical Functions
Table manipulation functions
Date and time functions
Filter functions
Financial functions
Math and Trig functions
Parent and Child functions
Relationship functions
Statistical functions
Text functions
Time intelligence functions

Part 2: Logical functions

TRUE
FALSE
IF
IFERROR
AND
OR
SWITCH
COALESCE

Part 3: Tables

Tables Overview
Filtering Tables
- FILTERS
- TOPN
Summarizing Tables
- SUMMARIZE
- SUMMARIZECOLUMNS
- ROLLUP
- GROUPBY
Generating Tables
Distinct Values
- DISTINCT column
- DISTINCT table
Joining Tables
- CROSSJOIN
- NATURALINNERJOIN
- NATURALLEFTOUTERJOIN
Adding Values
- Columns
- Missing items
Table Constructor

Part 4: Date and Time Functions

Date and Time Functions Overviews
Units of Time
Creating a Calendar
- CALENDAR
- CALENDARAUTO
Dates
TODAY
NOW
TIME
TIMEVALUE

Part 5: Filter Functions

Filter Functions Overview
Filtering Tables
- FILTER
- REMOVEFILTERS
- ALL (ALL, ALLCROSSFILTERED, ALLEXCEPT, ALLNOBLANKROW, & ALLSELECTED)
- CALCULATETABLE
- KEEPFILTERS
CALCULATE
LOOKUPVALUE
SELECTEDVALUE

Part 6: Financial functions

Accrued Interest
- ACCRINT
- ACCRINTM
Depreciation
- DB
- DDB

Part 7: Relationships Functions

CROSSFILTERS
RELATED
RELATEDTABLE
USERELATIONSHIP
Parent and Child Functions
- PATH
- PATHCONTAINS
- PATHITEM
- PATHITEMREVERSE

Part 8: Text functions

FIND
SEARCH
REPLACE
FORMAT
LOWER
UPPER
RIGHT
LEFT
COMBINEVALUES
CONCATENATE
CONCATENATEX
EXACT
FIXED
LEN
MID
SUBSTITUTE
TRIM
VALUE

Part 9: Statistical functions

Central Tendencies
- Averages
- Means
- Geo means
Counting
- Counting and COUNTX
- Blanks, and rows
- Distinct count: distinct, approximate, no blank
Min/Max
- MAX, MAXA and MAXX
- MIN, MINA and MINX
Sample
Distributions
- Normal
- Exponential
- Beta
- Poisson
Inverse
Percentiles
Ranking
Standard Deviation
Variance
- VAR.P and VARX.P
- VAR.S and VARS.P

Prerequisites

Professionals who take this course need to be familiar with Microsoft Power BI’s basic features and already feel comfortable with navigating both the Desktop and Online version of the tool. It is recommended to take our Microsoft Power BI Boot Camp prior to this course, or have equivalent work experience.

Other Available Dates for this Course

Virtual Classroom Live
January 29, 2025

$1,700.00

3 Days 7:30 AM CT - 3:30 PM CT

Knowledge Transfer Consulting Services Inc. is a single-source solution provider offering a full range of Training Delivery and Training Management solutions from concept to delivery. Learn more