Topic: Power BI

       15 videos of 173 posts
video –

Deep dive into DAX evaluation context

Ever struggled with a formula in DAX that does not compute what you want? It has happened to us many times, and we know that the problem is ALWAYS related to the evaluation context. Filter context, row context, and context…  Watch now

video –

Aggregations in Power BI

Aggregations have been introduced in 2018 in Power BI, as an optimization technique to manage large tables. By providing pre-aggregated tables, you can highly improve the performance of a Tabular data model. In this session we introduce the concept of…  Watch now

video –

Different types of many-to-many relationships in Power BI

The introduction of the weak relationships in Power BI composite models enables new data modeling techniques. However, not all of the many-to-many relationships can be managed by using weak relationship. The “classical” many-to-many relationships in data warehouse is a design…  Watch now

video –

Understanding relationships in Power BI

Relationships are the foundation of any Power BI or Analysis Services Tabular data model with multiple entities. At first sight, this is a trivial concept, especially if one has a knowledge of relational data modeling. However, the ability to create…  Watch now

video –

Time intelligence in Microsoft Power BI

Every Microsoft Power BI model has dates and the need for calculation over dates to aggregate and compare data, like year-to-date, same period last year, moving average, and so on. Quick measures and DAX functions can help, but how do…  Watch now

video –

Time Intelligence in Power BI – Global Power BI User Group

Time Intelligence is probably the most interesting feature of any analytical solution. Computing Year-To-Date, Month-To-Date, Same-Period-Last-Year, is quite easy in DAX but, as soon as the customer requests for time intelligence comparing data from different tables, or to manage non-standard…  Watch now

video –

VertiPaq Analyzer 1.7

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular. Learn how to connect VertiPaq Analyzer to Power BI and to SSAS Tabular, and see quick overview of the features available. Then, download…  Watch now

video –

[UPDATED] Synoptic Panel by SQLBI for Power BI

The Synoptic Panel by SQLBI is a powerful visual component for Power BI that connects areas in a custom image with attributes in the data model, filling each area with a color or with a saturation of a color related…  Watch now

video –

Power BI Dashboarding

Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources. In order to use these new features,…  Watch now

video –

Power BI Dashboarding

Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources. In order to use these new features,…  Watch now