Introducing DAX Optimizer (with Marco Russo)

DAX Optimizer is a tool that performs a deep, static analysis of your DAX code, to identify possible performance bottlenecks and provide prioritized suggestions to fix the code starting on the more impactful areas.
The tool is the result of years of research and development, it was unveiled in June 2023 and has been in public preview since October 2023 - now we are very close to the general availability and almost feature complete!
We will explore the tool with Marco Russo, who participated in the development since the beginning and can provide any kind of insights about how to get the best from DAX Optimizer.
GUEST BIO (Marco Russo) 👤
Marco Russo wrote several books about DAX with Alberto Ferrari. They produce articles and videos on sqlbi.com and teach DAX and data modeling classes worldwide. Marco also worked in the last few years on DAX Optimizer, a tool produced and distributed by Tabular Tools.
RELATED CONTENT 🔗
DAX Optimizer Website -- www.daxoptimizer.com
DAX Optimizer Documentation -- docs.daxoptimizer.com
DAX Optimizer news -- www.daxoptimizer.com/blog
SQLBI -- www.sqlbi.com
Tabular Tools -- www.tabulartools.com
VIDEO CHAPTERS 📺
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consulting.creator-spr...
HAVENS CONSULTING PAGES 📄
Home Page -- www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Course -- www.havensconsulting.net/onli...
Contact & Support -- www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #tabulartools #daxoptimizer #daxformatter #sqlbi

[@powerbinareal]

TOP!

[@sujith1801]

Looks like this tool only Analyzes the DAX and tells what are the issues, but not certainly optimizes it automatically. To me, the price is quite high for just analyzing it. At the end, I still need to fix DAX myself. I wish there are cheaper options. But I appreciate the efforts went into making this tool.

[@marcorusso7472]

I understand that the expectations may differ, but if you think that the product isn't worth the price, it makes sense you don't use it.
Reaching this level of accuracy required years of investment. Fixing the code automatically would be possible in a limited number of cases; there are too many assumptions that should be made to make sure that the code replacement works. Believe me, we studied this accurately, and we could fix a few cases automatically, but it wouldn't be fair to sell a service that fixes measures in just 10% of the cases.
We prefer full transparency: this tool helps a developer. Our idea is that the cost is worth the gain in productivity. We might be wrong, of course. Time will tell.
Thank you for your comment!

[@QuLaZz]

If you use a monthly subscription, you can pay 70 $ and have 5 models with 20 runs for that one month?

[@marcorusso7472]

@@QuLaZz Yes!

[@alexbehrmann9557]

i am looking forward to getting my hands on this, i am trying decide what license type best fit my Org, we have 200 plus reports but only 2 developers

[@marcorusso7472]

My suggestion is to start with the service subscription. You can also share it between the two developers (you should assign it to a group - we still haven't documented it, but it's already available; wait a few weeks for the full documentation).