All courses REMOTE until June 30 | Limited in-class sessions in June - Call Us | From July 1 all courses available in-class and remotely

power bi courses nexacu

Power BI Introduction to DAX

What is DAX?

DAX is the formula or expression language used in Power BI. Looking much like Excel formulas, DAX can be used to create tables, add columns to existing tables and to define “measures”. Meaures are calculations used in reporting of data and metrics. To take modelling in Power BI up a notch, you will need to understand DAX.

We will begin by revisiting the basic concepts of Excel formulas and then focus on where DAX is used in Power BI. We will introduce Quick Measures, the easiest way to perform calculations without writing any code. Then we will demonstrate some basic DAX functions before wrapping up with some suggested next steps based on your learning needs.

Course Details
Price
$99
Duration
60 minutes
Instructor Led
yes
CPD Hours
1 hour
Access
12 month
Skill Level
Intermediate
Course Prerequisites

There are basic skills and software requirements for this workshop. To get the most out of this webinar, make sure you have the software ready to go.

Skill Requirements:

  • Able to use common Excel forumulas (such as IF, SUM, VLOOKUP)
  • Able to create Power BI reports, dashboards and visuals
  • Familiarity with Power BI Desktop and basic data models
  • Understand Get Data and how to create relationships between tables

Software Requirements:

  • Microsoft Excel and Power BI Desktop

Learning Outcomes

  • What and Where is DAX
  • What is the DAX language
  • Where is DAX used

 

  • Formulas in Excel
  • Structure of Excel Formulas
  • How Excel formulas translate to DAX

 

  • Power BI Data Modelling
  • Getting started with Data Modelling
  • Tables and Relationships

 

  • Aggregations in Power BI visuals
  • Using DAX to Aggregate

 

  • Quick Measures in Power BI
  • What are Quick Meaures
  • Creating a Quick Measure

 

  • Basic DAX functions in Power BI
  • What is a DAX Function
  • Creating a basic DAX function

 

  • Creating tables, measures and columns
  • Create a Table
  • Create a calculated column
  • Create a measure

 

  • Learning stages of DAX and useful resources
  • What to expect on the DAX journey
  • Where to from here
Face to Face Courses
microsoft_gold
Try our skills test

Test your skills and find out which course is right for you.

Choose a Quiz

 

Contact Us

How do Online Courses work?



Book

Find the online course or webinar you

would like to sit and hit book now.



Login

Receive your login details and follow the instructions

to log on to the Nexacu learning portal.




Learn

Complete your online course or view

your webinar at your own pace.

System Requirements

Browser

  • Internet Explorer: Version 9 to 11
  • Firefox or Google Chrome: Latest Version

Software requirements

  • Microsoft Windows 7/8/10
  • Apple Mac OS X 10.5.x, 10.6.x *(Online self-paced courses courseware works with Mac OS, diagnostic tests do not.)

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 20822 Reviews
Great Explanations, Very Helpful, Highly recommend. -Excel Intermediate Perth
Luke - Excel Intermediate, .
Jagg was really great, good amount of detail and a good pace, made it easy to keep up and really learn everything. Thank you -Excel Intermediate Sydney
Madelene - Excel Intermediate, .
Great communication skills -Excel Intermediate Perth
Anthony - Excel Intermediate, .
. -Office365 Intermediate Sydney
James - Office365 Intermediate, .
Helpful and well explained -Office365 Intermediate Sydney
Monika - Office365 Intermediate, .
John was really good at power BI and some of the concepts were great. I will keep all these details close by and even reach out to John if I have further questions. Thanks for the day! -Power BI Advanced Canberra
Matthew - Power BI Advanced, .
Thanks -Power BI Advanced Canberra
Gabriela - Power BI Advanced, .
The training was really great. Jag kept us engaged for the whole day which is great. I learnt a lot and can't wait o put the tips and tricks in action. Thanks -Excel Intermediate Sydney
Rosalind - Excel Intermediate, .
Jag is so very good! Was very engaging and actually very fun! -Excel Intermediate Sydney
Michelle - Excel Intermediate, .
Good overall -Power BI Advanced Canberra
YuinAi - Power BI Advanced, .
Michael was great - he had a good pace and checked in with us to see if we had any questions. He is clearly very passionate about Power BI which enhanced the whole experience -Power BI Beginner Sydney
Ally - Power BI Beginner, .
It was very informative and Michael was very helpful and detailed. -Power BI Beginner Sydney
Alan - Power BI Beginner, .
Very good introduction to PowerBI. Concepts very well explained. -Power BI Beginner Sydney
Eric - Power BI Beginner, .
Thanks Ken, very informative. -PowerPoint Level 2 Sydney
David - PowerPoint Level 2, .
Thank you was a great session. -PowerPoint Level 2 Sydney
Nikita - PowerPoint Level 2, .
Really useful tips and shortcuts -PowerPoint Level 2 Sydney
Devlin - PowerPoint Level 2, .
Thanks- great course! -PowerPoint Level 2 Sydney
Gabrielle - PowerPoint Level 2, .
Helpful. Thank you very much. -PowerPoint Level 2 Sydney
Guida - PowerPoint Level 2, .
Wonderful course. Enjoyed it very much and learnt many new features -Power BI Beginner Sydney
Victor - Power BI Beginner, .
. -Power BI Beginner Sydney
Steve - Power BI Beginner, .

Trusted by Business

Procured by Government

Map of Australia