Why is Vertipaq so fast? Part 2: Columnar database

Why is Vertipaq so fast and what does it mean that it is a columnar database?

In this video, we will go through what it means that Vertipaq is a columnar database and why performance is so good.

In previous video we cover data compression:

When we import data in Power BI, the Vertipaq database will try with a series of algorithms, to compress the data as much as possible and the best way possible so it is easy and fast to query it with DAX.

1. Dictionary or Hash compression: It creates a dictionary for the columns stored as strings (text)
2. Value encoding: It will codify the columns stored as numbers to make them as small as possible
3. Run Length Encoding (RLE): Values that are the same in consecutive rows will be stored as a single data value and counted.

After you have seen this video, I recommend you to go back to the video I did on Monday where I go through a specific case on a google analytics report.

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo

#SUBSCRIBE #CURBAL

#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP

[andrewstennett]

Very easy to understand. Thanks so much

[EminUzunN]

Di di di di :) when you have bigger table then it becomes an issue :)

Did you start to get drama lectures? It was amazing ;)

[rrrprogram]

Naive question.... Logically columnar database looks first choice of database... Then why in first place did we have row database....
All the database should have been column database from first... Why did they go for row database

[prashantiyer]

Why will it not take ship name column for consideration, it also has the record for Quick stop.?

[onyekaekweh]

Hello, one quick question. Is vertipaq automatically installed in Power BI or it has to be purchased separately? And it the compression of document done manually or the engine does it automatically?

[SaiKumar-rgjt]

Hi clurbal, nice video, I created Tabular Model and then used in powerbi desktop. After I using the table visualzation in powerbi desktop. I getting error like could not the data for the visuals. But if I use matrix it is working fine. My client requirement is table visualzation only. Why I getting this error. Can you please help me out?

[brianxyz]

Why would it have to look at the Company Name and Order ID columns? Wouldn't just looking at the Company Name column suffice?