…brew your own Business Intelligence

Archive for 2013

2013 Year End Review: Leveling Up

Those who regularly follow this blog may have noticed a sudden drop off in content over the past two months. Without going into the details, work picked up substantially and left me very short on free-time. Additionally, I’ve been spending a lot of time on a few side-projects that should […]

Read more

Presenting @ SQL Saturday Nashville

I recently received confirmation that I have been selected to speak at SQL Saturday Nashville on 1/18/2013. This will be my second SQL Saturday speaking engagement and just like the first I’m completely surprised and totally honored to be selected. I’ll be delivering a session just before lunch focusing on the […]

Read more

Conformed Dimensions: the Key to Cross Process Analysis

Over the past few months, I’ve been spending a lot of time reading about, thinking about, and working on conformed dimensions for a client.  The reason is simple, conformed dimensions enable businesses to track richer (and typically more complicated) metrics spanning multiple business processes. Note: there are many additional benefits […]

Read more

Process Multiple SSAS Objects Simultaneously via SSMS

During SSAS development, there are often times when you need to process a subset of objects (ex. dimensions, measure groups, partitions, etc) in a SSAS database. This is especially true when you’re working with a SSAS database containing multiple cubes with shared dimensions. In the past, to accomplish this task, […]

Read more

BISM Tabular – Proceed with Caution

This year I’ve given a few presentations on a topic near and dear to my heart.  The presentation is titled 20 Minute Tabular Model and one of the major components of the presentation involves a high level compare/contrast with SSAS Multidimensional.  The reason this session is important to me is […]

Read more

Creating a Pareto Chart in SSRS

Recently, I created an SSRS report which used pareto charts to help a client analyze the impact of unplanned events in their production facilities across multiple dimensions (ex. Location, Equipment, Reason Code etc). In this post I’ll walk you through the steps to re-create this report based on the AdventureWorks […]

Read more

Pareto Analysis

Pareto Analysis is a nice technique for exploring the distribution of a measure across its contributors.  Regardless of whether the measure is positive (ex. sales amount) or negative (ex. production defects) the goal is the same. In many cases, the bulk (~80%) of a measured quantity (ex. sales amount) is contributed by […]

Read more

Come see me present!

Here’s a just a quick update on a few speaking engagements lined up for the near future: SQL Saturday – Charlotte BI Edition (10/19/2013) Right on the heels of PASS Summit 2013, this SQL Saturday is more awesome than usual since it’s heavily geared towards the BI crowd!  Lots of […]

Read more

Great Demo of Power BI’s Q&A Feature

This is probably the best demo I’ve seen covering the new Q&A feature for Power BI:  The guy asking questions, Mark Reguera, was a non-technical finance guy @ Microsoft who started using PowerPivot/PowerView within his department.  His methods gained traction and now I believe he’s transitioned into more of an […]

Read more

SQL Server 2012 Certification Path Completed

This past weekend, I passed the 70-462 exam which completes the requirements for achieving the MCSE Business Intelligence certification.  This exam had been lingering for quite some time and I continued to put it off because, to be completely honest, I just don’t find the material as interesting and would prefer spending my […]

Read more