Inside xVelocity in-memory engine (VertiPaq) for Power Pivot, Power BI and Analysis Services Tabular
Power Pivot, Power BI, and SQL Server Analysis Services Tabular models are based on the xVelocity in-memory analytics engine, also known as VertiPaq. This engine is a columnar database capable of incredible performances, both in speed and compression ratio. In this session, we will perform a deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine. We will use special tools to quickly read how data is compressed and stored in memory. At the end, You will learn common and useful techniques to increase the compression ratio and obtain better performances from your data model.
Marco is a business intelligence consultant & trainer. He has extensive experience with BI solutions & has worked with Analysis Services since 1999, & Power Pivot since its beta release in 2010. He has written many white papers about the usage of Microsoft BI technologies. He has authored "Microsoft Excel 2013: Building Data Models with PowerPivot," "Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model," "Expert Cube Development with SSAS Multidimensional Models," & "DAX Patterns”