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.

04 August
2017
Author: MitchellPearson

Power BI–Problem, Design, Solution (Text Search)

  At the end of this blog there will be a video that walks you through the solution in depth. In this installment of the Problem, Design, Solution series we are going to show you how to perform a text search using slicers in Power BI, this simulates a “LIKE” type search. In the following...
29 July
2017
Author: MitchellPearson

SSIS Performance Tuning

This is my much overdue follow-up blog from the presentation I gave to the New York SQL Server User Group. In this post, I am going to provide some additional resources to supplement the presentation, check out the following blog post on different performance tuning techniques that can be used...
26 June
2017
Author: MitchellPearson

Advanced DAX: Problem, Design, Solution

Thanks for watching my latest webinar on DAX. If you missed the webinar you can watch the recording here: http://pragmaticworks.com/Training/Details/Advanced-DAX-Problem-Design-Solution I didn’t have a lot of questions from this webinar but I will answer a the ones I did have. Question: What is...
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...