BI-NSIGHT – Power BI (Desktop Update, Service Updates, API Updates, Mobile App Update, Visual Contest Results, Content Pack – Stripe) – Office 2016 (Excel Updates, Power Query Update, Excel Predictions) – SQL Server Analysis Service 2012 Tabular Update – SQL Server Analysis Services 2016 Extended Events
So this week there was once again a whole host of updates with Power BI, as well as finally the official release of Office 2016. It sure is a busy time be in Business Intelligence space, especially in the Microsoft space. So let’s get into it… Power BI – Desktop Update So I woke up this morning to see that…
BI-NSIGHT – SQL Server 2016 – Power BI Updates – Microsoft Azure Stack
Well I have to admit that it seems that the Microsoft machine has been working flat out to get out new products and updates. If my memory serves me, this is the third week in a row that Microsoft has released new products and updates. I am really enjoying it! But hopefully this will slow down, so that we can…
SSIS – Using SQL Server Analysis Services (SSAS) MDX query into Variable in Execute SQL Task
What I wanted to do was to get the output from my MDX query, and then use this in SSIS and take the output and put it into an SSIS Variable which could then be used later in your SSIS Package. Example: · We are going to get the Internet Sales Amounts for 2 days. o 01 June 2008…
Book Review – Expert Cube Development with SSAS Multidimensional Models
http://www.packtpub.com/expert-cube-development-with-ssas-multidimensional-models/book This book is a must read if you are looking for some useful and practical information in your SSAS Multidimensional models. But it must be noted that this is not an introduction into SSAS Multidimensional modelling, rather practical real world examples. I found that the book is a wealth of information that can be applied to your working environment….
Excel – User Input for Custom MDX query using VBA and Pivots
I had a requirement where I wanted to do the following for a particular Power User · Give them the ability to put in a Date as a parameter in an Excel Workbook. · Once I have this date, is to the have a custom MDX query, which will then go and get the required data for the date. o …
SSAS – Using the SUM Function within a Measure Group to display a Distinct Count with SSAS (SQL Server Analysis Services)
Whilst completing my review on the Expert Cube Development with SSAS Multidimensional Models, I came across the Distinct Count Measure within SSAS and how this can affect query performance as well as processing performance. You can find the reference on page 114 And here is a link to the actual book that I am reviewing: http://www.packtpub.com/expert-cube-development-with-ssas-multidimensional-models/book What I wanted…
Win Free Ecopy of new book on SSAS
Readers would be pleased to know that I have teamed up with Packt Publishing to organize a Giveaway of the Expert Cube Development with SSAS Multidimensional Models And two lucky winners stand a chance to win ecopy of their new book. Keep reading to find out how you can be one of the Lucky Winners. Overview: …
SSAS – Configuring the Slice Partition in your cube.
After recently going through an online video, I realized that I had not set the Slice option on the partition on a larger cube that I had. And by putting in the slice details this would then enable me to get faster queries when people were accessing the data. Below are the steps that I did in order to…
DAX – Comparing a specific Product Average against the average of ALL products
I had a situation when one of my fellow workers wanted to create a report where they wanted to compare one product’s sales and how it was doing when compared to the average of ALL the product sales. In our example below we want to extract from the AdventureWorksDW2012 Analysis Services Database You can get a copy of…
Power View – Using MDX, SSAS Tabular and Power View to display potential issues based on past trends in data
What I am going to explain below is using the above MDX, SSAS Tabular and Power View to display potential issues based on past trends within our data. For our example we are going to using the example of SCOM data. Within our example we are looking for systems where the available memory has dropped more than 50% of…