(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

Three Techniques for Curating the User Experience in Power BI!

Video by: Reid Havens

Learn about three primary techniques for simplifying and curating the user experience for reports in Power BI. There's a mixture of art and science that goes into smart report design, especially designs that minimize pop-ups, distractions, and user interactions. Tune in to learn more!

RELATED CONTENT 🔗

PowerBI.Tips Theme Generator
Theme Generator (Livestream)
PBI Explorer
PBI Explorer (Livestream)
Dynamic Analytics Line

Extracting SQL Database/Table Names From Your Power BI Dataset!

Video by: Reid Havens

Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.

RELATED CONTENT 🔗

Extracting All M-Code from a Power BI Dataset

(Livestream Replay) Design Scalable BI Solutions with BI Solution Algebra - with Chris Wagner

DESCRIPTION 📄

Join Chris Wagner and Reid Havens as they talk about BI Solution Algebra, a framework for designing business intelligence solutions that are scalable, efficient, and cost-effective. They will share their insights and tips on how to choose the right mix of front-end, model, ETL, and other components to optimize your data analytics efforts. Whether you are a beginner or an expert, you will learn something new and useful from this lively and engaging conversation. Don’t miss this opportunity to learn from two of the best in the field!

GUEST BIO 👤

Christopher Wagner is a passionate data evangelist and a leader in data solutions. He is the Director of Data Solutions for Baker Tilly, a leading digital solutions, advisory, tax and assurance firm. He is also the founder of KratosBI.com, a website that provides resources, tutorials and insights on data and analytics. He hosts the Data Gods YouTube channel, where he shares his knowledge and experience with data enthusiasts and professionals.

Christopher has over two decades of experience in the data and analytics field, working with various technologies, platforms and tools. He has helped many organizations transform their data into valuable insights and actionable outcomes. He believes that data is the most powerful asset in the digital age, and he strives to make it accessible and understandable to everyone.

RELATED CONTENT 🔗

Website
YouTube
LinkedIn
X (Twitter)
Engagement