Topic: Power BI

       19 videos of 213 posts
video –

External Tools for Power BI – London Power BI User Group

Power BI has an integration with external tools that can provide additional features and improve the productivity of report authors. In this session we see how this integration works and we analyze a few popular external tools like DAX Studio,…  Watch now

video –

Query Performance Tuning in DAX Studio

DAX Studio is the best tool to analyze the performances of DAX queries. In this webinar recorded for powerbi.tips, Marco Russo shows how to collect metrics in DAX Studio and investigate on storage engine and formula engine cost of some…  Watch now

video –

Checking model size using VertiPaq Analyzer in DAX Studio

VertiPaq Analyzer is a set of tools and libraries to analyze VertiPaq storage structures for a data model in Power BI and Analysis Services Tabular. In this webinar recorded for powerbi.tips, Marco Russo shows how VertiPaq Analyzer has been integrated…  Watch now

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