DAX in a Day

Oct 10th

This course has been designed specifically for experienced model developers.

Overview

This course has been designed specifically for experienced model developers. We recommend that attendees have prior experience working with Power BI Desktop to create data models.

During this course you will review:

  • Writing DAX formulas.
  • Defining calculated tables and columns.
  • Defining measures.
  • Using DAX iterator functions.
  • Modifying filter context.
  • Using DAX time intelligence functions.

After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns.

BOOK YOUR COURSE

solutions training courses recruiting consulting NT darwin

AUD 750

This is for 1 person per day.

We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please send us an enquiry.

Key Topics

Within 1 day, you will have a chance to go through 7 important modules below:

What Is Included

Target Audience

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.

This course is also targeted toward those individuals who develop reports that visualise data from the data platform technologies that exist both in the cloud and on-premises. 

 

Prerequisites

DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience.

Skills Gained

After completing this training, the attendees should be:

  • Able to work with Data Analysis Expressions (DAX),
  • Perform calculations and define common business calculations for use in reports
  • Address performance and functionality concerns.

NT Dataset

You will connect real public Crocodile Captures data in the Excel file, select the tables you want to use, and import them for transformation. Public and organisational datasets will often require understanding and shaping in order to make for interesting and useful analytics.

 

solutions training courses recruiting consulting NT darwin
solutions training courses recruiting consulting NT darwin

Power Query

Skills in Power Query are essential in being able to take charge of the clean-up and perhaps re-organisation of your input datasets. While you wait for the data owner to clean-up the data or provide it in another format, Power Query gives you the power to take this into your own hands and you will be surprised what you can do.

Offering NT’s Leading Microsoft Training Resources
As Darwin’s fastest growing Microsoft Learning Partner, we are aligned with Microsoft Learning Worldwide, providing Online Technology Learning and Innovative Hands-On Labs platforms which combine to give you the best options for flexible and powerful training options

Our trainees say

Your commitment, passion, and delivery were really amazing. We had a great start and the speed as well as intensity with which we rolled out globally over 3 years was unbelievable.

solutions training courses recruiting consulting NT darwin government
Jeff Kane
AI Darwin

“Joining Cloudstreet Consulting gives me the opportunity and confidence to apply all the knowledge I had gained from school towards the IT industry”.

Peter Tran
Cloudstreet Consulting

LEARN ON THE GO!

Improve the management of your company and save money by making wiser decisions. Discover all the services we offer.