Platform Access

Ultimate Beginner's Guide to DAX

Learn all about DAX calculations in Power BI. Learn introductory theory as well as how to put it into practice when developing Power BI models.

Enroll in course for FREE
Ultimate Beginner's Guide to DAX, power bi dax online training

Here's What You'll Get

With The Course

2 hours of course videos

Demo data set to practice with

Power BI file (pbix file) resource

15 questions quiz to test your knowledge


 Ultimate Beginner's Guide to DAX

Start creating incredible analysis in Power BI

  • Get an introductory understanding of DAX, the true analytical power behind Power BI
  • Understand and learn very well the theory behind DAX before you move on to more advanced formula and using complex analytical techniques.

Details Of What You Will Learn

During This Course

  • Learn - what DAX is and why you need to learn it when using Power BI

  • Learn - the basics of DAX calculations

  • Understand - formula syntax, writing comments & variables

  • Review - how the data model and DAX calculations work together

  • Learn - what the most important concept of DAX is - CONTEXT

  • Understand - what the CALCULATE statement does

  • Learn - what table functions are and when to use them

  • Review - time intelligence functions

  • Understand - how important learning DAX well is when using Power BI

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

This course is designed for those who have little to no knowledge of Power BI but are working in data-driven environment.

LEARN HOW TO

Utilize the key features within the Power BI suite

 Ultimate Beginner's Guide to DAX
  • Use DAX formula with Power BI
  • When and where to use DAX functions
  • Utilise some of the great features built into the DAX formula bar
  • Use the data model in combination with DAX formula
  • Understand the concept of CONTEXT
  • Use the CALCULATE statement
  • Create filters using table functions
  • Incorporate time intelligence functions in your analysis
  • Become a DAX master by combining patterns of DAX formula

Course Curriculum

1. Introduction

  • How to get Certified for this course?
  • Data & resource downloads
  • Course Intro
  • What is DAX and why do you need to learn it?
  • A review of the data scenario
  • Setting up your Power BI model

2. Understanding the basics of DAX

  • Measures vs Calculated Columns
  • Simple aggregations
  • Creating a date table
  • Formula syntax, comments, variables
  • Main difference between DAX & Excel formulas

3. Reviewing the data model

  • How the data model and DAX work together

4. Understanding context

  • Evaluation context
  • Filter context
  • Row context
  • Context considerations

5. CALCULATE, filters & table functions

  • CALCULATE is the key to anything advanced
  • Simple filters
  • What are table functions?

6. Time Intelligence

  • PreviewTypes of Time Intelligence functions

7. Becoming a DAX super user

  • How to combine patterns of DAX formula
  • Using quick measures
  • Examples of advanced DAX

What our Students Say

Your Instructor

Sam McKay

Sam very early on saw the immense opportunity of using Power BI to create analytical solutions. After years of developing some advanced analysis and tools in excel, he was amazed that he could re-create most of those things in about 10% of the time with Power BI.

He is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organisations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.

Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charter holder, achieving the designation in 2011.

He has a passion for building highly scalable analytical solutions within organisations, and wants to see others learn how to do the same.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or CoE access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resources

For Individuals

Enterprise DNA

On-Demand

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace