Next course begins May 6th

Advanced Dax for Power BI

Our Advanced DAX for Power BI course is designed for participants who are experienced in writing DAX but are looking to increase knowledge and skills in DAX (Data Analysis Expressions). The course will focus on the advanced and complex DAX concepts. The course will help you understand the more complicated and advanced principles of DAX.

What you'll learn

The course will provide participants with the key concepts of databases and structured query language (SQL). Participants will learn how to read and write simple and complex SQL statements.

Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course, delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of DAX.

Course Content

DAX basics

  • What is DAX
  • Dax data types
  • Calculated Columns
  • Measures

 

Introduction to DAX

  • DAX basics
  • What is DAX
  • Dax data types
  • Calculated Columns
  • Measures
  • Naming convention
  • Measures Vs Calculated Columns
  • Aggregate Functions
  • Counting Values
  • Logical functions
  • The SWITCH Function
  • Information Function
  • MAX and MIN Function
  • Divide Function
  • Using Variables

 

Deep dive into CALCULATE

  • Introduction to Calculate
  • Understand the use of CALCULATE
  • Calculate Examples
  • Filters and Tables
  • OR conditions in CALCULATE
  • Clear filter on one column only
  • CALCULATE Tasks

 

Table Functions

  • Introduction to table functions
  • FILTER Function
  • ALL function
  • ALLEXCEPT function
  • Mixing filters
  • DISTINCT function
  • VALUES AND ALLNOBLANKROW functions
  • ISEMPTY function
  • RELATED TABLE function
  • Tables and Relationships

 

Time intelligence functions

  • MTD, QTD, YTD, SamePeriodLastYear
  • YTD, MTD with CALCULATE
  • Rolling totals for different periods
  • IF, HasOneValue
  • Using a Safe Divide Function
  • Using the Blank() Function
  • Build an Example Time Intelligence Report
  • Creating Dynamic titles
  • Using parameter table

Introduction to evaluation contexts and relationships

  • Row Context and Relationships
  • Filter Context and Relationships
  • CALCULATE Examples
  • Filtering many columns
  • FILTER AND CROSSFILTER Functions
  • HASONEVALUE Function
  • ALLSELECTED Function

 

Building a Date Table

  • Introduction
  • CALENDAR Function
  • CALENDAR AUTO Function
  • Mark as Date table
  • Set sorting options
  • Multiple Dates

 

Working with iterators

  • Introduction to iterators
  • Useful iterators
  • MIN-MAX Sales per customer
  • RANKX Function and examples

 

Dax Studio

  • Capturing and debugging queries with Dax Studio
  • Power BI referencing

 

Conclusion

  • Summary

Upcoming Dates

LocationDatePrice
LagosMay 6th, 2024₦200,000
AbujaMay 27th, 2024₦200,000
LagosJune 3rd, 2024₦200,000
LagosJune 17th, 2024₦200,000
LagosJuly 1st, 2024₦200,000

Delivery Methods

Classroom Training

Unlock your potential with our classroom training courses. Our portfolio of business intelligence training courses are delivered by BI experts across Africa.

Online Training

Our online trainings (live instructor-led) are delivered by certified instructors and are designed to replicate a classroom experience which enables full interactions.

Onsite Training

Our onsite training team allows us to bring our skills and expertise to you. Onsite courses are developed in conjunction with you, ensuring your expectations are exceeded.

1-to-1 Training

With our one-to-one training you’ll not only receive the undivided attention of the trainer, but one-to-one training allows you to tailor the training to your specific needs.

From ₦200,000
₵3000

Certification

Refreshments

Training multiple people?

Empower your teams with business intelligence training courses delivered by subject matter experts.

Apply for Advanced Dax for Power BI

Which date are you interested in?

Apply for Advanced Dax for Power BI

Which date are you interested in?