Estimating Data Compression

Now that the age of in-memory databases has dawned on us, I have been experimenting with different aspects of VertiPaq and I find its technology fascinating. It is safe to say that VertiPaq will propel Microsoft Business Intelligence for years to come with all of its three flavors: PowerPivot (self-service BI), Business Intelligence Semantic Model (corporate BI), and data warehousing (column-based stored indexes). Unlike Analysis Services MOLAP, which compresses data by rows, VertiPaq compresses data by columns.