What is Vertipaq and how does it work? Part 1: Data compression скачать в хорошем качестве

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 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