On December 2nd, 2014, I published a blog announcing the preview of the first ever REST APIs for Power BI. These first APIs could only do four things. They could list all the datasets that a user had. They could create a new dataset from a JSON schema. They could add rows to a table … Continue reading How Real-Time BI Requirements are Evolving into the Mainstream
Tag: Big Data
Speeding up queries with aggregations
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.
Keeping Big Data Big with Aggregations
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