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
My thoughts on BI and Big Data from 2013
2013 may not feel like it was that long ago, but for big data, a lot has changed. At the time, Hadoop ruled a very map reduce focused world. Apache Spark was still more than a year away. Google BigQuery and Amazon Redshift were in their infancy. The predecessor to Azure SQL Data Warehouse, PDW, … Continue reading My thoughts on BI and Big Data from 2013
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.
BI Evolution: Incremental Data Refresh
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