This video is available to SQLBI+ subscribers only.
This content is exclusive to SQLBI+ subscribers
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 internals, discovering how Vertipaq stores information to gain better insights into the engine and understand the best way to model your data warehouse to leverage the VertiPaq features. We see common and useful techniques to increase the compression ratio and obtain better performances from your Tabular data model.