Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

25 April
2017
Author: MitchellPearson

Advanced DAX Webinar

Hey Everyone, Thanks for attending the free 1 hour DAX Webinar by Pragmatic Works. In this blog I am going to focus on the primary question that I saw come up over and over again in the chat logs. The webinar can be found here: How come the totals for Forecast and Dynamic are the same? The Grand...
02 August
2016
Author: MitchellPearson

Advanced TSQL Takeover

Thanks for joining the 3 hour webinar I did for Pragmatic Works on Advanced TSQL. There were, as could be expected, many questions regarding the webinar so in this blog post I will try to answer as many of those questions as I can. The TSQL Scripts used in the class can be found HERE: Please note...
20 May
2016
Author: MitchellPearson

How to get Line Item Detail information with Totals in T-SQL (Percent of Parent).

Hi All, This blog post is a follow up to a question I received when I gave my Advanced TSQL Webinar for Pragmatic Works. If you haven’t seen that yet and would like to see it you can view the webinar here:  Question: How can we get SubTotals in TSQL using the CTE method you mentioned? In my...
11 May
2016
Author: MitchellPearson

Advanced T-SQL Webinar / Free Training

Thank You! First of all thank you to everyone who attended my T-SQL presentation on 5/10/2016. We had over 1400 people registered for the training and 871 people joined and listened in, that’s a lot of people! I also received a lot of good and encouraging feedback so thank you for that as...
24 April
2016
Author: MitchellPearson

MDX CALCULATION WIZARD – 12 Awesome MDX Calculations

12 MDX Calculations for your SSAS Cube: If you have suddenly found yourself in a situation of having to improve the functionality of your cube with MDX Calculations but you don’t know MDX then you have come to right place!  Learning MDX can be a difficult task and one that can take some time, and...
16 February
2016
Author: MitchellPearson

MDX ISEMPTY function to return products with no sales.

Have you ever wondered how can I return all my non selling products in MDX? Well, if you found your way to this post hopefully you have! Fortunately this is actually quite easy to do. ISEMPTY FUNCTION The ISEMPTY function returns a BOOLEAN value. If the cell evaluated is empty the value of TRUE...
16 February
2016
Author: MitchellPearson

MDX ISEMPTY function to return products with no sales.

Have you ever wondered how can I return all my non selling products in MDX? Well, if you found your way to this post hopefully you have! Fortunately this is actually quite easy to do. ISEMPTY FUNCTION The ISEMPTY function returns a BOOLEAN value. If the cell evaluated is empty the value of TRUE...
09 February
2016
Author: MitchellPearson

Create and Deploy Perspectives in SSAS

SSAS Perspectives I’m trying something a little different with this blog. I have created a new channel over on YouTube, please feel free to search MitchellSQL and subscribe to my channel! :)Instead of writing everything out in this blog post I created a quick 8 minute...
09 February
2016
Author: MitchellPearson

Create and Deploy Perspectives in SSAS

SSAS Perspectives I’m trying something a little different with this blog. I have created a new channel over on YouTube, please feel free to search MitchellSQL and subscribe to my channel! Instead of writing everything out in this blog post I created a quick 8 minute video. Please watch the video...
08 February
2016
Author: MitchellPearson

MDX NON EMPTY KEYWORD VS NONEMPTY FUNCTION

Hey everyone, in this blog I want to address a very common MDX Question. What is the difference between the NON EMPTY keyword and NONEMPTY function? To take it a step further which one should you use? Non Empty keyword VS NONEMPTY Function. The big difference between the NON EMPTY keyword and...