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.

16 June
2015
Author: DevinKnight
DevinKnight

Creating a Date Dimension with Power Query

A date dimension or table can be extremely important when working on a Power BI project, or BI projects in general for that mater. Here’s some of the quick benefits and reasons why you need a date table: Helpful when filtering data Filter by year, quarter, month, etc… ...
03 April
2015
Author: DevinKnight
DevinKnight

Power Query – Controlling M Query Functions with User Driven Parameters

Have you ever had a user run a query against one of your largest tables only for them to immediately filter the results in Excel to show the last years worth of data? All of that data brought across your network and then immediately filtered out. Or maybe Excel just can handle the amount of...
31 October
2014
Author: BradleyBall

Tales from the Query Processor III

  https://www.flickr.com/photos/socal_jim/2070088596/   Hello Dear Reader!  It’s that time of year again.  The leaves are turning, temperatures are changing, and Halloween is once again upon us.  Today is Halloween, time to...
06 July
2014
Author: TyroneBrown

Power Query Error: We couldn’t refresh the table… Out of line object … has been specified but not used.

    Earlier this week I encountered a new Power Query error when I attempted to update a Power Query that I had previously created to load a Power Pivot model. Unfortunately, when queries are changed after a Power Pivot model is created, the underlying metadata does not...
31 October
2013
Author: BradleyBall

Tales from the Query Processor: II

Hello Dear Reader!  Today is Halloween, October 31st.  My Daughter turns a big 15 today!  Happy Birthday Ches!!!!! To celebrate two years ago I posted my first Halloween Blog.  Tales from the Query Processor.  It was a lot of fun to write a fiction/horror...
10 August
2012
Author: DustinRyan
DustinRyan

NON EMPTY vs Nonempty(): To the Death!

So what is the difference between NON EMPTY and Nonempty()? I've had this question asked several times and have been meaning to blog it for a little while but here's me just getting around to it. So let's jump right in. We have two queries we're going to take a look at it in...
30 September
2010
Author: DevinKnight
DevinKnight

Writing Parametrized MDX for Reporting Services

In this article, you will learn how to write your own MDX inside of Reporting Services and actually add parameters to the your query. No longer will you be forced to use the Query Designer!

MDX 101: Introduction to MDX
01 September
2010
Author: DustinRyan
DustinRyan

MDX 101: Introduction to MDX

In this article, Dustin will cover the basics of the Multi Dimensional Expression (MDX) Language and introduce you to writing your first MDX statement.

10 August
2010
Author: DevinKnight
DevinKnight

MDX Time Calculations Done the Right Way

In this article Devin shows you a unique way of writing time calculations. These calculations are dynamic so no matter what measure is used it will show it YTD, Previous Period, etc...

15 March
2010
Author: DustinRyan
DustinRyan

MDX Scripting with SCOPE Statement

In this article, Dustin gives you an introduction on using a SCOPE statement to apply custom calculations to specific subcubes within the Adventure Works cube.