The calculation groups feature was released to Analysis Services at the end of 2019 and it is also available in Power BI by using Tabular Editor. Calculation groups modify the behavior of existing measures by replacing the original expression with another one that you can control.

We cover three important filtering topics in this module: ambiguity, arbitrarily shaped filters, and shadow filter context.

In this module you will learn the patterns of the static and dynamic segmentation of the attributes of a table.

Data lineage is important when you need to move a filter from a column over to another column in the model. Using TREATAS, you have the option of changing the data lineage of a table.

In this short module you will learn the details of data lineage, along with some practical examples of the uses of TREATAS.

DAX does not come with any built-in functions providing calculations over hierarchies between attributes and entities. However, the underlying data model can include a definition of hierarchies to be used by client tools to simplify the browsing experience over data.

Almost all data models need to analyze data over time. The first step for handling a date calculation is to create a Date table, which simplifies any date-related calculation. Because of its importance, you should be careful when you create a Date table.

CALCULATE is by far the most important, useful, and complex function in the DAX language, even if the function seems simple by itself. It only performs a few tasks, but the number of scenarios where CALCULATE is necessary, along with the complexity of the formulas that can be written with CALCULATE, make it necessary to dedicate a full, in-depth learning module to it.

The difference between scalar and table functions is that the former returns a single value, whereas the latter returns a table of one or more columns and one or more rows.

In Alberto’s words: DAX is simple, but it is not easy. There are only a few concepts that you need to learn, but you need to learn them well, in-depth, to become proficient. A small investment of your time into learning the beatiful DAX language will reward you with many years of productivity.

This video contains some thoughts about what 2019 holds for Power BI, based on various announcements made by Microsoft during 2018, especially its focus on enterprise features.

Microsoft Clustering is a workhorse algorithm of data mining. It is used to explore data, segment and categorise it, and to detect outliers (or exceptions, anomalies). Each cluster represents naturally occuring groupings of your data points, grouped by their similarities, as described by their various attributes. In this in-depth, 1-hour 50-minute video, Rafal explains clustering concepts, the entire process, and all of the algorithm parameters. The detailed 12-part demo, which forms the heart of this tutorial, shows you the iterative process of clustering, explaining how to segment your own data, such as customers, or products.

A decision tree is a tree of nodes. Each node represents an input value that makes the most profound difference to an output that you wish to study. This free 10-minute video by Rafal introduces this powerful analytical tool, and explains the concepts while analysing simple retail data in a demo.