(Livestream Replay) Introducing DAX Optimizer - with Marco Russo

DESCRIPTION 📄

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 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
DAX Optimizer Documentation
DAX Optimizer News
SQLBI
Tabular Tools

Identifying & Optimizing DAX Patterns (Case-Study)

Video by: Reid Havens

Walk through a client case-study with me as I identify and optimize repeating DAX patterns. The end result having less lines of code, simpler logic, and faster performance. Tune in to learn more!

(Livestream Replay) DAX Query View Best Practices & Historical Context - with Jeffrey Wang

DESCRIPTION 📄

The November Desktop release's public preview of the DAX Query View has ignited excitement among the DAX community. This feature represents the first new view since the inception of Desktop, joining the existing trio of Report View, Data View, and Model View. This addition is poised to transform the way DAX programmers approach their craft, encouraging them to write their own DAX queries more frequently.

A common challenge with DAX lies in its flexibility, as multiple methods often exist to achieve similar results. DAX queries are no exception; the community has already begun discussing various functions capable of producing comparable query results. In this episode, we will delve into the recommended functions and patterns for writing DAX queries. We aim to demystify the best practices recommended by the product team by exploring the historical context of their development.

GUEST BIO 👤

Jeffrey has over twenty years of experience in the BI industry and joined the Microsoft SQL Server Analysis Services team in 2004. As a co-inventor of the DAX programming language, Jeffrey has watched it grow from an unknown language to one that is widely used worldwide. His latest projects in DAX include the development of the recently announced Visual Calculations.

RELATED CONTENT 🔗

LinkedIn
Blog

Revisiting Common Calculation Group Patterns in Power BI!

Video by: Reid Havens

Because of the recent release of adding calculation groups directly from Power BI Desktop. We'll explore three common calculation group patterns and use-cases. Tune in to learn more!

RELATED CONTENT 🔗

Semantic Model View & Calculation Groups
Auto-Scaling for [DAX] KPI Cards?