Press "Enter" to skip to content

Optimizing DAX with AI

Marco Russo and Alberto Ferrari speed up operations:

The debate over whether AI will replace human work is heating up. However, our vision is different: AI is not a replacement; it is a powerful tool, and when AI and humans work together on a problem, the outcome is better than when either works on their own.

Optimizing DAX is a fascinating task. However, in the process of optimizing DAX, you need to pay attention to several details:

  • The new formula needs to be equivalent to the old one; this requires extensive testing.
  • The shape of the query being executed matters: a formula may be better than another in a specific test, but not in others.
  • The data distribution matters: a database with 100K customers and 100M transactions requires a different optimization compared to one with 10K customers and 10B transactions.

You will often get about as much out of using generative AI tools as you are willing to put in. This article does a good job of showing that.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.