Habanero Data Solutions

Advanced Dax for Power BI

Approved by Habanero Data
next available COURSE:
Duration :
2 Day/s
DURATION
2 Day/s
USD $
450
USD
$ 450
NGN ₦
200,000
NGN
₦ 200,000

Course Information

Everything you need to know

  • Course Syllabus
  • Your trainer
  • Key Information

Day 1
 
Introduction to DAX

  • 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

 

Day 2
 
Evaluation Context and Relationships

  • 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

Our international certified trainers have highly experienced Microsoft Power BI practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed Microsoft PowerBI.

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

For more information on our training, please enquire using the form above or call +2348103382376

Advanced Dax for Power BI

Contact Our Team Today!








    What's Included

    Find out what’s included in the training programme.
    COURSE MANUALS
    REFRESHMENTS
    INSTRUCTOR

    Delivery Options

    Everything you need to know

    CLASS ROOM TRAINING
    ONLINE TRAINING
    ONSITE TRAINING

    Course Schedule

    Find out the next available dates

    Advanced Dax for Power BI

    Available Dates

    Available Places

    Book or Enquire

    April 12, 2021

    Abuja, Accra, Addis Ababa, Freetown, Kigali, Lagos, Nairobi

    We are happy to help

    Call our team today on +234 8103382376 or email training@habanerodata.net

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.