Topic: Power Pivot
-
SQLBI offers a new introductory DAX video course called Introducing DAX. This article describes which users will benefit more from this learning experience, and how to enroll in the course. Read more
-
Sorting a column by using another column is one of the nice features of the new version of PowerPivot introduced with SQL Server 2012 (we call it PowerPivot v2, but it really v11 because it is aligned with SQL Server).… Read more
-
When you create a data model in Power BI, you should consider how to properly use naming convention and what columns to include, in order to improve usability and performance. This article provides a quick list of best practices valid… Read more
-
Bertrand d’Arbonneau added a new feature in the last version (v 1.09) of Power Pivot Utilities, which allows the visualization of Dependents and Precedents measures in the measure list created by the List Measures tool. How to use the new… Read more
-
We are approaching the end of 2017, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2018. New DAX… Read more
-
This article describes how DAX resolves column and measure names in DAX, providing best practices to avoid conflicting names. Read more
-
I have a long experience in working on reporting systems based on semantic models. Now we call them “self-service BI”, but the principles are the same we had in DSS (decision support system), OLAP (on-line analytical processing), and many other… Read more
-
This article compares the differences between calculated columns and calculated tables from a processing and storage point of view. Read more
-
This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular. Read more
-
In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago. Read more