Newsletter #300 is a significant milestone for SQLBI. I thought this was a good time to clarify SQLBI’s position on a topic we haven't discussed much yet: Artificial Intelligence (AI). #newsletter #sqlbi #ai

When a new SQLBI+ white paper on Power BI drops…

موقع SQLBI. وش هو؟. موقع احترافي متقدّم أسسه خبراء الـ DAX و Power BI:.Marco Russo و Alberto Ferrari.(نفسهم مؤسسي DAX Guide). وش تقدر تسوي فيه؟.•تقرأ مقالات تحليلية عميقة عن Power BI و DAX.•تتعلم من دروس احترافية متخصصة.•تشوف حلول مشاكل الأداء (Performance Optimization)

Why we waited so long to talk about AI. Every time we mention AI, people project their own beliefs onto it. At SQLBI, we talk about AI only when it makes a real difference, not because it's trendy. Last week many people were on vacation, so in case you missed it, here it is

Last week on SQLBI we published an article about tools in Power BI. Here's an overview of some (not all!) external tools that can help you, and at what stage in. Check below for a downloadable PDF. #powerbi #microsoftfabric

Found this little gem window shopping in the SQLBI+ section

موقع DAX Guide 🧮. وش هو؟. موسوعة دوال DAX الكاملة. أنشأه نفس الفريق اللي سوّى SQLBI (ماركو روسو و ألبيرتو فيراري). وش تقدر تسوي فيه؟.•تبحث عن أي دالة DAX وتشوف وصفها المفصل.•تتعلّم طريقة استخدام كل دالة ومتى تنفع.•تطلع على الاختلاف بين دوال متشابهة.•تشوف أمثلة واقعية على

中国で見つけたPower BI書籍の一部。SQLBIも見つけたし、国内のMVPが書いた本も多い。日本と違うのは、財務分析といった具体的な用途をベースにした本が多かったことくらいかな。白黒印刷が多かったのがちょいと残念。

SUMMARIZECOLUMNS best practices from @FerrariAlberto #PowerBI.

Reading material for the weekend!

Choose the right chart types for your #PowerBI reports: . Check the full article for more: .

Oh si 😁💪 #OptimizingDAX and #HappyDAXing with #SQLBI teams. Thanks a lot @marcorus & @FerrariAlberto #AlwaysLearning

New whitepaper for SQLBI+ subscribers: Understanding SUMMARIZECOLUMNS. When to use SUMMARIZECOLUMNS in DAX measures, and not only in queries and calculated tables. And why. And when not to use it. Autoexist, clustering, non-empty and value filter behavior: how they work, fully

ベ���トプラクティスは納得ずくで採用したほうがよい。常に厳守することだけでも多くの場合で良好な成果を得られるけれど、背景や目的がわからないルールはやがて軽視され、結果として失敗が多くなると思う。 #PBIJP.SUMMARIZECOLUMNS best practices - SQLBI #SQLBI.

Yes, you can use SUMMARIZECOLUMNS in a DAX measure, BUT. But only if you follow the best practices in this article + video. Spoiler: Goodbye ADDCOLUMNS / SUMMARIZE - well, with some exceptions. #dax #powerbi.

Why and when you should use VALUES while iterating a table reference in DAX. Article + video on SQLBI. #powerbi #dax .

Enjoying day two - Optimizing DAX at SQLBI Days with @marcorus and the #SML gang! Thankful for Marcos time and the chance to meet friends in person.

Great article @kurtbuhler and SQLBI! Very excited to learn more about this topic!.

When should you use DISTINCT over VALUES in DAX?.Here is how to write resilient measures that survive bad data and model changes. Article+video on SQLBI. #dax.