VertiPaq Analyzer crash course

When you import data in Power BI, Analysis Services, or Power Pivot, you are using an in-memory columnar database called VertiPaq. Knowing how the data is distributed in your model and stored in memory is important to optimize the compression and analyze any performance issue.
VertiPaq Analyzer 2.0 is a tool integrated into DAX Studio that provides an immediate report of the data distribution and a more detailed analysis of compression and DAX expressions used in the model producing an Excel file that is easy to manage.
Learn how to read the metrics provided by VertiPaq Analyzer in 20 minutes and find how to save memory for your data models.

Feedback Link -

Starts: 16:40 10th Mar 2022
Ends: 17:00 10th Mar 2022


Short Description
- Introduce VertiPaq Analyzer features in DAX Studio and as a library available in other tools.
Other technologies
- Azure Analysis Services SQL Server Analysis Services

Slidedeck Link

VertiPaq Analyzer crash course.pdf


Marco Russo


On PremisesIntelligence and AnalyticsDevelopingMonitoringModellingPower BIBeginnerWhat

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.