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 →Archive for March 2013
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 →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 →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 →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 →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 →