…brew your own Business Intelligence

Archive for March 2013

SSAS Bug: EXCEPT with nested FILTER functions on MEMBERVALUE

Last week while spending some time on the forums, I stumbled upon a thread where the user had presented 2 queries with seemingly identical logic but produced very different results.  After a bit of troubleshooting I was stumped and fired off an S.O.S. tweet with the #ssashelp hashtag.  Within the […]

Read more

Analyzing SQL Server Object Dependencies with NodeXL

One time I was tasked with developing a handful of custom reports for a legacy application.  The data model was an absolute nightmare – overflowing with technical debt and being held together with duct tape and views…tons and tons of views.  In this post, I’ll show you how NodeXL can […]

Read more

Analysis Services 2012: Tabular or Multidimensional?

If you regularly follow this blog, then chances are likely that you are already well aware of the new Tabular mode in SQL Server Analysis Services 2012. If not, don’t sweat it – we won’t be diving into anything super technical in this post  😎 Analysis Services Tabular is a […]

Read more

Top FREE tools for SSAS 2012 Developers

Over the years, I’ve come across a number of tools aimed at helping SSAS developers work more efficiently.  In this post, I’ll share with you the ones I’ve found the most useful and give you a brief explanation of why. Note: Most of these tools were released prior to Analysis […]

Read more

How to Calculate the Median in T-SQL, MDX, and not DAX

Building from my last post, Performance Metrics: Average, Mean, Median, and Outliers, where I covered the topic of when to use Median instead of Average, in this post I’m going (to try) to show you how to calculate the Median of a set of values in T-SQL, MDX, and DAX. Calculate […]

Read more

Performance Metrics: Average, Mean, Median, and Outliers

This weekend, I stumbled across a post that really hit close to home.  The post was written by Brad Feld, a VC whose blog I’ve subscribed to since college.  Brad normally writes about startups, startup-communities, and marathons in which he participates…none of which I’m particularly interested in anymore.  But in […]

Read more