(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

(Livestream Replay) Christmas Special! Generative AI & Fabric - with Mathias Halkjær

DESCRIPTION 📄

It's Christmas time 🎄

Guess what? Data never sleeps. Especially if you signed up to handle more than 8 billion deliveries in one day.

In this special Christmas edition, Mathias Halkjær will join alongside a special guest who is in something of a pickle. Let's explore how Gen AI and Microsoft Fabric can help ease their workload.

This episode will cover how to work with Open AI in conjunction with Microsoft Fabric. Specifically, we will explore several approaches to how Open AI plays together with Microsoft Fabric, explained through practical examples with perhaps more than a subtle touch of humor.

GUEST BIO (Mathias)👤

Mathias is a data enthusiast with a great passion for the synergy between data analytics and cloud data platforms.

As a Principal Architect at Fellowmind he works with building up clients' data capabilities, implementing data platform technologies and all-in-all maximize the impact of their their data.

Being a Microsoft Data Platform MVP, he is very passionate about sharing anything with community, especially something around turning data into impact!

With a background in Product Development and Innovation, Mathias brings a unique 'Data Product' perspective to the realm of data architecture, and is obsessed with the bigger picture. With his slightly rebellious attitude, he's not afraid to challenge the status quo and break industry norms to find new and better solutions.

GUEST BIO (Santa’s Helper)👤

Mr. Fab. Rick is a delightfully imaginative puppet speaker and one of Santa's most creative helpers at the North Pole.

RELATED CONTENT 🔗

Mathias' LinkedIn
Mathias' Twitter

(Livestream Replay) Demystifying [DAX] Evaluation Context - with Brian Grant

DESCRIPTION 📄

“DAX Evaluation Context”, just the name alone strikes fear into the heart of even seasoned Power BI developers. The reality however, is that Evaluation Context in DAX isn’t hard to understand, it’s simply hard to describe. In this session Brian Grant will use a technique called "Formula Decomposition" to visually break down a big DAX formula into a chain of smaller, bit-sized sub-formulas; this in turn will create the platform needed for Brian to make the concepts of Evaluation Context both clear to understand and easy to remember.

At the end of the presentation you will both have a clear idea of how to visualize Row and Filter Context, and also understand how the sub-formulas leverage these contexts to produce the answers you see on a Power BI page. Furthermore, the next time you look at a big intimidating DAX formula, you will know how to break it down into bite sized chunks so they can be understand one at a time.

GUEST BIO 👤

Hailing from the East side of beautiful Portland Oregon, Brian is a Senior Business Analytics consultant with local data heroes Skypoint. Having spent his early years deep in the study of acting and screenwriting, he finally graduated Summa Cum Laude with a degree in Economics. His driving belief is that the biggest barrier most people face when learning technology isn't technology at all, but language. Taught the right way, most people can learn most things; helping people learn skills that are "too technical" for them is his greatest joy. He is the author of the Elements of DAX series on YouTube.

RELATED CONTENT 🔗

Blog
LinkedIn
YouTube

(Livestream Replay) Introducing Inforiver Analytics+ in Power BI (with Gopal)

DESCRIPTION 📄

Why the new Inforiver Analytics+ 3 in 1 visual with 50+ Charts + Cards and Tables is the only way for customers to retire their legacy Tableau, Qlik, Spotfire, Think-Cell dashboards and migrate those into Power BI.

You will see a live demo for capabilities that are preventing customers from migrating natively with Power BI and how Inforiver Analytics+ brings those capabilities into Power BI

1. Handling Hierarchies across all three axes (x, y, z) for a true multi-dimensional “Visual Pivot Table” like experience as in Spotfire.
2. Ability to Split and Group Measures like Tableau
3. No-Code Multi-Row KPI Cards
4. Inforiver Tables and Tables as small multiples inside Inforiver Analytics+ Visual and what it can offer.
5. Experience how Casual Users can build Dashboards and Storyboards in just 5 minutes with no code
6. Inforiver Analytics+ Pricing Model
7. What is in the Vision and roadmap for Inforiver Analytics+

GUEST BIO 👤

Gopal Krishnamurthy is the Founder/CEO of Lumel. Lumel is Looking Forward to Disrupting Data & Analytics space with No Code Integrated Platform that will eliminate application silos caused by the diverse needs of business users (Reporting, Visualizations, Story Telling, Analysis (Drill-Down, Pivot), Planning, Simulations, Collaboration and Write-back).

RELATED CONTENT 🔗

Website
Blog
Buy Direct from Microsoft
Twitter
LinkedIn