I'll present "Understanding Power BI Premium" at three public events in June. June 8th, Carolinas Power BI Group in Greensville, SC at 6 PM June 24th, SQL Saturday Chattanooga, TN at 1:15 PM June 26th, Atlanta MS BI and Power BI Group, Atlanta, GA at 6:30 PM My calendar has the details. Microsoft Power BI has enjoyed a lot of attention and success since it…
Read article
I'm working on architecting a financial planning solution powered by Analysis Services Multidimensional. One thing that might not be obvious is how Multidimensional selects the target of writeback allocation. In this case, planning will be done at Customer and Product level. With the default equal allocation when writing at the customer level, it might appear that writeback doesn't work correctly. You'd expect that only the…
Read article
MS BI fans, join me for the next must-attend Atlanta MS BI and Power BI Group meeting on May 22th at 6:30 PM. My esteemed friend, Stacey Jones from Microsoft will explain the predictive analytics capability of Cortana Analytics Suite. He'll demo a predictive analytics solution that was developed in a single day! It leverages Azure Machine Learning, Azure Data Factory, HDInsight, Spark, Power BI, and Intelligent…
Read article
I'm sure we've heard the announcements today about Power BI Premium. In fact, Power BI Premium is so important that Microsoft has positioned it as a new product under the Power BI marketing umbrella name instead of a new licensing model. Microsoft and industry experts covered the announcements well so I won't reiterate the obvious. You may wonder what these changes mean for you. Let's…
Read article
The May release of Power BI Desktop adds the ability to define DAX calculated measures when Power BI Desktop is connected live to a Tabular model or Power BI datasets. This is conceptually similar to defining MDX calculated members in Excel connected to a cube. The measure definitions are local to the Power BI Desktop model (the Tabular model is not modified). You can do…
Read article
