This blog builds on my previous blog, Keeping Big Data Big with Aggregations. The below video contains an end to end demonstration of setting up in-memory Vertipaq aggregations over data stored in an Azure SQL Data Warehouse. The data used within this demo, is telemetry collected from from from the how-old.net website.
Speeding up queries with aggregations
Posted on by Josh Caplan
Published by Josh Caplan
Josh Caplan is a Principal Group Program Manager at Microsoft currently working on professional BI experiences for Power BI, SQL Server Analysis Servers and Azure Analysis Services. Prior to that role Josh drove the developer experiences for Power BI and spent several years on the Bing team developing BI on Bing’s massive data. Josh has developed BI solutions for other companies including the Lincoln Financial Group and the Franklin Institute in Philadelphia. Opinions on this blog are his own. View all posts by Josh Caplan
PhantomDB 
One thought on “Speeding up queries with aggregations”