Monthly Archives: June 2008

Binomial distribution for a KPI status (part 2)

In the last post we discussed some background on statistics. Now let’s turn this into a KPI target. If the parameters of the test are well known in advance the limits for our KPI can be computed for example using … Continue reading

Posted in Allgemein | Leave a comment

Great video on Data Mining available at Microsoft homepage for free

Rafal Lukawieki did a great presentation about data mining. The video is available at the Microsoft homepage and it’s actually a level 400 session (although named "Introduction into Data Mining). But it also contains some background information and overview so … Continue reading

Posted in Allgemein | Leave a comment

Binomial distribution for a KPI status (part 1)

This entry is not much about OLAP or MDX but gives some background on statistical tests that may be very useful in designing meaningful KPIs based on statistical hypothesis tests. In KPIs we usually compare actuals with goals and visualize … Continue reading

Posted in Allgemein | Leave a comment

MDX Studio by Mosha Pasumansky

Mosha wrote a nice tool for testing and debugging MDX queries. It can be downloaded via Skydrive: http://cid-74f04d1ea28ece4e.skydrive.live.com/self.aspx/MDXStudio/v0.2.6/MDXStudio.exe The tool is really helpful and you should check for new releases frequently.

Posted in Allgemein | Leave a comment

Calculating Quantiles in MDX

Microsoft MDX offers a huge set of mathematical function, which can be further enhanced by using Excel-functions. Excel-functions may be called as Excel!functionname but the performance for this approach is not really good. Besides that, not all of your every-day … Continue reading

Posted in Allgemein | Leave a comment

Getting started with Microsoft OLAP and MDX

Fortunately, Microsoft offers the whole starter kit for SQL Server Analysis Services in its SQL Server 2005/2008 Developer Edition. The Developer Edition also includes samples and tutorials to get you started building your own cubes and reports. There are still … Continue reading

Posted in Allgemein | Leave a comment

Article on Datamining in Computerwoche

The Computerwoche, a German computer magazine has just published an article of me about Datamining. The article is in German language and can be found here: http://www.computerwoche.de/knowledge_center/business_intelligence/1863856/

Posted in Allgemein | Leave a comment