Optimizing DAX Workshop
Melbourne, AU

This two-day workshop is a complete course about optimizing queries and measures in the DAX language. DAX is the native language of Power Pivot for Excel, Power BI Desktop and SSAS Tabular models in Microsoft SQL Server Analysis Services. This course is aimed at BI professionals, Power BI and Excel users who already know the DAX language and want to learn how to optimize DAX formulas and models for improving performance.

The goal of the course is to enable you to find bottlenecks in DAX calculations using tools such as Profiler and DAX Studio, providing the knowledge to improve the performance by using different DAX formulas or by changing the data model, when required. All the attendees will receive a copy of the new book The Definitive Guide to DAX.

Prerequisite: Attendees need to have a good knowledge of the DAX Language, and a previous experience using either Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular. You might acquire this knowledge by participating to the Mastering DAX Workshop, or having equivalent real-world experience.

Topics covered:

  • xVelocity engine internals
  • Hardware considerations
  • Monitoring Tabular server
  • Reading Profiler Traces
  • Understanding Formula & Storage Engines
  • Reading query plans with DAX Studio
  • Examples of DAX optimizations
  • Optimizing Data Models and Relationships Usage

The course includes hands-on labs: you will make practice using your own notebook.

In collaboration with  Agile BI

» Course outline (PDF)

Each attendee must bring his/her laptop for exercises. We will provide the configuration required, or in alternative it will be possible to connect to a virtual machine on the cloud using Remote Deskop and the Internet connection available in the training room.

Course time

09:00am » 05:00pm

Course location

Saxons Training Facilities
500 Collins Street
Melbourne, AU
» Get directions

Course Confirmation

 Please, wait the final confirmation that you will receive with a separate mail after you registered online before buying any non-refundable ticket or reservation for flight, hotels, or other services related to the course.

Special Bundle Offer

Don't miss another great course in a convenient time frame! Register to both courses and obtain a special bundle price:
Mastering DAX Workshop
Feb 27 - Mar 1, 2017 - Melbourne, AU

Learn to master DAX query language and Tabular patterns to boost your Power BI, Excel Power Pivot or Analysis Services solutions.

Self-Assessment for Prerequisites to attend the course

This self-assessment has the goal to check whether you have the right prerequisites to attend the Optimizing DAX Workshop in a proficient way. The course is an intensive one and in order to get the maximum from the 2 days, it is important to know the DAX language very well. In particular, the test check your knowledge of evaluation context, context transition, and DAX functions that are commonly used.

If you do not have a good confidence of DAX, you might be unable to get the most from the Optimizing course. Depending on your final score, the final message will give you a suggestion to prepare for the Optimizing DAX Workshop, such as topics to study, books, videos, and other courses.
In any case, you will be your first judge, especially if you do not feel yourself confident answering to the questions of this test. We suggest you to answer “I don’t know, I’m not sure” when you are not able to choose an answer.

Read the following questions carefully and find the correct answer from the options provided. We do not provide a suggested time time to answer each question. You should look at the answers and select the one you believe is correct – this is more important than speed. Take the time you need to get the answer correct, but don’t waste time once you have the answer you will choose. Some questions are just more difficult, and will naturally take longer to answer.

You can access the Internet and other documentation during the test if you like. The goal is to measure your understanding of DAX concepts that are fundamental in performance analysis and optimization. It is not a goal of the test to measure your knowledge of the syntax of DAX measures, so it is ok if you read the documentation of a function to check the position of a certain argument.

Remember: don’t cheat yourself!

You can fill the form in an Anonymous way, or you can leave us your email. We will not disclose the result of your test, guaranteed!

You must specify a text.
You must specify an email address.


Course book will be delivered to the attendee email.
If you want to receive to different address please use
Additional Notes field below.

Use the above information

Courses and Payment

Remove   Apply

Optimizing DAX Workshop
Mar 2-3, 2017 - Melbourne, AU
AUD 1840
AUD 1590

Optimizing DAX Workshop
Mar 2-3, 2017 - Melbourne, AU
AUD 4530
AUD 3492
Mastering DAX Workshop
Feb 27 - Mar 1, 2017 - Melbourne, AU


In the next step you can review your data
and confirm registration
Review your informations
You will receive wire transfer information via email within next working day
Pay with PayPal / Credit Card
America Express To pay with American Express:
  1. Press Pay with PayPal button below
  2. In the next window choose Don't have a PayPal account option
Frequently Asked Questions

Book included
Each participant will receive a copy of:

The Definitive Guide to DAX
Microsoft Press

Terms and Conditions
The workshop is delivered in English.
The workshop registration fee includes:

  • 2 days course
  • Coffee breaks and lunch for both days
  • A copy of the book The Definitive Guide to DAX
A single copy of the book is provided to a student purchasing a bundle of two courses that have the same book as training material.

Substitution and Cancellation Policy
Cancellations must be submitted in writing. All cancellations received by SQLBI at least 15 days before the beginning of the course are entitled to a refund, minus a € 200 processing fee. No refunds will be given to registrants who cancel less than 15 days before the beginning of the course, or who fail to attend the course. Substitutions for paid registrants may be made at any time. However, written notice is required and for complete accuracy must include all pertinent changes for the substituting attendee. In the extraordinary case where SQLBI might cancel the course, a full refund will be given to all paid registrants. SQLBI will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

For any other information, please contact: info@sqlbi.com