SQL Server Analysis Services features nine different data mining algorithms that looks for specific types of patterns in trends in order to make predictions about your data. This is a potentially very powerful tool and since I’ve been learning more about data mining recently I figured I’d put together a little bit of information and … Continue reading
If four years ago you had told me that I’d be working for a company like Pragmatic Works, I wouldn’t have believed you. Simply put, working at Pragmatic Works and doing what I do is the best job I’ve ever had, for many reasons. Here’s a few of them. The culture at Pragmatic Works is … Continue reading
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 order … Continue reading
The MDX function, Descendants, is a very versatile and commonly used function that returns the members at, below, or even above a specified level. The first argument of the descendants function is a member or set expression. The second argument can either be a specific level expression or a number indicating the number of levels … Continue reading
Regular Expressions are a powerful way for you to search for patterns in strings of text. In SSIS, we can leverage Regular Expressions to assist us in cleansing data. I’m going to show you a couple different ways we can accomplish this task. The first method involved using a Script Component within a Data Flow … Continue reading
One of the nice things about a stepped report is that the child groups are displayed beneath the parent groups but within the same column as the parent group. In the next several steps, I’m going to walk through creating a basic stepped report using the Tablix data region. I used the Matrix data region … Continue reading
