Power BI DAX Essentials Training Course

This 2-Day course is designed to lay solid foundations before diving deep into complex DAX functions. This is achieved by focusing on 2 key elements i.e. engagement, and practicality. After this course, participants should be able to write DAX expressions to address their specific business needs, leverage available resources to tackle complex problems and debug and optimize using available tools and the right techniques.

Course Outline
Upcoming Dates & Booking
Contact Us

What is Included With The DAX Essentials Training Course

Small Class Size

Developed and Guided Learning Content

Certificate of Attendance

Highly Skilled Trainers

Our Price Beat Guarantee

Email Support

About this course:

Without using DAX, you can only use 50% of Power BI’s capability. Although Dax is simple, with only a few fundamental concepts, it is not easy as these concepts require deep learning. That is why a lot of Power BI users think they know DAX until they realize their functions are not returning correct results.

This 2-Day course is designed to lay solid foundations before diving deep into complex DAX functions. This is achieved by focusing on 2 key elements i.e. engagement, and practicality.

Participants will be spending 90% of their time writing hands-on DAX functions, looking at the result, discussing what works, and especially what does not work and WHY? Additionally, all the modules and concepts are reinforced by real-life, scenario-based examples to solidify the learnings.

After this course, participants should be able to write DAX expressions to address their specific business needs, leverage available resources to tackle complex problems and debug and optimize using available tools and the right techniques.

Moreover, the entire course walks through a single data set so participants can concentrate on mastering the concepts rather than worrying about the specifics of the dataset.

Prerequisites:

This DAX course is suitable for people who have either completed the Power BI Essentials course or have a reasonable understanding of data modeling concepts. To benefit most from this course, participants must have some expertise in using Excel functions or T-SQL.

Who should take this course?

This course is for business users (Finance, Marketing, Operations, etc.) or SQL Server report creators who want to take their reports and dashboards to the next level by writing custom calculations using DAX functions to address specific business requirements.

Course Duration: 2 Day

Skill Level:  Advanced

Add-ons:

  • Small Class size
  • Developed and Guided learning content
  • Completion certificate
  • Taught by Industry Pros
  • Free re-sit
  • Email support
Training Cities:
  • Sydney, Melbourne, Brisbane, Canberra, Adelaide, Perth
Training Modes  
  • Online
  • Classroom
Ticket Price:  
  • $990 incl GST
Timings:
  • 9.00 am to 5.00 pm approx
DOWNLOAD COURSE OUTLINE

Send download link to:

Upcoming Dates for Power BI DAX Essentials Course in Australia

Sydney Class Dates

Sydney Class Dates

Days

 Training Mode

07-08 Dec 23

Thu-Fri

Online Live

14-15 Dec 23

Thu-Fri

Classroom

20-21 Dec 23

Wed-Thu

Online Live

24-25 Jan 24

Wed-Thu

Online Live

29-30 Jan 24

Mon-Tue

Classroom

Melbourne Class Dates

Melbourne Class Dates

Days

 Training Mode

07-08 Dec 23

Thu-Fri

Online Live

18-19 Dec 23

Mon-Tue

Classroom

20-21 Dec 23

Wed-Thu

Online Live

18-19 Jan 24

Thu-Fri

Classroom

24-25 Jan 24

Wed-Thu

Online Live

Brisbane Class Dates

Brisbane Class Dates

Days

 Training Mode

07-08 Dec 23

Thu-Fri

Online Live

20-21 Dec 23

Wed-Thu

Online Live

18-19 Jan 24

Thu-Fri

Classroom

24-25 Jan 24

Wed-Thu

Online Live

05-06 Feb 24

Mon-Tue

Online Live

Canberra Class Dates

Canberra Class Dates

Days

 Training Mode

07-08 Dec 23

Thu-Fri

Online Live

20-21 Dec 23

Wed-Thu

Online Live

24-25 Jan 24

Wed-Thu

Online Live

05-06 Feb 24

Mon-Tue

Online Live

22-23 Feb 24

Thu-Fri

Online Live

Adelaide Class Dates

Adelaide Class Dates

Days

 Training Mode

07-08 Dec 23

Thu-Fri

Online Live

20-21 Dec 23

Wed-Thu

Online Live

24-25 Jan 24

Wed-Thu

Online Live

05-06 Feb 24

Mon-Tue

Online Live

22-23 Feb 24

Thu-Fri

Online Live

Perth Class Dates

Perth Class Dates

Days

 Training Mode

07-08 Dec 23

Thu-Fri

Online Live

20-21 Dec 23

Wed-Thu

Online Live

24-25 Jan 24

Wed-Thu

Online Live

05-06 Feb 24

Mon-Tue

Online Live

22-23 Feb 24

Thu-Fri

Online Live

Course Outline
Upcoming Dates & Booking
Contact Us
power bi training courses

Learning Experience

Unleash your data-driven superpowers through our comprehensive training program. Master the art of crafting powerful DAX expressions that precisely address your specific business needs. Dive deep into the realm of data manipulation, leveraging available resources to fearlessly tackle complex problems. Unlock the secrets of debugging and optimization, equipping yourself with the right tools and techniques to maximize efficiency and performance. Join us now and embark on a transformative journey to become a data genius, ready to conquer the challenges of tomorrow and drive meaningful insights.

Course Outline

✅ What is DAX

✅ What are the Data types in DAX

✅ DAX type handling/operator overloading

✅ DAX as Formula Language

✅ Vertipaq engine in DAX

✅ Difference between DAX, EXCEL functions, and M

✅ Dos, Don’ts, and Best Practices in DAX

✅ Fact vs Dimensions

✅ Schemas in Data Model

✅ Filter Propagation

✅ Data Denormalization

✅ Relationship Characteristics

✅ Calculated Column and its use case

✅ When do Calculated Columns fail

✅ Calculated Measure and its use case

✅ When to use Calculated Column vs. Calculated Measure

✅ Two broad categories of functions in DAX

✅ Use of SUM(), DIVIDE() and COUNT()

✅ Use of DISTINCT COUNT ()

✅ Finding Min, Max, and Average

✅ Counting Rows

✅ Counting Blank Values

✅ What are the two evaluation contexts in DAX?

✅ What is the initial or incoming filter context

✅ What is Row Context

✅ Filter Context vs Row Context

✅ Rules of Evaluation

✅ Creating a Calculated Table

✅ Exploring Table Joins

✅ The Inner Join

✅ The Outer Join

✅ A Join on Unrelated tables – TREATAS()

✅ GENERATE() for Joins

✅ Creating a summary table for the requested totals using SUMMARIZE()

✅ Creating a summary table over a set of groups using SUMMARIZECOLOUMNS()

✅ Improve TREATAS() using SUMMARIZE()

✅ Getting the top N rows of the specified table using TOPN()

✅ Using VALUES()

✅ Using FILTER() as a Table function

✅ Virtual table lineage

✅ Creating & Optimizing Calendar Table using DAX

✅ Adding Date Columns

✅ Working with Fiscal Years

✅ Set sorting options

✅ Iterators vs. Normal Functions

✅ Using SUMX()

✅ Using COUNTX()

✅ Using AVERAGEX()

✅ Using MINX()

✅ Using MAXX()

✅ Creating Variables

✅ Features of a Variable

✅ Location of Variable Evaluation

✅ Conditional Computations using Variables

✅ Increasing Code Readability

✅ Writing single and multi-line comments

✅  Modification of Filter context using CALCULATE()

✅ Modification of multiple Filter using CALCULATE()

✅ Mixing Filtering

✅ Using LOOKUPVALUE()

✅ Specifying the cross-filtering direction using CROSSFILTER()

✅ Activating Relationships with USERELATIONSHIP()

✅ Return all the rows in a table using All()

✅ Using ALLSELECTED()

✅ Modify how filters are applied using KEEPFILTERS()

✅ Using SELECTEDVALUE()

✅ Using CONCATENATEX()

✅ Implicit Calculate in Measures

✅ Row to Filter Context transition

✅ Using CALCULATE() and CALCULATETABLE()

✅ Using EARLIER() vs EARLIEST()

✅ What is Time Intelligence

✅ Date table properties for Time Intelligence

✅ Aggregations over time

✅ Total Year till Date, Month Till Date, and Quarter till Date

✅ Handling Fiscal Year

✅ Same Period Last Year

✅ Calculate the Running Total

✅ Using date modifier DATESBETWEEN

✅ Shifting forward/backward in time using DATEADD()

✅ Using DATESINPERIOD()

✅ Using MAX or LASTDATE()

✅ Using FIRSTNONBLANK() and LASTNONBLANK()

✅ Total Sales rolling 90 days

✅ Use of IF( ) statements

✅ Switching between cases using SWITCH( )

✅ Finding your text

✅ What to do if your text had one value

✅ Concatenating labels

✅ Using COALESCE( )

✅ What are hierarchies

✅ Parent-child hierarchies

✅ Using Path functions

✅ Using RANKX() ✅ Dynamically controlling units ✅ Using COUNTA(), MINA(), MINAX()

✅ Common errors and causes

✅ Error debugging

✅ What is DAX Formatter

✅ Getting started with DAX Studio

✅ Downloading and Installing DAX Studio

✅ Connecting DAX Studio with Power BI

✅ Calculation performance using Data Studio

✅ Power BI Helper

✅ Clear the Cache

✅ Other DAX references

Related Courses

Power BI Essentials Training Course
Power BI Report Design Training Course
Power BI Advanced Training Course
Power Apps Essentials Training Course

We are running multiple classes every month across Australia. Please complete the below form and one of our representatives will contact you shortly.

We deliver all our online and classroom courses via our training partner, Dynamic Web Training.

Course Outline
Upcoming Dates & Booking
Contact Us
Please fill the details below and one of our representative from will get back to you.
We deliver all our online and classroom courses via our training partner, Dynamic Web Training

For more information on upcoming

Power BI DAX Essentials Course

Click Here

You will be redirected to our official training partner Dynamic Web Training

For Group Discounts

Call Us: 1300 194 753

Why Power BI?

Business Intelligence Market

Worldwide Business Intelligence and Analytics market to grow to $22.8 billion in revenue in the next two years – Gartner

Jobs Opportunities

70 percent of the leading companies say that Analytics is integral to how they make decisions – IBM Survey

Career Growth

A Senior Business Intelligence Analyst can earn $89,000 in the United States – PayScale

Call Us: 1300 194 753

Some of the companies that experienced Power BI Training With Our Trainers

Covers the basics and key dax formulas with practical examples. | Sanja
I have a greater understanding of DAX formulas and how or when to implement these into certain measures in PowerBI reports to achieve the desired result. | Leonie
Appreciate the email support and resit option. Adam is an excellent communicator, especially in the zoom format. | Cynthia
4.6/5
5/5
5/5