Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! This article shows why a star schema can fix some of the issues in your report. Read more
I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations, and have them readily available for the next conversation… As a bonus,… Read more
This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations. Read more
This article shows how to add an additional “other” row to the selection obtained using the Top N filter in a Power BI report. Read more
The dynamic version of the ABC Classification pattern is an extension of the Dynamic Segmentation pattern It groups items such as Products or Customers into segments based on their cumulated sales and how much they contributed to the total sales… www.sqlbi.com
The Definitive Guide to DAX (Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI) is the most comprehensive and authoritative guide to Microsoft’s DAX language for business intelligence and analytics. While other books cover only the basics, this guide offers expert guidance on everything intermediate-to-advanced Excel users and BI professionals need to know, from the basics to innovative high-performance techniques. Read more
Marco Russo
Apr 15-17 - New York
Jun 3-5 - Amsterdam