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.

20 July
2015
Author: DustinRyan
DustinRyan

MDX Monday: Calculate Daily Average Sales

Creating an SSAS MDX calculations for daily average sales is a pretty common requirement I’ve come across as a consultant for Pragmatic Works and as the instructor for Pragmatic Works Introduction to MDX class. Because of this and the fact that many people often come to me with their MDX...
14 July
2015
Author: DustinRyan
DustinRyan

Make a Difference as a Thought Leader: A Book Review

If you’ve ever spoken at an event like a SQL Saturday or Code Camp, answered a question on a forum, written a blog post, or helped lead a discussion at your place of work then on some level you are already a Thought Leader. If you’re asking what a Thought Leader really is,...
02 July
2015
Author: DustinRyan
DustinRyan

Changes are A’comin’!

Over the last couple days you may have noticed some slight changes on my blog. Well believe you me when I say some more are coming! You may be asking yourself, “Self, what are all these changes for? Dustin’s blog was already great! Why mess with a good thing?” That’s a...
25 June
2015
Author: BradleyBall

Top 3 Questions Before Submitting to a SQL Saturday

Hello Dear Reader!  We are coming up upon the 9th SQL Saturday for Orlando.  Orlando is where SQL Saturday began, and the home to some pretty amazing speakers. We, the SQL Saturday Orlando Team, are hard at work getting ready for the event.  Our Call for Speakers ends on...
24 February
2015
Author: DevinKnight
DevinKnight

Preparing a Technical Session Part 3: Writing an Abstract

So you’ve come up with a great idea for a session and now you have to translate that idea into a thorough abstract that helps both organizers and attendees understand what to expect from your session. This can make the difference between you getting a session at your favorite conference or...
22 January
2015
Author: BradleyBall

Looking Out for Others Helps You Lead

  I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go to sit down and notice the seat to my left has water on the seat. Not so deep that it is a puddle. 5 to 10 big drops. Enough that you wouldn't want to sit in it. The person who this seat...
31 December
2014
Author: DevinKnight
DevinKnight

Preparing a Technical Session Part 2: Coming up with a Title

Earlier this month I began a blog series on preparing to do a technical talk. In that first post I discussed some strategies for coming up with a topic, which is ultimately the first step in your preparation. In this post I’ll walk you through some tips for coming up with a title for...
06 August
2014
Author: TyroneBrown

Visual Studio 2012 Error when executing SSIS package in SSDT 2012:

Earlier today I came up when executing a SSIS package on a workstation that recently had SQL Server Data Tools for Visual studio 2012 installed. It says, “Method not found:...
21 July
2014
Author: MikeDavis
MikeDavis

Make an SSIS package Delay or Wait for Data

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in a SQL table. When the table has data then the package will begin. First we will create two variables...
30 July
2013
Author: MitchellPearson

Remove unwanted characters from your data set quickly!

Today I worked with a client who was pulling some data in from a proprietary source and he had two special characters that showed up randomly in one of the columns in his data set. These characters were the hash tag (#) and semi-colon (;). One or both characters would appear at the beginning, end...