Please complete the following exercise before watching this video in which Alberto explains how to solve them:

• 15.30: Many-to-many relationships

You can download all exercise files from here (only available to Full Access Subscribers).

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

14.10: Distinct count of countries
14.20: Sales quantity greater than two

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

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.

This video introduces Azure Analysis Services: a cloud-based version of SQL Server Analysis Services, which is essentially the same database engine that Power BI uses but available as a separate service, enhanced with sophisticated development tools and a rich security model.

This short video explains how to keep your Power BI report up-to-date if you are not using DirectQuery or Live Connections—imported data needs a scheduled refresh.

This video shows the Power BI Publisher for Excel add-in to connect Excel on the desktop to data stored in Power BI, and the Excel Cube Formulas, which are more suited for highly-structured reports.

This video introduces report building in Power BI, both for desktop, cloud, and mobile use.

This video introduced new features in Power BI that have been added in 2018 and that are relevant to the DAX and the Data Model section of the course.

This video discusses new features in Power BI that are related to the Modelling Data module of this course.

Everything that happens in the Query Editor is translated, behind the scenes, into a language called M. M is a functional language designed specifically for data loading and transformation.

Once you have connected to your data sources you can use the functionality of the Query Editor to transform it so that it is in the format you need it for Power BI - which is typically a dimensional model.

This video contains new content that is related to the Connecting to Data Sources section, and covers new features that have been added in late 2018.

Power BI offers a number of different licensing options, all of which are discussed in this video.

This short video explains how we have updated the Power BI course modules with the new features that were added during 2018.