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.
As Power BI grows to become a superset of Analysis Services functionality, a lot of that functionality will evolve as it becomes available. Incremental data refresh is a great example of how Power BI is modernizing/simplifying complex BI implementations. Incremental data refresh is the process of incrementally loading new or changed data to a BI … Continue reading BI Evolution: Incremental Data Refresh
I have built several solutions over the years to enable business users to get at the data they need to do the analysis that is important to them. I would build cubes so that they could slice, dice and mold the data into the shape they need. They would use tools like Excel, Reporting Services … Continue reading Keeping Big Data Big with Aggregations
Analysis Services has been shipping as part of SQL Server for close to two decades. When we decided to bring it to Azure, we wanted to take the same things people liked about SSAS and make it a fully managed platform as a service. It was import to us that users could take the same … Continue reading Azure Analysis Services vs. SSAS
This is the excerpt for your very first post.