(Livestream Replay) Practical Use Cases for DAX Calculated Columns - Tristan Malherbe

DESCRIPTION 📄

Over the last few years, many debates arose in the Power BI community about the use of DAX Calculated Columns. In this session, Tristan Malherbe will show concrete & real-life use cases to illustrate the power of DAX Calculated Columns. The main topics covered will be:

• Context Evaluation (Filter context, Row Context, Context Transition)

• Static Segmentation based on DAX measures
  Pre-Computing flags in Dimension tables to boost your Power BI reports' performance and ease your DAX calculations

• Inter-table calculations

• Inter-row calculations and windowing patterns with the new DAX windowing functions

GUEST BIO (Triastan Malherbe)👤

Tristan Malherbe is a Microsoft Data Platform MVP since 2017. He is the creator and current co-leader of the French Power BI User Group (Club Power BI, 7,000+ members) and more recently the French Fabric User Group (Club Fabric, 300+ members). Over the last 7 years, Tristan gave 150+ Power BI conferences & trainings in America, Europe and Middle-East. His favorite topics are Data Architecture, Data Modelling/DAX & performance tuning. Tristan is also the co-founder of Data Pulse, a Fabric & Power BI consulting firm (14 people) based in France.

RELATED CONTENT 🔗

PBIX Link
Twitter
LinkedIn
YouTube
MVP Profile

(Livestream Replay) The Cost of a Workaround in Power BI - with Injae Park

DESCRIPTION 📄

From using SVGs or DENEB to create unique visuals, to page level security with RLS - workarounds are often necessary to overcome limitations and achieve desired functionalities in Power BI. However, these workarounds come with their own set of costs and considerations. This session discusses the key factors to help developers evaluate workarounds in Power BI, ensuring that the benefits outweigh the potential drawbacks.

To do this, we will explore some real-life workarounds in Power BI such as code-based Custom Visuals (DENEB, SVGs, HTML, Python), Page level security, and storing a custom PowerQuery library in Github. We will also dive into the trade-offs involved, including maintainability, impact on development, and technical debt.

GUEST BIO 👤

Injae Park is a Microsoft Data Platform MVP who combines his technical expertise with a passion for teaching by sharing his insights and practical tips through his YouTube channel @PowerBIPark. Injae's content ranges from beginner tutorials to advanced techniques, and as part of the Power BI Core Visual Representatives - he aims to bridge the MS Developer team with the Power BI community. His education in psychology and economics as well as his experience in consulting gives him a well-rounded perspective on the Power BI Developer experience, making his tutorials both engaging and accessible.

RELATED CONTENT 🔗

Injae’s Linkedin
Injae’s Youtube
Injae’s Github

(Livestream Replay) Fabric & Power BI: Awesome Use-Cases with DAX Query View - with Zoe Douglas

DESCRIPTION 📄

Join us live as we dive into the world of Microsoft Fabric! In this session, Zoe will walk you through the process of creating semantic models using three powerful approaches: Direct Lake, Import, and DirectQuery (DQ). We'll explore how each of these methods can be utilized within Microsoft Fabric to build robust and scalable models tailored to your data needs.

But that's not all—once we've crafted these models, I'll demonstrate how you can leverage them to write efficient DAX queries using the DAX Query View. Whether you're new to Microsoft Fabric or looking to refine your skills, this demo will provide valuable insights and practical techniques you can apply to your projects.

Bring your questions and curiosity, and let's explore the possibilities together!

GUEST BIO (Zoey Douglas)👤

Zoe is a Product Manager at Microsoft working on Power BI in Microsoft Fabric with features such as DAX query view, Direct Lake, Model Explorer, and Copilot. Before coming to Microsoft I was a Power BI consultant and mentor, enjoying the Power BI community forum and taking on data challenges.

RELATED CONTENT 🔗

Direct Lake
DAX Query View
Web Modeling
Model Explorer

(Livestream Replay) Creating Accessible Ops Data with Real-Time Intelligence in Fabric - with Will Thompson

DESCRIPTION 📄

At Microsoft Build in May, we announced Real-Time Intelligence which brings our messaging, time-series analytics and real-time action systems together in Fabric. We’ll look at how these help data engineers and business analysts ingest, analyze, and take action on streaming and real-time data. I’ll demo Eventstreams, Eventhouse, Real-Time Dashboards, and Data Activator.

GUEST BIO (Will Thompson) 👤

Will is a self-confessed data geek, working his way through sysadmin and DBA roles before joining Microsoft. He spent 5 years helping customers in the UK implement and get value out of Microsoft’s BI solution. When an opportunity arose to move into product engineering in 2012, he jumped at it and took ownership of Power BI’s visual and modeling features. In 2022 he started running Product Management for Data Activator, a new product for monitoring and acting on changes in data.

RELATED CONTENT 🔗

Will's LinkedIn
Product Blog
Fabric Community