Creating a Calendar Slicer from a Matrix Table! (with Erik Svensen)

Video by: Reid Havens

Join Erik Svensen and I as Erik walks through how to transform a native matrix visual into a powerful Calendar type filter for your visuals! Where you can slice by date, day of week, week period of year, and more. Tune in for the demo!

GUEST BIO (Erik Svensen)👤

Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 70+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He started the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT 🔗

Erik's Blog
Erik's LinkedIn
CatMan Solutions

(Livestream Replay) Power BI Automation With Semantic Link - Sandeep Pawar

DESCRIPTION 📄

Semantic Link in Microsoft Fabric offers a new way to access the data and semantic information contained in a semantic model. This allows data scientists, data engineers and data analysts to preserve and re-use the business and domain knowledge in creating enterprise solutions.

In this session, Sandeep will give you an overview of Semantic Link and provide practical use cases to use Semantic Link in your development workflow to automate common Power BI tasks, optimize the semantic models and also monitor/manage the tenant. He will also show Semantic Link Labs, an open-source Python library with hundreds of useful utilities.

GUEST BIO 👤

Sandeep is a Sr Power BI Architect at Hitachi Solutions America where he helps organizations build enterprise analytics solutions using Microsoft data stack. He blogs about Data Engineering, Data Science and Power BI at fabric.guru

RELATED CONTENT 🔗

LinkedIn
Blog
Blogs Related to Semantic Link

(Livestream Replay) Power BI Meets UX Design: Accessible Insights - Elena Drakulevska

DESCRIPTION 📄

Imagine creating an amazing report—rich in insights and visuals—only to discover your audience can't use it or struggles to grasp its depth. In "Accessible Insights" we'll dive into inclusive UX design principles, revealing the strategic use of icons, text, and visual cues within Power BI.

Stepping into the shoes of users with varying abilities, we'll emphasize the crucial role of empathetic design and uncover the hidden, built-in accessible capabilities of Power BI.

Join this talk to learn how to create reports that transcend barriers and speak universally to diverse audiences. After all, accessibility is not just a buzzword—it's a necessity.

GUEST BIO 👤

Elena Drakul(evska) is a BI Consultant with a Master’s in Telecommunications Engineering from Politecnico di Milano and she’s currently based in Vienna, Austria. With a couple of years of experience across various industries, she brings a unique perspective to the intersection of tech, business, and design.

Passionate about both Power BI and UX Design, she finds immense joy in blending the two to create impactful data visualizations. As a fresh speaker at numerous data conferences and the author of her blog Moonstory, she shares her insights and expertise with a global audience.

When she’s not working magic with data, Elena can be found exploring the world, picking up new languages, doing yoga, and immersing herself in great books.

RELATED CONTENT 🔗

Elena’s Blog
Elena’s LinkedIn
Elena’s Twitter

Not All Query Folding is Created Equal...Performance Tuning PQ

Video by: Reid Havens

Everyone knows rule number one for Power Query performance is to ensure your query folds as much as possible. What do you do after rule number one? There is more to performance than just folding, and there are multiple approaches that can fold.

In this video, we deep dive into multiple queries with folding that all have different performance characteristics. We'll examine dates and lists and how M generates SQL when folding.

Tune in to see how you can check the efficiency of different folded queries!

GUEST BIO 👤

He slices! He dices! When it comes to Power BI, Greg Baldini does it all, and he is here to show you how to, too!

Co-founder of Argus PBI, Greg has a decade of experience with DAX, Tabular, and the Power BI family of tools. His career has been spent in solving hard problems for clients and seeking deep understanding of the fundamentals of data analysis.

RELATED CONTENT 🔗

Tabular Editor
Argus PBI
Greg's Website