October Sale - 20% of all courses - Book Today

power bi courses nexacu

Power BI Introduction to DAX - Webinar

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”. Measures 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. All of our webinars are in English.

Course Details
Price
$49
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
  • High level of English required

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
Instructor Led 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 Self-Paced 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.)

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23527 Reviews
Very well explained and very patient. Instructor always checked in to see how the group was going. -Word Intermediate Brisbane
Alisha - Word Intermediate, .
Steven was very clear and concise. Easy to follow. Disappointed that I flunked the capability test, as I should have probably been doing the advanced course. But still gained some useful tips and reminders. -Word Intermediate Brisbane
Sarah - Word Intermediate, .
great course steven really helped -Word Intermediate Brisbane
Justin - Word Intermediate, .
Great information, delivered well and interactive. -Word Intermediate Brisbane
Trish - Word Intermediate, .
Great course, very informative. I enjoyed learning more about page breaks/section breaks. -Word Intermediate Brisbane
Candice - Word Intermediate, .
Was really great. Thanks Jason! -Office365 Intermediate Brisbane
Andrea - Office365 Intermediate, .
Thanks a lot. -Office365 Intermediate Brisbane
Magdalena - Office365 Intermediate, .
It was very into detail for the things I feel like needed less time spent. -Office365 Intermediate Brisbane
Chloe - Office365 Intermediate, .
In-depth training. Jason is a great trainer that keeps it interesting. -Office365 Intermediate Brisbane
Dominique - Office365 Intermediate, .
Very Helpful. -Office365 Intermediate Brisbane
Samantha - Office365 Intermediate, .
l -Office365 Intermediate Brisbane
Ivy - Office365 Intermediate, .
Even though I use Excel on a daily basis I still learnt some things in the beginners course. Knowledgeable trainer -Excel Beginner Adelaide
Judith - Excel Beginner, .
that was a great refresher with a few new tips thrown in. Thanks Jagg for a great class. -Excel Beginner Adelaide
Gabrielle - Excel Beginner, .
Fantastic Trainer - everything was very into detail and straight forward. enjoyed it. Thanks again -Excel Beginner Adelaide
Mike - Excel Beginner, .
Perfect trainer very helpful -Excel Beginner Adelaide
Koula - Excel Beginner, .
Well presented and informative -Excel Beginner Adelaide
Ken - Excel Beginner, .
Very helpfull and informative! -Excel Beginner Adelaide
Bronwyn - Excel Beginner, .
Excellent and very thorough -Project Intermediate Sydney
ian - Project Intermediate, .
easy to follow steps that have provided short cuts and better understanding of program. presenter was easy to follow and kept language simple, minimal technical terms -Excel Beginner Perth
Craig - Excel Beginner, .
Great thank you - -Excel Beginner Perth
Susan - Excel Beginner, .

Trusted by Business

south east asia microsoft training courses nexacu

Follow us