SQLBI+

SQLBI+ is a subscription service that offers exclusive access to advanced content on DAX, Power BI, and Analysis Services, created by top experts Alberto Ferrari and Marco Russo.

This subscription is not a replacement for our other, foundational courses: it is an additional service for professional model authors who spend considerable time creating and deploying Tabular models in Power BI and Analysis Services.

Structured courses, white papers, and individual sessions are the primary formats you can find on SQLBI+. The topics are diverse and very specialized.

We constantly add new content to SQLBI+; in fact we are committed to adding at least 2 new courses and 4 other pieces of content every year. 

Learn more about the philosophy of SQLBI+ on this article.

What is included (so far)

  • Video Course + White Paper

    Composite Models

    9 lectures - 5 hours  The Composite Models video course describes in depth how Power BI and Analysis Services manage the different types of composite models you can create. The goal is to understand the underlying architecture to make sure you make the right design choices to create models that can be maintained over time and provide good performance to your end users.

  • Video Course + White Paper

    Writing DAX Queries

    51 lectures - 7 hours  The Writing DAX Queries video course describes the DAX query syntax and many DAX functions and techniques to manipulate data. These same techniques are also useful for creating DAX table expressions in calculated tables and in the Detail Rows Expressions in the Tabular model.

  • 01:09:34
    Video

    Inside the VertiPaq Engine

    The VertiPaq engine used by SQL Server Analysis Services Tabular, Power BI, and Power Pivot, is a columnar database capable of incredible performances, both in speed and compression. In this session, we perform a deep dive into the database architecture…

  • 46:36
    Video

    Introducing Calculation Groups in DAX and Power BI

    Calculation groups are the most important feature introduced in DAX after variables in 2015. By using calculation groups, you can apply transformations to existing measures without having to create new measures in the model. For example, you can define the…

  • 52:26
    Video

    My Power BI report is slow – What should I do?

    You created a wonderful Power BI report, but you wait too much time when you open it. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance? This session…

Video courses come loaded with the usual awesome features of our video learning platform: progress tracking, multi-language subtitles and transcripts, bookmarks and highlights, and a private discussion area with our team. Individual videos, instead, are more similar to conference sessions.

Roadmap

We have already planned the following content for the near future:

  • January 2023: How Time Intelligence Works in DAX
  • March 2023: Different Types of Many-to-Many Relationships
  • May 2023: Inside Calculation Groups in DAX

More will be announced in the coming months!