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.

In a previous video,    • What is Vertipaq and how does it work? Par...   we walked through the main known things that Vertipaq does to compress the data. Here are the methods used, not necessary in that order:

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.
   • Analyze memory usage in Power BI to improv...  


Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

Our PLAYLISTS:
Join our DAX Fridays! Series: https://goo.gl/FtUWUX
Power BI dashboards for beginners: https://goo.gl/9YzyDP
Power BI Tips & Tricks: https://goo.gl/H6kUbP
Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

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



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


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Linkedin: https://goo.gl/3VW6Ky
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB

#SUBSCRIBE #CURBAL

#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP