What is Vertipaq and how does it work? Part 1: Data compression

What is Vertipaq and how does it work? Part 1: Data compression
Vertipaq is the database and engine that runs on top of Power BI and PowerPivot.

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 this video, I will go 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 i...  



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