O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Analyzing fluctuation of customers

The analysis of the customers is very important tool. Every company takes care of its customers, or at least it should, because it is relatively easy to lose one while it's much harder to acquire a new one.

In this recipe, we're going to see how to perform the analysis of customers, to get indicators of our success with the customers. Indicators such as the number of loyal customers, the number of new customers, and the number of lost customers. Additional sections of the recipe illustrate how to identify which customers are in a particular group.

The idea is pretty simple to understand, so let's start.

Getting ready

Start SQL Server Management Studio and connect to your SSAS 2008 R2 instance. Click on the New Query ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required