…brew your own Business Intelligence


Latest Posts

  • Enriching your Power BI Solutions with Metadata
    Ever looked at a Power BI report visual and wondered what the logic was behind a calculation? In most cases, your options are limited to… asking the report author checking the report documentation checking the data dictionary …all of which… assuming they even exist! …severely disrupt the analytical workflow. In...
    Read more
  • When to Scale-Up or Scale-Out with Azure Analysis Services
    Of all the new features and capabilities currently available with Azure Analysis Services, dynamic scaling up/down and in/out are my 2 favorite. Scaling Up refers to adding more (CPU and/or memory) resources Scaling Out refers to adding more servers Together these features allow you to adjust resources to match changes...
    Read more
  • Methods for Deploying to Azure Analysis Services
    This post covers the most common methods for deploying tabular models while explaining the trade offs for each option. Here are some questions to help you decide which one is most appropriate for your environment: Will you (the SSAS expert) be deploying the solution or do you need to hand...
    Read more
  • Analysis Services in the Cloud: IaaS vs PaaS
    When deciding to deploy an Analysis Services solution to the cloud, one of the very first decisions to make is whether to go with an Infrastructure-as-a-Service or Platform-as-a-Service architecture. The diagram below does a good job in explaining the differences between the two. Source: http://www.hostingadvice.com/how-to/iaas-vs-paas-vs-saas/ Note: from an Analysis Services...
    Read more
  • What is Super DAX?
    In a recent post, I mentioned something called Super DAX without giving it a very detailed explanation. If you’ve been working with SSAS for a few years and have a couple of Tabular projects under your belt, you may already be familiar with some of the performance improvements that roll...
    Read more