…brew your own Business Intelligence

Blog

SSAS Tabular: Scale-Out Query Architecture

Earlier this week, while discussing high-concurrency architecture options for SSAS multidimensional, a colleague asked about options for SSAS tabular and mentioned there was very little information available online specific to tabular…and so, a blog post is born. The short answer is that Scale-Out Query Architecture for Tabular is essentially identical […]

Read more

Speaking at SQL Saturday #320 – Raleigh, NC

I know, I know… a terrible lack of content here over the past 2 months. Work has been crazy busy since July (read: 65+ hr weeks) and culminated in a (mostly) disconnected and work-free vacation with my favorite wife involving an in-no-hurry drive up the Pacific Coast Highway from San […]

Read more

Jar-O-Skittles: Benefits of Table Partitioning

Quick note to the regular reader: don’t worry, still planning on finishing the series on Building a Scale-Out OLAP Farm in the Cloud with Azure VMs. But I’m afraid there’s not much time to work on that until we ship some important code (which I’ve been working around the clock […]

Read more

Building an OLAP Farm in the Cloud with Azure Virtual Machines – Part 1

The “OLAP Farm” is an Analysis Services architecture that makes use of remote partitions on the backend and linked dimensions and measure groups on the front end in order to support solutions where datasets and latency requirements simply can’t be handled by a single processing server. It was discussed in […]

Read more

SSAS Scale-Out Architectures

Processing can be a very resource intensive task which will absolutely interfere with query performance when using a single server deployment. Most clients can get around this issue by simply processing after hours and/or designing and implementing a complex incremental processing scenario (e.g. process add + process partitions). However, when […]

Read more

Case Study Review: Using Tabular Models in a Large-scale Commercial Solution

Just a few days ago, a case study was released by one of the top Microsoft BI folks in the world – Alberto Ferrari (b | t) – outlining the evaluation process of using SSAS Tabular in a large-scale commercial solution. This paper is a must-read for those considering the […]

Read more

MDX: MemberValue vs Member_Value

Lately I’ve been doing a bit of MDX performance tuning and during the process I learned a new “trick” that blew my mind. Instead of just outright telling you what it is, I’d like to show you through an example. Original Query Take the following query shown below – which […]

Read more

Relationship Between Statistics and Probability

As part of my plan for edging over to the field of predictive analytics and data mining, I’ve been brushing up on some statistics via Coursera and Udacity classes. In one of the Udacity classes (Intro to Statistics), the professor (Sebastian Thrun) presented the relationship between statistics and probability as […]

Read more

Data Mining and Predictive Analytics Learning Plan

In the last post, I mentioned that I would be putting together a learning plan to facilitate a shift in focus from SSAS into the realm of data mining and predictive analytics. Clearly this is not going to be a quick and easy journey – but I think it is […]

Read more

Why I spent > $2000 to attend the PASS Business Analytics Conference

…and was it worth it? Aside from the fact that I’m an independent consultant – which by definition means I no longer have a company shelling out the cheddar to send me to events like this – I’d like to discuss the reasons why I decided to spend over $2k […]

Read more