(Livestream Replay) DBT...What's That?!? Exploring the Data Build Tool in Fabric - with Johnny Winter 💀

DESCRIPTION 📄

Explore the powerful fusion of dbt (data build tool) with Microsoft Fabric. Discover how this integration allows you to transform your data using version controlled, documented, repeatable and testable patterns that you're able to deploy within Fabric's Synapse Data Warehousing. Learn practical use cases and best practices for leveraging dbt's capabilities, enhancing data reliability and driving more informed decision-making processes. For those wanting to follow along, you'll need access to a Fabric Data Warehouse, VS Code and a virtual python environment.

GUEST BIO 👤

Johnny currently works as a consultant for Advancing Analytics. He’s been working with Business Intelligence software since 2007, specialising in the Microsoft data platform since 2016. He’s a self-confessed Business Intelligence geek and in his spare time runs the website and YouTube channel Greyskull Analytics, where he likes to nerd out about all things Power BI.

RELATED CONTENT 🔗

Website
LinkedIn

(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

(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