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 the Director of Product for Microsoft OneLake in Microsoft Fabric. He leads the team responsible for defining and delivering a unified Software-as-a-Service (SaaS) data lake for the entire organization. Prior to this role, Josh played a pivotal role in shaping Power BI, leading the development of developer experiences, Power BI Premium, SQL Server Analysis Services, and Azure Analysis Services. He also spent several years on the Bing team, leveraging his expertise in business intelligence to extract insights from Bing’s massive data infrastructure. Opinions expressed on this blog are his own View all posts by Josh Caplan
PhantomDB 
One thought on “Speeding up queries with aggregations”