Create quick queries quickly with SSAS in Azure
In a perfect world a data warehouse would always return all queries very quickly, no matter what the size or complexity of the data warehouse. But the reality is that sometimes we won’t get the performance we need from the data warehouse, and the solution is to use a SQL Server Analysis Services (SSAS) cube, which also has other benefits (see Why use a SSAS cube?). Thanks to Azure, creating a cube can be done in a matter of hours, giving you quick results for just about any query no matter how big the data warehouse gets.