Instructor Led Online Program in DAX Formula Language - Power Bi

DAX Formula Language in Power Bi ( 20 Hours – 5 Sessions of 4 Hours Each)
Online Instructor Led Program Starting on 2nd August ( SUNDAY ) 9:00am to 13:00 ( IST 530 GMT)

Power Bi DAX Program

Why Learn DAX in Power BI ( & Excel )

Companies are generating more and more data every day. Skills in data analysis, Business Intelligence / Business Analytics are highly in demand in today’s job market. In this course, you will learn how to use DAX to Analyze, find Patterns and Trend in your Data using Power BI.

In this course together, we will go over business scenarios where you will learn, how to use advanced / complex DAX calculations further to derive more insights from data.

What will you Learn in the DAX Workshop ?

In the first session of the program, we discuss about Data Modelling, regarding Relationship’s between Tables, and how information flows in different directions.

In the next session, we start with DAX

We start right from the Basics of DAX, understanding FILTER CONTEXT, CURRENT ROW CONTEXT, CONTEXT Transition, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.

How to Evaluate a DAX statement’s under different scenario’s, depending on your Data Model.

In the last phase of this course, you will learn about Time Intelligence and Date Tables. We will look at expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and we will explore how many of these functions work using CALCULATE

After we complete learning DAX, we venture into Case Studies & Business Scenario’s, how DAX can be implemented in real business scenario’s

Is DAX Available in EXCEL ?… YES!!

Which means, this course would give you a “DOUBLE Benefit”. You would upgrade your existing knowledge in EXCEL + Learn to write DAX formula’s

If DAX in EXCEL sounds interesting, checkout our BLOG, in which we explain about how to write DAX in EXCEL

Part 1 

Data Modelling

You need to define relationships between your Tables, under Excel, this is done under Power Pivot & Under Power Bi ( Model View ) DAX, flows through your relationships, unless you haven’t defined them properly

Part 2

Dax Start learning the Core Concepts of Dax.

The Evaluation Context, Row Context, Filter Context, Context Transition, and additional Filter context being using while creating a Calculated Column or Measure

Part 3

Case Studies Working on Business Scenario’s / Practical Problem’s using DAX to solve them

Part 4

Post Program Every Participant would be given a 2 Hour 1:1 Session to discuss DAX on their DATA, Free Consultation

Session 1 

  • Data Modelling, Creating Relationships between data, and looking at Business
    Problem’s.
  • Working with 1:1, 1:M, M:M tables
  • Understanding the Relationship Flow

Session 2 & 3

  • Data Modelling, Creating Relationships between data, & looking
    at Business Problem’s
  • Introduction to DAX
  • Learning Data Analyze Expressions (DAX)
  • Functional Language Calculated
  • Columns and Calculated Fields DAX
  • Error Handling Overview of DAX
  • Functions RELATED
  • RELATEDTABLE functions FILTER
  • ALL functions CALCULATE function
  • Visual Totals and ALLSELECTED

Session 4

  • What is Time Intelligence in DAX ?
  • Calendar Table Counting Working
  • Days Multiple Calendar Tables DAX
  • Filter Functions : CALCULATED
  • Performing arithmetic & aggregation
  • Operations on large data Writing
  • Statistical and logical DAX patterns
  • DAX creative formulas : SUMX() and
  • Other X Functions

Session 5 – Case Studies

  • Business Scenario 1 – Contribution Analysis – How to find % of Totals.
  • Business Scenario 2 – Actual v/s Budget Analysis – How to do allocations
    using DAX and work with 2 different granularity tables. Comparing Difference
    between years / products / subcategories
  • Business Scenario 3– Calculate Top Performing Sales – Perform a range of
    analysis to find best selling Products during a specific period of time, for a
    specific period of time
  • Business Scenario 4 – Calculate Bottom Performing Sales – Perform a range of
    analysis to find least selling Products during a specific period of time, for a
    specific period of time
  • Business Scenario 5 – Working with Time Intelligence Functions such as YTD /
    MTD / QTD / Running Total’s.

We had conducted a LIVE Introductory Session on 10th June, the recording of the Session is Below

Book Your Seat for the DAX FREE DEMO Session