Previously Excel Consulting

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
Interactive Courseware
provided
Practise Exams
provided
Instructor Led
yes
CPD Hours
1 hour
Access
12 month
Live Q&A
yes
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.)

Why choose Nexacu?

Valued by Individuals

4.8/5
Over 16376 Reviews
The course was very informative for someone who has never used VBA before. I learned a lot during the two days. Thank you -Excel Macros/VBA 2 Day Brisbane
Bhavna - Excel Macros/VBA 2 Day, .
Good introduction -Excel Macros/VBA 2 Day Brisbane
Ian - Excel Macros/VBA 2 Day, .
Good introductory course -Excel Macros/VBA 2 Day Brisbane
Harold - Excel Macros/VBA 2 Day, .
Fantastic course and trainer was awesome, explained everything and a small group which was good. - Excel Macros/VBA 2 Day Brisbane
David - Excel Macros/VBA 2 Day, .
- -SharePoint Site Owner Brisbane
Gabrielle - SharePoint Site Owner, .
Overall i have come away with additional knowledge and skills from the course. -SharePoint Site Owner Brisbane
Leisa - SharePoint Site Owner, .
Got what I expected. -SharePoint Site Owner Brisbane
Alice - SharePoint Site Owner, .
Good course, Very helpful should come into a lot of use. Thank You -SharePoint Site Owner Brisbane
Linda - SharePoint Site Owner, .
Well structured and very well presented by Mr. Michael -SharePoint Site Owner Sydney
Umar - SharePoint Site Owner, .
A comprehensive course, but I would have spent more time explaining Permissions using more examples -SharePoint Site Owner Sydney
Anya - SharePoint Site Owner, .
Great course -SharePoint Site Owner Sydney
Karen - SharePoint Site Owner, .
Clive is very knowledgeable and is very helpful. -Excel Macros/VBA 2 Day Sydney
Katherine - Excel Macros/VBA 2 Day, .
Excellent course which has improved my understanding of Excel VBA. Greg answered all my questions and has given me some ideas to improve my macros back in the work place. -Excel Macros/VBA 2 Day Canberra
Brad - Excel Macros/VBA 2 Day, .
I enjoyed every minute of the course. This has been a excellent experience that I learnt much about VBA coding. Clive is a knowledgeable instructor! -Excel Macros/VBA 2 Day Sydney
UQ - Excel Macros/VBA 2 Day, .
Excellent review of Project basics, thanks! -Project Beginner Melbourne
Johan - Project Beginner, .
An informative an interactive session -Project Beginner Melbourne
Christina - Project Beginner, .
Good and handy feedback for building a better schedule. -Project Beginner Melbourne
Ivana - Project Beginner, .
The design and delivery of the course is systematic and effective. However, it would be more helpful, if the design and delivery of the course is aligned towards doing a programming. -Excel Macros/VBA 2 Day Canberra
sonam - Excel Macros/VBA 2 Day, .
. -Excel Macros/VBA 2 Day Sydney
peggy - Excel Macros/VBA 2 Day, .
Great tips that I didn't even know about! -Excel Advanced Melbourne
Sabrina - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia