What type of training do you provide?

Nexacu is the leading provider of Microsoft Training Courses across Australia. We offer courses held at our centrally located training rooms, online or can conduct courses at your workplace. Courses include Office 365, Power BI, Excel, PowerApps, Excel Macros / VBA, Financial Modelling, Project, SharePoint, PowerPoint and more. We consistently deliver high quality, up to the minute courses enabling our students to return to the workplace and put their new skills into practice.

What is included with a course?

In addition to the course itself, your investment includes: A take home copy of the manual used during your course. The manual is divided into chapters along with the exercises completed on the training day. This makes it easy to review the material after your training has been completed. A certificate to acknowledge you have completed the course Free email support for 12 months following the completion of your course (conditions apply). The opportunity to re-sit training for a period of up to 6 months after you complete your training (conditions apply).

Courses are conducted by experienced training professionals who combine effective communication skills with rich commercial experience. Many of our trainers have also achieved advanced accreditation from Microsoft. At the end of the training day every student is asked to review their trainer and the course to ensure a high level of student satisfaction is maintained. Our trainers are an important reason why our customers continually book with Nexacu so your honest feedback is important to us. Have a look at our student testimonials .

What's the training environment like?

At Nexacu we believe that the learning environment is critical to a successful training experience. That's why we have chosen premier, centrally located office spaces to conduct our training. This ensures that you're comfortable, remain alert and get the most out of your training experience

What do the traffic lights mean?

The traffic light of each course indicate the status of the course. Each traffic light colour represents: Green: Course has been scheduled to run but has not been confirmed. Yellow: Course confirmed to run. Trainer has been allocated. Orange: Course confirmed to run. Limited number of seats available. Purple: No more seats are available for this course.

Can I book group training with Nexacu ?

Yes you can! Nexacu instructors are very experienced in conducting group training sessions. Group training is a great way to inject flexibility and efficiency into your training program and may also attract additional savings. For information and advice about group training contact us on 1300 886 190.

How many people will be in my class?

Class sizes are capped at 10 participants with an average class of 5. For group training, the number of participants may vary but we generally recommend no more than 12 participants. Keeping class sizes small results in a more personalized and efficient learning experience and better learning outcomes.

What do I need to bring on the day?

You are not required to bring a laptop to the training however you may bring your personal laptop if you would feel more comfortable using that. You may also wish to bring a USB to the training if you want to download the files at the end of the training. Alternatively, a download link will be provided for you to download at a later stage.

Do your courses qualify for Continuing Professional Development (CPD)?

Courses provided by Nexacu satisfy CPD requirements for most professions. As part of general industry standards 120 hours of CPD must be completed per triennium with 90 hours being formal CPD. A minimum of 20 hours of CPD must be completed in each year. Each full day of an Nexacu course constitutes 6 hours CPD with 2 day courses being 12 hours of CPD.

Is Nexacu government procurement compliant?

Yes, Nexacu Solutions complies with the most stringent government procurement policies at federal, state and local government. We have worked with a number of government agencies at all levels. We hold public liability and professional indemnity insurance as well as other insurances required by law.

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.

Book Now

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

Try our skills test

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

Choose a Quiz

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?

Dedicated Researchers
Microsoft Certified Trainers
New Courses in Emerging Tech
Continuous Reinvestment in Content
15,000+ positive reviews

Excellent Course well presented by Steven. Excited to expand the horizons another step to power BI heaven -Power BI Advanced Brisbane

Terry - Power BI Advanced, 23 Jan 2020.

Great content, Steve kept things going as slower users tend to slow things down but parked questions well and kept things going. Well explained -Power BI Advanced Brisbane

Matthew - Power BI Advanced, 23 Jan 2020.

Great Course, Thanks Steven -Power BI Advanced Brisbane

Savindren - Power BI Advanced, 23 Jan 2020.

Good presentation and hand on the task. -Power BI Advanced Brisbane

Yuejing - Power BI Advanced, 23 Jan 2020.

Well presented and informative. -Power BI Advanced Brisbane

Brent - Power BI Advanced, 23 Jan 2020.

Good training. -Power BI Advanced Brisbane

Shergeoh - Power BI Advanced, 23 Jan 2020.

It was a good course, good speed and trainer explained tasked very well. Exercises were good and training material very helpful. -Excel Advanced Sydney

Stephanie - Excel Advanced, 23 Jan 2020.

Very knowledgeable trainer and was able to adapt to circumstance that could be beneficial and understood by the group -Excel Advanced Sydney

Danielle - Excel Advanced, 23 Jan 2020.

Good content, and explained in a calm and efficient manner -Excel Advanced Sydney

SonyParimi - Excel Advanced, 23 Jan 2020.

Great documentation and files for the training sessions. Rajashree is really good at keeping the class on track and is quick to identify issues when a user is having problems. -Excel Advanced Sydney

Libby - Excel Advanced, 23 Jan 2020.

Very useful and speed of session was good. Good mix of exercises. More detail on macros would be great. -Excel Advanced Sydney

Jessica - Excel Advanced, 23 Jan 2020.

Michael was fantastic he really made this course informative and enjoyable. I got a lot out of this course. -Office365 Beginner Parramatta

Renee - Office365 Beginner, 23 Jan 2020.

Instructor didn't take a linear path through the workbook, but did manage to cover all area, it was good to see pragmatic approach to student learning -Power BI Advanced Sydney

Stuart - Power BI Advanced, 23 Jan 2020.

Very well explained. -Office365 Beginner Parramatta

Felicity - Office365 Beginner, 23 Jan 2020.

Thoroughly enjoyable. John moved quickly through examples, but not too quick for people to get lost. Very happy that the group was very capable. -Excel Advanced Melbourne

Matthew - Excel Advanced, 23 Jan 2020.

Thank you John for the very informative and interesting course! I learn a lot of useful tricks on how to improve my excel skills on a day to day basis. -Excel Advanced Melbourne

Maria - Excel Advanced, 23 Jan 2020.

Great course -Office365 Beginner Parramatta

Courtney - Office365 Beginner, 23 Jan 2020.

John was really good, going through the content clearly and in a way for us novices to understand the steps involved in different processes. -Excel Advanced Melbourne

Benji - Excel Advanced, 23 Jan 2020.

Helpful and interactive, but intensive -Excel Advanced Melbourne

Oussama - Excel Advanced, 23 Jan 2020.

Nice presentation Covered interested topics -Excel Advanced Melbourne

gunjan - Excel Advanced, 23 Jan 2020.

View More Reviews

Trusted by Business

Procured by Government

Brisbane

Level 10, 333 Adelaide St, Brisbane QLD 4000
View Microsoft Courses Brisbane
Sydney

Level 3, 37 Pitt Street, Sydney NSW 2000
View Microsoft Courses Sydney
Parramatta

Level 3, 90 Phillip Street, Parramatta NSW 2150
View Microsoft Courses Parramatta
Melbourne

Level 3, 466 Little Lonsdale St, Melbourne VIC 3000
View Microsoft Courses Melbourne
Canberra

Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601
View Microsoft Courses Canberra
Adelaide

Level 3, 97 Pirie Street, Adelaide SA 5000
View Microsoft Courses Adelaide
Perth

Level 1, 140 St Georges Tce, Perth WA 6000
View Microsoft Courses Perth

Power BI Introduction to DAX

What is DAX?

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:

Software Requirements:

How do Online Courses work?

Book

Login

Learn

System Requirements

Why choose Nexacu?

Dedicated Researchers

Microsoft Certified Trainers

New Courses in Emerging Tech

Continuous Reinvestment in Content

15,000+ positive reviews

Valued by Individuals

Trusted by Business

Procured by Government

Popular Public Courses

Top Workplace Courses

Quick Links

Training Solutions